I am using the Export Records script step to export a file of tab-separated values. These are payment instructions for my bank which has very specific requirements for the data format.
I'm using FileMaker 16 on current Mac OS, and the line breaks in the exported file are Mac OS 'Carriage Returns'. The bank's system doesn't see them: it only sees one long line of text and the import fails.
I am currently manually opening the exported file in a text editor and changing the line breaks to Carriage Return Line Feeds there.
How can I export this with CRLF's as the line breaks please?
Here is another SIMPLE method to export a tab-delimited file with CRLF line endings. Again, no calculation fields or scripts to collect data - all that's needed is a single global container field. Requires version 16 or higher.
Note: this uses Filemaker's native export to tab-delimited file, so no header will be generated automatically. But it is possible to add a custom header at the conversion stage.