I have a series of files with lines like:

Proprietor
Bill Smith and Mary Smith

Identifier  23B/874

M5412345.6 Mortgage to XYZ Bank Limited

each file will have an Identifier and a Proporietor, but not necessarily
a mortgage

I want to process each file and end up with a file like this:

Bill and Mary Smith,23B/874,M5412345.6, XYZ Bank Ltd
John & Joan Brown,23H/123,M123435.6,GHJ Lenders Ltd

The trouble I am having is extracting the proprietor name, as it is on a
different line to the word "Proprietor"

Also the Identifier line appears twice in each file and I only want the
first one.

Can any one help me?
-- 
Nick Rout <[EMAIL PROTECTED]>

Reply via email to