Export to CSV, strange Excel File

[Gilles Plante]

Hi,

 

I am running version 17.0.2 and for a specific table, when I export to CSV what I get in the file is strange. This is what I get:

 

Row 1 to 11 are almost right (but for strange characters like the A with a tilde). But then from 13 it's getting wild. At some point further down it's getting back Ok for a while and then it turns wild again.

What is the explanation for that ? And strangely if I import into FileMaker it's Ok.

Thanks

 

[Dave Ramsey]

Hey, Gilles,

Excel has its own particular rules when it comes to CSV, particularly related to Unicode and line feeds.  I did optimize that export for feeding back into FileMaker.

It's been on my agenda to do some further checking to see if I can determine why Excel is being funky... But that agenda is a long list.