I am working on a txt file as below.
-
BEGINNING OF REPORT * * * ***********************************************************************
Clearing Member Account Holder
XXXXX - XXX BB - ABC AB
Cash Account LocId Curr Reference Run CHI
000000 SNB CHF REGEX NTP ECAG
TranDate Value Date Pool ID CshInstId Typ Type Description Debit Credit
29-11-18 30-11-18 XXXXXXXXXXXXXX 000 TEST CALL 2,240,597.24 0.00 29-11-18 30-11-18 XXXXXXXXXXXXXX 000 TEST CALL 241,921.00 0.00 29-11-18 30-11-18 XXXXXXXXXXXXXX 000 TEST CALL 0.00 451,500.00 29-11-18 30-11-18 XXXXXXXXXXXXXX 000 VAR TEST CALL 21,579,766.09 0.00 29-11-18 30-11-18 XXXXXXXXXXXXXX 000 TEST CALL 0.00 1,400,697.89 29-11-18 30-11-18 XXXXXXXXXXXXXX 000 TEST CALL 231,768.45 0.00 29-11-18 30-11-18 XXXXXXXXXXXXXX 000 TEST CALL 0.00 287,500.00 29-11-18 30-11-18 9999999 000 CASH CALL 0.00 22,154,354.89
Cash Account LocId Curr Reference Run CHI
003153 SNB CHF REGEXEXPRE NTP ECAG
TranDate Value Date Pool ID CshInstId Typ Type Description Debit Credit
29-11-18 30-11-18 YYYYYYYYYYYYYY 111 CASH CALL 320,915.50 0.00 29-11-18 30-11-18 YYYYYYYYYYYYYY 111 CASH CALL 2,744,730.00 0.00 29-11-18 30-11-18 999999 111 CASH CALL 0.00 3,065,645.50
I want the output to be look like below.
Account Number Ccy receive pay XXXXXXXXXXXXXX CHF - 22,154,354.89 YYYYYYYYYYYYYY EUR - 3,065,645.50
i'm trying to read it as delim however it is reading as lines
Aucun commentaire:
Enregistrer un commentaire