I have a long text file that is beng imported into a Filemaker database. The database is not mine so I can't change how the data is being imported or the format of the imported file. I also can't create custom calculations or add any 3rd party add-ons. Also, it runs in FM 11 and I can't upgrade it to 12.
I do have enough access create new fields and scripts, though. I need to create a calculation that will "grep" the entire line that starts with the word "location." Does anyone know how to do that?
Any help would be much appreciated!