CSV remove embedded field commas in a comma delmited file

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

CSV remove embedded field commas in a comma delmited file

Post by jbesch » Fri Nov 09, 2007 2:56 am

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: 2237
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Post by DataMystic Support » Fri Nov 09, 2007 8:54 pm

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.

Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads

Post Reply