Message from @LotheronPrime

Discord ID: 474717903048933377


2018-08-02 23:16:05 UTC  

it probably is but youc an't tell

2018-08-02 23:16:17 UTC  

a comma in a csv always determines a new column

2018-08-02 23:16:22 UTC  

unless its' escaped

2018-08-02 23:16:33 UTC  

https://cdn.discordapp.com/attachments/463054787336732683/474717173315534848/unknown.png

2018-08-02 23:16:37 UTC  

and even then you can't know that the algoritm ingetsting it can handle those

2018-08-02 23:16:47 UTC  

I'll help as long as I'm still online.

2018-08-02 23:16:57 UTC  

well there you go, what's the problem?

2018-08-02 23:17:15 UTC  

https://cdn.discordapp.com/attachments/463054787336732683/474717346448015391/unknown.png

2018-08-02 23:17:22 UTC  

It didn't fix anything.

2018-08-02 23:17:37 UTC  

Is this imported into a webpage or a standard program?

2018-08-02 23:17:43 UTC  

^

2018-08-02 23:17:44 UTC  

https://cdn.discordapp.com/attachments/463054787336732683/474717471031558145/unknown.png

2018-08-02 23:17:47 UTC  

like excel?

2018-08-02 23:18:18 UTC  

It's excel.

2018-08-02 23:18:22 UTC  

Well

2018-08-02 23:18:27 UTC  

the Libre version of it.

2018-08-02 23:18:39 UTC  

is there something like this in the csv date,"producer","title", "artist1, artist2, artist3",format

2018-08-02 23:19:05 UTC  

Played,Performances,Duration,Media Type Code,Artist,Title,Album,Composer,Isrc,Label,P-Line,Catalog,Universal Product Code,Year,Website,BuyLink,Has Leading Track,Has Trailing Track

2018-08-02 23:19:09 UTC  

Ohhhh. Excel. That's actually not so bad.

2018-08-02 23:19:18 UTC  

no, I mean in one of the lines

2018-08-02 23:19:27 UTC  

are the values quoted

2018-08-02 23:19:39 UTC  

No.

2018-08-02 23:19:56 UTC  

no sure how the hell it can determine some are multiple and some arent then

2018-08-02 23:20:01 UTC  

unless hidden characters

2018-08-02 23:20:02 UTC  

Wait... WAIT

2018-08-02 23:20:17 UTC  

?

2018-08-02 23:20:30 UTC  

Also, Excel should let you specify delimiters.

2018-08-02 23:20:35 UTC  

``08/01/2018 01:03:23,0,268956,MUS,Dick LeMasters,"One Bird, Two Stones","One Bird, Two Stones",Claude Richard LeMasters,USZZ51401511,Small Stone Records,,Longneck Road,,2003,,,False,False
``

2018-08-02 23:20:40 UTC  

yup

2018-08-02 23:20:44 UTC  

use quotes

2018-08-02 23:20:46 UTC  

done

2018-08-02 23:20:54 UTC  

But why did it get quotes...? o_o

2018-08-02 23:21:03 UTC  

That's not in the metadata...

2018-08-02 23:21:30 UTC  

how are you generating the csv?

2018-08-02 23:21:38 UTC  

a program or ?

2018-08-02 23:21:46 UTC  

Imported from SAM Broadcaster.

2018-08-02 23:21:58 UTC  

I dunno what that is

2018-08-02 23:22:04 UTC  

Does Libre ask anything on the import into the Excel variant?

2018-08-02 23:22:05 UTC  

but whatevers scanning the files and the mp3 tags

2018-08-02 23:22:16 UTC  

It does. Let's see...

2018-08-02 23:22:17 UTC  

is probably adding the quotes around lines with , in the field