DataMystic

Any ideas on how I can extract embedded commas out of a comma delimited file. Here is an example:

1027,'MAA','SOME ORG, INC.','1110 MAIN ST','EAST PETERSBURG','PA','175201694',717,569,6467,'85-2428','N'

I want to remove the comma in the 'SOME ORG, INC' column (maintaining the other commas as they delimitethe fields

Easy - use a Filters\Restrict\Delimited fields (CSV, Tab, Pipe, etc), and check the options to subfilter each field individually and the two options below it. Then place a search/replace to remove the comma INSIDE this restriction.