AnsweredAssumed Answered

Exporting Carriage Return LineFeed Characters in FMPA10 on Mac

Question asked by tommcin on Dec 25, 2009
Latest reply on Jun 21, 2015 by alice07

Title

Exporting Carriage Return LineFeed Characters in FMPA10 on Mac

Post

I am trying to create a text file for input to a Windows Script.  They want a CR LF (x 0D0A) between each record.  I created CRLF_g using Code(13) & Code(10) and appended it to each line.  The control characters seem to be there using Char(field) where the fields are the last characters in the string.  But strange things happen.  Code ( last character ) displays 1000013

 

When I export the individual records  the  last characters in each line come out as  x0B0B0D. when I view the file with HexEdit.

 

When I concatenate all the records into one global field and export the field, I see  00 0D 00 0A at the end of each record.  This seems to be in two byte unicode as there is a  00 byte between each character.  All the hex characters match to what is in the original Filemaker databases.

 

How can I get the 0D 0A to be inserted into an Exported text file in the single byte format.

Outcomes