Message from @pratel
Discord ID: 474714805249376257
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.
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