Page 1 of 1

Trying to work with csv files

Posted: Sat Jun 05, 2010 2:05 am
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
"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

Re: Trying to work with csv files

Posted: Mon Jun 07, 2010 9:26 am
by DataMystic Support
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].!