remove lines according to the column value

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Post Reply
Posts: 1
Joined: Tue Jun 29, 2010 1:45 am

remove lines according to the column value

Post by backmyroom » Tue Jun 29, 2010 2:07 am

I am using TextPipe pro 6.5 version

How to remove lines according to Column 11 ~ 20’s value not in a list from file

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

Re: remove lines according to the column value

Post by DataMystic Support » Tue Jun 29, 2010 8:56 am

Use a restrict to columns 11-20, inside this use a restrict to matching lines filter (using the list file), then mark each line with a special value such as by using an Add Left Margin with text of '###'.

Then, outside the filter, you can remove or keep all lines containing '###' before finally removing the '###' themselves with a search replace.

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

Post Reply

Who is online

Users browsing this forum: Majestic-12 [Bot] and 2 guests