Freelance Import FMP Script Work

[Otis]

Hi all, I'm a fileMaker pro developer, and I've reached a snag in my project. I need to create a script in FileMaker to import data from a nice clean formatted TXT file. This is just text, but it's not comma or tab separated, and there are field names mixed in with the data.

The script would need to remove all spaces, and isolate/ignore field names, yet pull the field data into the proper FileMaker Pro fields. It's over my head.

I have attached a ZIP file with a sample of the type of text I need to import into FileMaker. This simple text file contains two records and you can get an idea which text is the field name and which is the data by looking at the formatted file. You can also see which formatting patterns are consistent over multiple records, etc. (Again, this file is just a sample. Some TXT files have just one records, others may have 100 records.)

Please contact me if interested with your estimated cost for this service.

Email is: mike [at] kitchenbitchin.com

Workout_Data2_txt.zip

Edited August 30, 2007 by Guest
This is slated for FileMaker Advanced 8 and above

[Lee Smith]

I looked at the sniplet of text, and it really is hard to tell from it, how consistent the field structure is from record to record. In other words, is there always a field, even if there isn't any data in it? I started parsing your file, and I see that the answer to my question is "No", I think.

IMO, you should first clean up the data. Either by changing it at the source (probably not an option), or by parsing out the garbage in a text editor. You will need one that has the ability to use RegEx, and Grip pattern Find and Replace. On the Mac, you could use BBEdit, or TextWrangler (TextWrangler is FREE from www.barebones.com)

I also think you should first parse out these two examples in to a file, so that we can see how to break down the data.

HTH

Lee

[Tusif Ahmad]

Hi,

I studied your file just now. Tell me how many records or files are? Let me have the idea of complete data qty wise.

I can try in making the scripts and I have done similar type of job before.

If its not big can you send me complete job so I could try.

As soon as I will get something more clear.. I will let you know.. cost of service.

Regards,

Tusif Ahmad

[Otis]

Thank you both for your interest, but I was able to hire a developer to work on this for me.

The moderators can close this thread. Thank you.