csv with embedded commas???
 

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 ,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,

csv with embedded commas???
 

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" wrote in message
ups.com...
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 ,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,

csv with embedded commas???
 

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.