Restrict Filter - Matching Lines (grep) - Extract data?

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

MelSeven
Posts: 1
Joined: Wed Feb 10, 2016 8:44 am

Restrict Filter - Matching Lines (grep) - Extract data?

Postby MelSeven » Wed Feb 10, 2016 8:53 am

Hi,

I use a lot of Restrict to Matching Lines (grep) filters like this one (in a text file with fixed position fields):

^.{74}(WANT01-001-003MA1.*|HPEN3-020-01.*|HPEN3-018-01.*|BBTH05-001-001MA1.*|MOLE6-013-02.*).{1893}$

Is it possible with these filters to extract / link to a CSV file, text file or similar instead of having a list a items in the filter? Sometimes I want this data to change and currently I have to update this in the Matching Lines filter, which is a bit tedious and time-consuming.

Thanks,

John

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

Re: Restrict Filter - Matching Lines (grep) - Extract data?

Postby DataMystic Support » Mon Feb 15, 2016 8:45 am

Hi John,

Not with that filter, but you can with Filters\Restrict\Restrict to lines matching pattern list
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: No registered users and 2 guests