Extraction between lines

p1paul · Post by **p1paul** » Sat Jan 19, 2008 7:44 am

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

Post by **DataMystic Support** » Tue Feb 05, 2008 7:59 pm

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