Folks, Thanks in advance, but I am struggling with putting together a grep search.
I have Excel created .csv files that I have to parse. Excel has a "feature" where it incodes commas in a field by enclosing that field with quotes. This means that you might have rows that look like: aaaaa,bbbbb,"cccc,ccccc",ddddd,eeeee "aaaa,aaaa",bbbb,cccc,dddd,"eeee,eeee" So what I want to do is replace any comma that is enclosed within quotes with a space. I could survive with just deleting the comma if that makes it easier. I think this requires some look-ahead or look-behind, which is over my head. I will have to have a grep solution, no perl no shell, no applescript. Thanks, Ted *********************** Ted Burger **************************** [email protected] ********* www.tobsupport.com -- This is the BBEdit Talk public discussion group. If you have a feature request or would like to report a problem, please email "[email protected]" rather than posting to the group. Follow @bbedit on Twitter: <http://www.twitter.com/bbedit> --- You received this message because you are subscribed to the Google Groups "BBEdit Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected].
