Remove lines not matching

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Matt

Remove lines not matching

Postby Matt » Thu Aug 05, 2004 3:28 am

I can't seem to get the remove lines not matching to work. I want to remove all lines that don't have a 3 digit number in the first three columns. I'm using version 6.5.1

User avatar
DataMystic Support
Site Admin
Posts: 2164
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Thu Aug 05, 2004 8:50 am

So you should be using pattern

^\d\d\d

The latest version is 7.0.6 - consider upgrading.
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

Matt

Postby Matt » Tue Aug 10, 2004 12:16 am

Simon:

Thanks for your help. It work, but it created another problem. When I do my data transfer it does find the end of the line. I tried word wrap and truncate to a specific size. See sample below.

Before:

202,000,000,9866429,0531,131,080704,080804,000,xxx,0,1,WIRED - ADV RCMC REWIRE COMPLETE - CLD BE OUTSIDE FLTCN yNRE

202,244,244,3648273,0531,131,080604,080604,000,xxx,0,1,WIRED TIE PRS TO DSL SPLITTER AND VERIFIED DT AND CORCN :NV3

202,244,244,2443018,0525,149,080604,080804,000,xxx,0,0,NTCCCA/LN DSCNNCTD PER CANCELLED C9MQ73371/REPROVD LICN =NV3

202,244,244,2441894,0532,322,080804,080804,000,xxx,0,0,ST 22 VER 61 REPLACE PROTECTOR AND RESOLDER CONN ATCR N44

202,252,252,4841496,0531,131,080704,080704,000,xxx,0,0,RE-TERMINATED JUMPERS @ SPLT-BNK. - NOW VFY OK W/SUB CN bNV3

After:

202,244,244,2441894,0532,322,080804,080804,000,xxx,0,0,ST 22 VER 61 REPLACE PROTECTOR AND RESOLDER CONN ATCR N44
202,252,252,4841496,0531,131,080704,080704,000,xxx,0,0,RE-TERMINATED JUMPERS @ SPLT-BNK. - NOW VFY OK W/SUB CN bNV3
202,319,319,9860905,0531,131,080704,080804,000,xxx,0,0,RTN TO NTECH INV3
2

Matt

Postby Matt » Tue Aug 10, 2004 1:47 am

Never mind. I inserted a hard return at the end of the line.

Thanks,

Matt


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

Who is online

Users browsing this forum: No registered users and 1 guest