Trying to work with csv files

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

mlquibell
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
"ericspaula@yahoo.com","PAULA","SPIGELMOYER","3049 SE 38TH AVE","OKEECHOBEE","FL",34974,8636978569,"123FREETRAVEL.COM","165.223.253.162",04/27/10 03:43 AM,,"28/02/1977"
"jjtwin2@live.com","BRENDA","BUTLER","407 SPURGEON ST","WAYCROSS","GA",31501,"912-285-3626","123FREETRAVEL.COM","192.16.204.19",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: 2164
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Trying to work with csv files

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

Easy,
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].!
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: No registered users and 9 guests