Export .csv file format problem

[FMphile]

Trying to found out why it is necessary to run a csv file through Mac Numbers (it is not recognized by Mac Excel), i.e., by importing into Mac Numbers and then exporting again as a csv file before it will be accepted by an external system. Looking at the "before" and "after" csv files with TextEdit, the "before" file appears to be blank, the "after" file is what you would expect - text with commas. FM 19 does not seem to have any relevant options to influence the process at all when scripting the Export Records step.

Any suggestions would be greatly appreciated!

[Ocean West]

Script it but save it as merge and use csv as in file name. 
 

or use the file data functions. 

[comment]

Please provide a way to reproduce this problem. Although I do not have Excel installed, I most certainly do not see a "blank file" when I examine a file exported as .csv in a text editor. 

[ggt667]

I never export TSV or CSV from FileMaker, I always export as XML, and then apply an XSLT to generate the TSV, LaTeX, CSV, MySQL, M$SQL, PostgreSQL, StoryBoards, CoreData, REST, DSL, or others to my liking.

Edited June 22, 2022 by ggt667