I have problems extracting the coordinates, how can I solve it?

Sebastián Vásquez

when I am trying to extract coordinates with Altair Embed it extracts them in a .cvs file but all the information in a single column.

armin_22187

Hello Sebastian, my software tools behave the same. But it is not an error! It is due to a setting in Windows (Region Settings - see picture). The .csv is a ASCII text document with numbers separated by a ' , ' - but xls requests a different character to show the numbers in separate columns.

- you can either change the settings in Windows, or
- you can replace the ' , ' with ' ;' (in my case) in a text editor, load the data into xls, modify them, export them into .csv again, and replace the ';' with a ',' manually in a text editor. Activate requires a ',' when it reads the data.

(please, don't forget to add the time column in the .csv - see last pic )

 

Sebastián Vásquez

armin_22187 said:

Hello Sebastian, my software tools behave the same. But it is not an error! It is due to a setting in Windows (Region Settings - see picture). The .csv is a ASCII text document with numbers separated by a ' , ' - but xls requests a different character to show the numbers in separate columns.

- you can either change the settings in Windows, or
- you can replace the ' , ' with ' ;' (in my case) in a text editor, load the data into xls, modify them, export them into .csv again, and replace the ';' with a ',' manually in a text editor. Activate requires a ',' when it reads the data.

(please, don't forget to add the time column in the .csv - see last pic )

 

Thank you very much, I will apply it, because actually this excel seems to me to be what leads me to this error.

armin_22187

Sebastián Vásquez said:

Thank you very much, I will apply it, because actually this excel seems to me to be what leads me to this error.

let us know if you could resolve the issue....