Import text file and display in a field

[Remi]

Hi all experts,

I am having trouble with this:

- I want to import a text file

- Then, display the text (in the text file) in a field I want.

Is there a work-around way on this?

Thanks for every reply.

Remi

[QuinTech]

Hi, Remi. If you've tried importing the file, i imagine you've found that the import procedure recognizes each carriage return/line feed as a new record, thus splitting your data into separate records in Filemaker. There are three ways i can think of to get around this:

1. Paste the text file into a container field. This doesn't exactly meet your request -- that is, the text doesn't show up in a field -- but it's similar. A user could double-click the file in the container field to see the contents.

2. First import the file into a dummy field in separate records, then use a looping script to concatenate all those dummy field into one global field.

3. Use the Troi File plug-in, which allows you to set the contents of a field to the entire contents of a text file.

HTH,

Jerry