I have a simple table that I have been successfully exporting to a csv text file. The first record has the field names written to it.
When I run the export (from the file menu or from within a script), there is a field in the first record that consistently and repeatedly changes what ever is in that field to a 0. e.g. export changes 'Qty' to '0'.
I have tried different Output file Character sets, recreating the data in FMP and closing & opening the file - all to no avail.
The only change that has been made to the file, is to change the data type for that field from text to number as I want to use sum summary on the qty field.
By accident, I created a tab delimited output file that did not change the 'Qty' to a '0'....
Does anyone have an insight as to why this is happening?
OK, I found the fix!
By selecting the tick-box (bottom left of the 'Specify Field Order for Export' window) "Apply current layouts data formatting to exported data" the issue is resolved. I think when I first saw this, I read it as referring to text formatting, though that doesn't really explain why it only happened with a csv file and not a tab delimited file does it?