Page 1 of 1

Extraction between lines

Posted: Sat Jan 19, 2008 7:44 am
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

Posted: Tue Feb 05, 2008 7:59 pm
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