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?
You can use new functionality in FMP16 to export with CRLF.
https://fmhelp.filemaker.com/help/16/fmp/en/#page/FMP_Help%2Ftextencode.html%23
https://filemakerhacks.com/2017/05/09/export-field-contents-update-for-fm-16/
There is also a example file to pick up
GitHub : Genecom/FileMakerSampleSolutions: FileMaker サンプルソリューション