Jump to content

Scripting Follies of a newbie


This topic is 7193 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Greetings -- I'm looking to delete a specific set of charachters from a field in about 2000 records. I've tried writing a script to do this, but can't get it down, can anyone help??

Field is a date field and has "0.00" which I'd like to remove but leave the date before it alone completely, field looks like "01/01/01 0.00"

I'm trying the substitute function, but keep getting errors while trying to write it.

Any assistance would be a start.

Link to comment
Share on other sites

Sorry what I meant to say above was this:

You have used a text field to store date information, that's why you are having so much trouble. Always store date information in date fields because FMP (and you) can work with it so much easier.

Link to comment
Share on other sites

quote:

Originally posted by Korky:

If the field is a text field and the date portion is always followed by 'space plus 0.00', the following should work for different lengths of the date portion;

Left (Datefield ,Length (Datefield-5))

...or use Substitute(Datefield, " 0.00", "")

Link to comment
Share on other sites

This topic is 7193 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.