Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting commas | Excel Discussion (Misc queries) | |||
So many commas | Excel Worksheet Functions | |||
removing commas in csv | Excel Programming | |||
help commas before data | Excel Discussion (Misc queries) | |||
Replacing Tab with commas | Excel Programming |