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 ∩