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]> > >
