I'm assuming the Comments can have a varying amount and they might not be numbers as well? If this were a problem I had to tackle I think it would be easier to import the data into Excel (or your spreadsheet software of choice) and do a Find & Replace on just the one column....I'm coming up empty for a grep solution if the data varies like I think it would.
On Friday, October 11, 2019 at 10:08:26 PM UTC-4, Russ Pixels wrote: > > I use Text Factory with GREP to process downloaded bank statements, batch > converting them from CSV to tab .txt using a simple comma find and replace, > but if there are commas in the comments field that screws things up. Can > someone supply a regex example that converts only the commas found between > the quotes to some other character or a space? In the factory it will run > first, then I can convert the commas to tabs. Thanks > > Example of issue: > > 28 MAR 2018,27 MAR 2018,"Comments for credited amount Ref: TH > 1,2,3,4",,1025.00,2453.85 > -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "[email protected]" rather than posting to the group. Follow @bbedit on Twitter: <https://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 view this discussion on the web visit https://groups.google.com/d/msgid/bbedit/cd8da06d-934d-440e-ab02-6e1e53ed3a48%40googlegroups.com.
