Capturing Filename

[Mark Hardee]

Hello all.. I swear I have done this before, but, am filed with Brainfade at the moment.

Filemaker 10 Adv.

Working on a solution to produce data for shelf talkers for a client. Data import issues have been resolved and would definitely like to add a very important field to each file that is imported. Hundreds of files to import each time with filenames like "Signs_00001_725351.txt". These are pipe delimited and have done all of the calculations to import the data into the correct field. Each file may contain 100 - 200 records and there are proposed to be 700 or so files each time.

What I would LOVE to have happen is during import, could I grab a portion of the filename of the current external file being imported and either:

Have it imported into all of the current found set (during importing) or at the very least put it into the first (or last) field and script the copying of the data from the populated field to the rest of the remaining records for that import?

Evidently, the identifier for either the store or type of shelf talker exists only in the filename itself..

Thanks for any directions anyone can offer...

Update: I found a solution to do this:

http://fmforums.com/forum/topic/65562-create-batch-import-script/page__view__findpost__p__310812

THANK YOU Post Master General!!!

Edited June 17, 2011 by Mark Hardee