Remove lines not matching

[Matt]

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

[DataMystic Support]

So you should be using pattern

^\d\d\d

The latest version is 7.0.6 - consider upgrading.

[Matt]

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]

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

Thanks,

Matt