Delimiter on exported CSV file

[Saubs]

Hello all,

 

I'm exporting CSV files from FM Pro 13 on a Mac, with the first row containing field names and the second row containing one record of data. Our client's business rules require that the end-of-record delimiter specifically be CRLF (Carriage Return + Line Feed) instead of just CR.

 

I've tried various export options/formats but FM seems to only give me CR as the delimiter. I imagine it can be done by post-processing the CSVs, but does anyone know if/how it can be accomplished natively in FM?  And if you have any suggestions for the post-processing approach, I'd be interested in hearing about that too.

 

Thanks very much--

[comment]

You could export as XML - see:

http://fmforums.com/forum/topic/48901-exporting-to-a-csv/?p=228807

[Wim Decorte]

 

 

 And if you have any suggestions for the post-processing approach, I'd be interested in hearing about that too.

 

 

Since the export is on a Mac, you have a wide pick of OS-level technologies to do this: AppleScript, Shell script, Ruby,... whatever you are comfortable with / proficient in

This kind of post processing is fairly straightforward and fast.

 

In the scripted workflow in FM, you execute these through the Perform AppleScript script step or the Send Event script step.

[Fitch]

Last but not least, you could do it with a FileMaker plugin such as BaseElements or Troi File.