Hi,

First post so excuse my ignorance -can the following be done within FM pro? I have a list as below

J8AAC01

J8AAC02

J8AAC02

J8AAC06

J8AAC06

J8AAC07

J8AAC07

J8AAC08

J8AAC09

J8AAC10

This a sample of a much bigger set-I want to export (into .csv) only 2 out of 10 records. The decison maker would be 5 letters in from the left. So what I want to see is J8AACO1 & J8AACO2 in my exported file. J8AAC| would be the cut-off point. Is there a way of doing this as a calculation for multiple types?

I would have records beginning J8AAC, J8AAB, C2AAB, D8AAB, etc in one large list and I need a calculation that could be applied to ALL records in the list to export as desired

Thanks

Stu

fm forum example.txt

Hello Stu,

Welcome to the forum!

If I understand your question correctly, you can do what you want by performing a find and then an export (exports always draw only on the found set of records).

Since it would seem that you want to ignore the first five characters of the field, your search criteria would have to include five single character wild-card symbols. Thus for the search you cited as an example, you would search for:

==@@@@@01

in a first request, then create a second (simultaneous) find request and enter

==@@@@@02

when you perform the find and export, only records with 01 or 02 in positions six to seven of the field you are searching on will be exported.

If this is something that users need to do repetitively, I'd suggest that you set up a global field (into which they can enter a list of the items they are looking for - eg 01, 02) and a script which converts their input into the appropriate series of simultaneous find requests, performs the find, exports the csv, then returns the database to the user.

Ta much my friend-that gives me the basis to get some scripts done

Cheers

Stu

Scotland