List Info

Thread: Delimited Text File




Delimited Text File
user name
2006-07-25 09:49:17
Taking the string:
fred,"comma,comma,comma","quote" the
aim is to get rid of the commas
inside the double quotes (between "comma") and
replace with a |.  Note
that some text may not be quoted as in the case of fred.
Sergei - Your pattern seems to identify the first comma,
third comma
and the forth comma?
Xichencg - The results of your pattern show fred||
Thanks for your help guys.
I need the final result to read:
fred|"comma,comma,comma"|"quote"
I also need to get rid of the double quotes after the first
replace but
that is easy to do as a second replace after the commas are
fixed.

Thanks again
David


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Regex" group.
To post to this group, send email to regexgooglegroups.com
To unsubscribe from this group, send email to
regex-unsubscribegooglegroups.com
For more options, visit this group at http://groups.go
ogle.com/group/regex
-~----------~----~----~----~------~----~------~--~---

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )