I need to get it into a spreadsheet form first, which is why the output is .csv. Finding the line proprietor is easy, then putting the _following_ line into the oputput stream is the problem.
On Fri, 27 Sep 2002 08:20:32 +1200 Yuri de Groot <[EMAIL PROTECTED]> wrote: > I wonder if this can be done with a spreadsheet macro > (OpenOffice, StarOffice, Excel) with the result > saved in csv format. > > >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]> > > > > > -- Nick Rout Barrister & Solicitor Christchurch, NZ Ph +64 3 3798966 Fax + 64 3 3798853 http://www.rout.co.nz
