csv with embedded commas???

[misscrf]

I have a csv. There are no text " delimiters. I am trying to validate
the parsing, but within some fields there are embedded commas. This is
in fields that have things like an email where it might say:

2/24/2006,1:23PM,Smith, John <[email protected]>,next field,next
field,etc

I can't seem to figure this out. Can anyone help me to get this to
parse right?

Thank you,

 

[NickHK]

The best solution would be to correct the output file to delimit the text
fields correctly, otherwise how can you know which commas are delimiters and
which are actually text ?

If this is not possible and the format is consistent, maybe:
-Find the first "PM"
-Find the first "<", assuming it cannot appear in the name
-Take everything between the 2 values above to be the name.

NickHK

 

[misscrf]

Thanks for the reply. Unfortunately, I have no control over the
output. I wish I did! lol.

I think I am going to start from scratch as the file was less of a mess
when I started cleaning it up, vs now.