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