remove lines according to the column value

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

backmyroom
Posts: 1
Joined: Tue Jun 29, 2010 1:45 am

remove lines according to the column value

Postby 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: 2154
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: remove lines according to the column value

Postby 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.
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: Baidu [Spider] and 2 guests