Simple Export log request?

February 6, 200817 yr

Hello all,

Attached is the sample of my question. In my program, I would like to make a log file. The thing is, when I am creating a log file, on FileMaker, it would show the New line, however, when I tried to export it to TXT or Log file, it would contain the "square bracket."

The thing is I want to achieve the information in the log file like this:

Hello

How are you?

Testing 1.2.3..

So, if you run my script, it would generate "test.txt." The correct result that I want is "TestCorrectResult."

Maybe I missed something simple...

Thank you for your information and help.

test.zip

February 6, 200817 yr

Hi Henry, you are trying to export a character (Carriage Return) that is a reserved character in a .tab or .csv extension. A Carriage Return is used to seperate records in .csv or .tab file. Therefore if you try to export a field that contains carriage return some other character must be substituted for the Carraige Return.

Filemaker does have the Export Field contents step which produces a file that that looks very similar in notepad to your test.txt file. However the square bracket substituted for a Carriage Return is actually a different character. There are other differences you could see with a Hex Editor but I don't think we need to go into that.

Long story short:

1) Use Export Field Contents to create a "text" file.

2) Import the "text" file into a new table with one field. This creates a new record for each "line" of your original text.

3) Export the records in the new table to a new text file (with the "Save as Type set to Tab-Seperated (*.tab).

4) Open the new text file in Notepad and I think you will have the results you want.

*** Note: the above would require no Tabs be used in your original text.

P.S. Fenton has suggested an XML export in other posts with similar questions. You may want to take a look at those posts as well.

Edited February 6, 200817 yr by Guest