AnsweredAssumed Answered

csv vs tab separated differences?

Question asked by makerbert on May 28, 2015
Latest reply on May 28, 2015 by makerbert

I need to export locationvalue data to an external program, I calculate latitude, longitude and accuracy from the original textfield but when I export to a TAB separated file I get something different from exporting to a CSV.

 

TAB export:

6-3-2015 9:57:19Thingie+52.249694, +5.924651, +10.0000005.92465152.24969410.000000
9-3-2015 11:46:53Thingie+52.239393, +5.922827, +10.0000005.92282752.23939310.000000

 

CSV export:

"6-3-2015 9:57:19","Thingie","+52.249694, +5.924651, +10.000000","5924651","52249694","10000000"

"9-3-2015 11:46:53","Thingie","+52.239393, +5.922827, +10.000000","5922827","52239393","10000000"

 

Besides the obvious double quotes and comma's vs the tab characters the unexpected difference I see is the decimal point which is disappeared in the CSV, This renders the location data (last three columns) useless.

 

In exporting to MER format I sort of get the best of both worlds:

Tijd;KenmerkNaam;Plaats;X_lon;Y_lat;XY_Acc

"6-3-2015 9:57:19";"Thingie";"+52.249694, +5.924651, +10.000000";"5.924651";"52.249694";"10.000000"

"9-3-2015 11:46:53";"Thingie";"+52.239393, +5.922827, +10.000000";"5.922827";"52.239393";"10.000000"

 

and when exporting tot .XLSX the decimal points are again disappeared

 

Trouble is my external program can read CSV and XLSX but no TAB or MER

 

- Why is exporting in Filemaker altering the decimal point depending on the format I use?

- How can I influence this behaviour?

 

I could of course use notepad++ or something to manipulate the MER but since it will be an automated process I would like to weed out any unnecesary steps.

 

All help appreciated!

 

regards,

 

Bert

Outcomes