Trying to work with csv files

Get help with installation and running here.

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

Post Reply
Posts: 1
Joined: Sat Jun 05, 2010 2:02 am

Trying to work with csv files

Post by mlquibell »

ok I have large DB I am trying to extract just the records that contain a tel #. I have tried several methods I read here to no avail. Data files are csv like this
"","PAULA","SPIGELMOYER","3049 SE 38TH AVE","OKEECHOBEE","FL",34974,8636978569,"123FREETRAVEL.COM","",04/27/10 03:43 AM,,"28/02/1977"
"","BRENDA","BUTLER","407 SPURGEON ST","WAYCROSS","GA",31501,"912-285-3626","123FREETRAVEL.COM","",04/27/10 12:50 PM,"m",19800326

now how to load large csv and have textpipe save only records that have tel # into a new file. Much appreciate your help
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Re: Trying to work with csv files

Post by DataMystic Support »

1. drag and drop your file into TextPipe.
2. Add a Filters\Remove\Remove lines\Remove non-matching lines, using an EasyPattern match, with text of

Code: Select all

[ 3 digits ]-[ 3 digits ]-[ 4 digits ]
3. Change the output filter to point to the new destination filename
4. Click [Go].!
Post Reply