Saving table to csv issue - table column is not csv table column

[johnlock 0]

Hi guys.

What im trying to do.

 

I have 2 lists 

 

text

text1

text2

text3

 

and 

 

addres

addres1

addres2

addres3

 

i'm doing add list to table as column on both of them and now i have table (ubot table) with 2 columns and 4 rows.

When i attempt to save this table (ubot table) to a csv file the output is 4 rows but 1 column with text,addres string (, delimater).

What i want it to do is to put the ubot table second column as .csv or .xls second ( column.

 

How can i accomplish that?

 

Exuse my english.

 

Best regards.

[VaultBoss 310]

Make sure to add the extension .csv, not .txt to the output file, then open it with Excel or Open Office and you will see the columns w/o the comma, just as you wish.

If, however, you open a .csv file with a text editor, you WILL see the comma, it HAS to be there, it is the separator!

 

If you don't want to see the comma at all, you need TAB separated values, but then you won't be able to play with them in UBS properly

[johnlock 0]

This is exactly what im doing... saving the file as output.csv, but the result is same - 1 column, with "," separator, not 2 columns..

[VaultBoss 310]

What sw are you using to view the file?

[johnlock 0]

Microsoft Excel 2010.. 

[VaultBoss 310]

When you try to open the csv file, isn't there an import file screen?
There is something like that, usually called Text import, or some such...

 

If so, tick the 'Use comma as a delimiter' (or some similar verbiage) in options.