Message from @LotheronPrime
Discord ID: 474717903048933377
it probably is but youc an't tell
a comma in a csv always determines a new column
unless its' escaped
and even then you can't know that the algoritm ingetsting it can handle those
I'll help as long as I'm still online.
well there you go, what's the problem?
It didn't fix anything.
Is this imported into a webpage or a standard program?
^
like excel?
It's excel.
Well
the Libre version of it.
is there something like this in the csv date,"producer","title", "artist1, artist2, artist3",format
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
Ohhhh. Excel. That's actually not so bad.
no, I mean in one of the lines
No.
no sure how the hell it can determine some are multiple and some arent then
unless hidden characters
Wait... WAIT
?
Also, Excel should let you specify delimiters.
``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
``
yup
use quotes
done
But why did it get quotes...? o_o
That's not in the metadata...
how are you generating the csv?
a program or ?
Imported from SAM Broadcaster.
I dunno what that is
Does Libre ask anything on the import into the Excel variant?
but whatevers scanning the files and the mp3 tags
It does. Let's see...
is probably adding the quotes around lines with , in the field