Page 1 of 1

CSV remove embedded field commas in a comma delmited file

Posted: Fri Nov 09, 2007 2:56 am
by jbesch
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

Posted: Fri Nov 09, 2007 8:54 pm
by DataMystic Support
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.