I'm working on a super top secret project and have a .dat file that I need to import into Filemaker.

Now, I can take the dat file and convert to excel easy enough, but I'm looking to teach filemaker to fish. Is there any way to automate the process inside filemaker?

When I open the file as text it is all % seperated... Like this: 2007%12%10%Monday%08%10%17%

Can I import it into a dummy field and make a script to cut up to the % and paste it into another field?

G$,

You could pull it into a dummy field and use Substitute to change the % characters into ¶.

This will make the field contents into a value list. From there, it should be easy to use the value list functions to handle things.

You could skip the substitute process and instead use the patternCount and Position functions. This approach would be a little more complicated to write... personally, I'd go with the first method.

Regards,

Don