csv with embedded commas???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

misscrf - 26 Jan 2007 04:19 GMT

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 <johnsmith@gmail.com>,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,

Reply to this Message

NickHK - 26 Jan 2007 05:35 GMT

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

> 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
[quoted text clipped - 7 lines]
>
> Thank you,

Reply to this Message

misscrf - 26 Jan 2007 13:58 GMT

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.

Reply to this Message