CSV might not be the best choice

oh

well bitch at yourself

I'm the one that ran intake on all of this

I'm required to mark the composers

.tsv would be better if you can choose the export format.

ok so what did you pull from?

mp3 tags?

reading the mp3 tags on the file?

Yes, the tags on the MP3s

Same as csv but uses tab as the delimiter and can be read just about the same.

yeah tab delimited would be better here

because its very hard progmatically

So here's the thing. it might be able to do some backtrack nonsense to regex it. But you'll need to tell us what you know about each field.

to determine a comma that needs replaced

on any random line

its better not to do it from the beginning

Like, you'll have to be able to tell if the comma is separated somehow from the composer or the delimiter.

honestly

and you mgiht not like this

So you'd be counting characters between commas and guessing what kinds of things go in each field.

XML is probably better here

XML isn't possible.

xml is always possible

All the reporting guys REQUIRE CSV.

I'm caged in on this one.

FCC?

No.

BMI, Sesac, Ascap, Soundexchange

Even worse.

then you need to pick another character to seperate artists and be done with it

Yup.

A committee of committees.

and live with it

What options do you have to separate artists?

semicolon is actually not a bad choice tbh.

; actually isn't bad

it just can't be comma.

Really...

Welcome to csv...

use ∩

the best you can do

Next time let me tell you about the time I had several terabytes of csv files with formatting issues.

depending on the importing logic

is you might be able to quote each line

random alt+3nums for the win!

but straight up, it'll just import the quotes

God.

I hate bad people.

Who's with me?

Nothing I hate right now is human.

Including myself.

bad people have their uses. Not many, but a few

They're like slinkies.

They bring a smile to your face when you throw them down the stairs.

I mean, according to the music industry all girls like bad boys.

You're terrible Rye.

lmao.

That's because we tell them that good boys are those that follow their every whim

Bonus points for throwing them down up escalators.

Wasnt that asian girl part of bully hunters?

Anyways, how's the csv coming?

I just threw an emergency stop on my station. That should give you a hint about it...

I mean, have you figured out a good seperator.

I've got to experiment with a few things.

defcon 1?

Use ╔£╤◄

@RyeNorth let us know when you've got a separator or something. I actually need to go offline for good soon.

Computer needs work and I won't be online for another week or so.

I don't know that I'll have a solution any time soon

I'm checking this, and apparently there was a problem with ; as well.

can you use /

hm. Well, Lotheron seems to be pretty aware of this stuff too.

Artist1/Artist2/Artist3

also, tell them to use xml next time haha

I can't tell them shit.

yeah I was being facescious

okay.

I'm seeing instances of commas not screwing everything up.

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

are the values quoted