On one machine, the csv seems in right format, but another machine the csv file seems not so.
example:
what should i change for the machine which shows me the csv file as the second screenshot?
On one machine, the csv seems in right format, but another machine the csv file seems not so.
example:
what should i change for the machine which shows me the csv file as the second screenshot?
Hi
When you put the CSV file in your spreadsheet editor (Excel, for example), it shows all of the data in a single column, instead of splitting them across columns.
The reason behind this behavior is that CSV files (Comma Separated Values) are splitting data into columns using " , " as separator by default. But in certain countries, the default value used as separator is " ; " instead.
To resolve this issue, within your open CSV file, you can click on the Data tab, select Convert and choose commas.
To change the settings for future Excel documents:
Go to your Settings page clicking on the link in the top-right corner of your screen (You have to be an admin)
In the Localization module, change the "List separator for exports" field to "comma ( , )"
To change the settings for your Windows computer:
Go to Start > Settings > Control Panel > Regional and Language Options.
Click “Customize”.
Enter “,” for “List Separator”
Hi
In North America and some other countries, the default list separator is a comma, so you get CSV comma delimited.
In European countries, a comma is reserved for the decimal symbol, and the list separator is generally set to semicolon. That is why the result is CSV semicolon delimited.
Checkout below link to know more info,
https://www.ablebits.com/office-addins-blog/change-excel-csv-delimiter/
Hello
on one machine, i didnt do any settings, and it seems perfect
but on another machine, its not. There should be some settings that need to be changed on the machine i guess
Hello
on one machine, i didnt do any settings, and it seems perfect
but on another machine, its not. There should be some settings that need to be changed on the machine i guess
Yes please checkout my comment
Hello
when i looked at customize setting(region), list seperator is same for both machines which show me the csv as i wanted, and which doesnt show.
I couldnt understand the other excel solution. This excel is not same, i mean everyday i will get different csv file. but on one machine, everyday it shows me the right format,
but on another machine it doesnt.
Hello
I understand, but i looked at the setting for list seperator on both machines, and its comma.
Even though its comma, the csv which i download using sftp, i see it in nice shape.
but on other machine it is not like that. I try to understand what could be the difference between both machines
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.