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,