Extraction between lines

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
p1paul
Posts: 1
Joined: Sat Jan 19, 2008 7:32 am

Extraction between lines

Post by p1paul »

I'm new to this RegEx stuff so whilst I'm learning can someone assist with this I'll assume basic query...

I'm wanting to extract data between two lines, the data is as follows

CompanyInfo.aspx@key
Image Printers & Suppliers 41 Park Av , Knaresborough, HG5 9ES Tel: 01423 869533 Business type

I want to extract everything between 'CompanyInfo.aspx@key' and 'Business type' and create a new file with the extracted data in it...

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

Post by DataMystic Support »

Use a perl search/replace with the Extract option on.

Search for:
CompanyInfo.aspx@key(.*)Business type

Replace with
$1\r\n

Use the output filter to send the results to a new file
Regards,

Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads
Post Reply