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 <(E-Mail Removed)>,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,

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 <(E-Mail Removed)>,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,
>

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.