mercredi 16 janvier 2019

Extract string between a pattern in txt files

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