On Feb 17, 2014, at 18:44, Ted Burger <t...@tobsupport.com> 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 "supp...@barebones.com" 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 bbedit+unsubscr...@googlegroups.com. To post to this group, send email to bbedit@googlegroups.com.
