loading
 
write variables csv format
pat from United States  [13 posts]
8 year
I generated some blobs in geometric statistics module, then I used the write variables module with settings in attached jpg (CRLF, comma), but when I double click the csv file, excel load it into a single row of data with semicolon delimiter (see attached jpg).

I want to get three columns of data in excel (AREA, COGX, COGY) with each blob in a row, what are the right settings?

  
Steven Gentner from United States  [1446 posts] 8 year
Pat,

I don't have Excel handy (we use OpenOffice which asks what delimiters are used) but have you tried using tabs instead of commas? I'm not sure what the default CSV settings of Excel are. Perhaps

https://support.office.com/en-us/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba

is more use in your case.

STeven.

This forum thread has been closed due to inactivity (more than 4 months) or number of replies (more than 50 messages). Please start a New Post and enter a new forum thread with the appropriate title.

 New Post   Forum Index