Trying to work with csv files

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

Trying to work with csv files

Postby mlquibell » Sat Jun 05, 2010 2:05 am

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

Re: Trying to work with csv files

Postby DataMystic Support » Mon Jun 07, 2010 9:26 am

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].!

Simon Carter, - Insulin dose calculator for Type 1 diabetes - 250,000 free software downloads - send huge email attachments

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

Who is online

Users browsing this forum: Google [Bot] and 1 guest