Comas instead of dot exporting file from Tibco Spotfire Analyst to csv file.

[Tatjana Kliosova]

Why when I exporting table from Tibco Spotfire Analyst to .csv file there are Comas instead of Dots separates columns. I can't open or read file in excel then. I have English (US) language set up in PC. How can I change this

[Kirsten Smith (she/her)]

Are you saying that there are commas between the columns in your data That's what .csv stands for - "Comma Separated Values" - and it should be easily read by Excel.

[Tatjana Kliosova]

Till that time .csv file were opened like excel, and looks like excel table. Files exported from Tibco Analyst I see not like excel table, but like one row with data in each cell. I see a lot of data in one cell separated by coma. like this:

0,236544,tap,266 and so on

and want to see  like this (each meaning in separate column)

0	236544	tap	266
0	236545	tap	278
1	236546	tip	278

 

[Gaia Paolini]

can it be a problem with your locale If are on Windows, you go to Control Panel > Language > Change date,time or number formats, go to Additional Settings and check both the decimal symbol and the list separator. It would be specific to the Format you chose on the top of the Formats tab. 

[Kirsten Smith (she/her)]

You might also try associating *.csv files with Excel to confirm that they open properly in Excel. Click on the Search box in Windows and search for 'File Associations' and select "Choose a default app for each type of file". From here you can link *.csv with Excel, which should help this issue.

[Tatjana Kliosova]

Thanks for idea, but Excel file was already default for .csv. This is not helped.

[Tatjana Kliosova]

 I did Additional Settings and changed both the decimal symbol and the list separator in different ways, but it still the same result. I chage regional settings from US to European, but the result still the same. /modules/file/icons/x-office-document.png visualisation_csv.docx

[Kirsten Smith (she/her)]

Can you attach the *.csv file that was created by Spotfire export so we can take a look at it

[Tatjana Kliosova]

.csv fail in attachment

[Kirsten Smith (she/her)]

Thank you for sending the file. I can see the problem with this file - each line is surrounded by quotation marks (") so it is being interpreted as being a long string instead of distinct columns. Please provide the exact steps you used to create this file by exporting it from Spotfire, as the quotation marks shouldn't be there.

 

That being said I did a quick test of exporting data from Spotfire and I encountered the same issue, even though my *.csv file did NOT have the quotation marks around each line. I Googled this issue and found a few resolutions.

 

1. In your Control Panel/Regional Settings, make sure your 'List separator' is set to a comma. Mine already was, so this didn't resolve anything for me, but if yours is set to something else try changing it to a comma. You may have to restart your machine to affect the change.

2. Change the encoding of the file. If you open the file in Notepad++ you can click on Encoding to change it to UTF-8, which should resolve the issue.

3. Add a line to the top of the file, so it looks like:

sep=,

col1,col2,col3

 

Hopefully one of these solutions will help resolve the issue, once your exported data doesn't include the quotation marks.