On Feb 17, 2014, at 18:44, Ted Burger <[email protected]> wrote: > 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. ______________________________________________________________________
Hey Ted, Give this a try: Find: "([^,]+),([^,]+)" Replace: \1 \2 -- Best Regards, Chris -- 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].
