Field Contents to list

[Macman]

I have a database that has one field that has many different numbers, all separated by commas, such as:

6565, 6723, 6892

What I am trying to do is export these fields from a found set, and create a new list of these numbers individually as separate records. Example:

6565

6723

6892

I can export the contents of the field with no problem, but getting them to import as separate records has been impossible! I

[-Queue-]

I believe you'll need to create the new temporary records with the desired data and then export them. There isn't any way (that I know of) to force a carriage return-line feed in a field.

[dbruggmann]

Try this:

1. Export your old number field as tab-delimited

2. Open the .tab file with a word processor

3. Copy the content

4. Paste it in a Filemaker file in a text field named

[-Queue-]

Rereading, it seems it would be much easier to just create the new records using a loop in FM. Do you want the records to be created in the same file or a related file?

[Macman]

Actually I found a solution using Apimac Text Clean - but this was only part of the problem to be solved. I

[fmp7_user_fmp7fmp7]

This is a simular problem to the one I am having:

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=124173&an=0&page=0#124173

Can anyone give it a look. I downloaded apimac text clean but not sure how to get it to do what I want it to do. I am new at FMP and cant get my mind to figure it.