(Thanks ME, who ever you are)
Hi, I have been asked to write a perl script, to format the output
in to fields/columns;
Description for script:
*Read a existing file and put it in my requested format,
*Take certain data types from the file (input),
(problem)
*Put the certain data types in to fields/columns (output).
(problem)
The big problem being that the data in the File is not sorted in any
form, e.g. no Headings etc. The only thing separating the data types are
spaces!
What I need to get from the file are:
ID.NUMBER, BranchNAME, ADDRESS.
The file contains the above 3 data types that I need, also about
another 10+ which I need to get rid off!!!!! Can any body please suggest how
do this task please, e.g. Report writing etc
Here is two data examples from the input file (each data is normally
streachted along ONE LINE) :
(I need the three data types that are 'underlined' (ID.NUMBER,
BranchNAME, ADDRESS).
086117 00 BNY INTERNATIONAL LTD CO-OPERATIVE
BANK THE CO-OPERATIVE BANK PLC 0021 A
15/10/1999 M 18/05/1999 301599
0021 01 00 0021 02 Y N N
14/11/1999 29-MAY-2001 N
25/05/2001 05:18 5250 M 03/10/1996
21 GB M
GMAC -Comercial CR Ltd 1 Brighton, E.Sussex
Sovereign Hse Church St
Brighton E.Sussex BN1
1SS 01273 321211
101599 00 PAYMASTER GENERAL BANK OF
ENGLAND BANK OF ENGLAND 0001 D
17/08/1999 M 01/09/1998
0001 01 01 0001 01 Y N DR CR CU
PR BS DV AU N 15/10/2000
29-MAY-2001 N 25/05/2001 05:18 8117
N 20/09/2000 M
GOVERNMENT AGENCIES Paymaster General
1 Paymaster General
Cheque & Credit Clearing (FDR) Christopher Martin Rd
Basildon Essex SS14 9AA
01268 298624
> Any help would be much appreciated as I only have two days to this in!!!
>
Thanks,
GD
