CSV remove embedded field commas in a comma delmited file

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

CSV remove embedded field commas in a comma delmited file

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

Postby 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.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Google [Bot], Yahoo [Bot] and 6 guests