Nick Rout wrote: > 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?
Hi Nick, I can whip up a python script for you if no one offers any easier suggestion. Cheers, Carl.
