It's made uneven the first time a coma appears in the metadata

yup

That should be one row, right?

you need to take source data

It occasionally happens in the artist

Ah wait. so like, the comma is in the title?

usually happens in the Composer

yeah

Occasionally.

so

I'd bitch at your source

Ohhh boy. So there is a regex for that.

because they're dumb

I am the source.

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?