Jump to content

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

Recommended Posts

  • Newbies
Posted

Hi

I have been a .Net and other programmer for many years but only just started doing some work withFM.

I am tasked with writing an import routine from a tab delim file. I have started an import script and set up filed mapping but many of the fields will require massaging after import.

I am loading the ones that need work into temp fields and want then to run a further script to manipulate the data to clean it up and make it more suitable for the new database.

What I can't see is how to get to use all the FM functions I see in the doc files that allow me to do things like string manipulation etc (Right, left, replace etc).

Is it possible to do such things in a script? If so can someone give me a steer to how itis done. Or am I going about this in the wrong way?

Thanks in advance

Mark

Posted

You use those functions anywhere there's an option to specify a calculated result. This includes many script steps, such as If/Else If; Set Variable; Set Field; etc. etc. etc.

Posted

Have you looked at any of the template files that come with FileMaker or at the tutorial (fmp12_tutorial.pdf)? Lots of examples of scripting and calcs are provided there.

Posted

I am loading the ones that need work into temp fields and want then to run a further script to manipulate the data to clean it up and make it more suitable for the new database.

What I can't see is how to get to use all the FM functions I see in the doc files that allow me to do things like string manipulation etc (Right, left, replace etc).

 

Have a look at the Replace Field Contents[] script step:

http://www.filemaker.com/12help/html/scripts_ref1.36.55.html#1029581

  • Like 1

This topic is 4388 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
×
×
  • Create New...

Important Information

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