CSV remove embedded field commas in a comma delmited file

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
jbesch
Posts: 1
Joined: Fri Nov 09, 2007 2:24 am

CSV remove embedded field commas in a comma delmited file

Post 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
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post 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.
Post Reply