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 "supp...@barebones.com" 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 bbedit+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/bbedit/cd8da06d-934d-440e-ab02-6e1e53ed3a48%40googlegroups.com.
