View previous topic :: View next topic
Author
Message
rajesh_mbt New User Joined: 27 Mar 2006Posts: 97 Location: India
Hi
Follwoing ing the input file format :
Code:
000CDT01P00006443TCDS"CreditDefaultSwapShort
000CDT01P000CDT02TCDS"CreditDefaultSwapShort
000CDT01P000CDT02TCDS"CreditDefaultSwapShort
000CDT01P00006442TCDS"CreditDefaultSwapShort
000CDT01P00006443TCDS"CreditDefaultSwapShort
000CDT01P00006443TCDS"CreditDefaultSwapShort
000CDT01P00006443TCDS"CreditDefaultSwapShort
000CDT01P00006442TCDS"CreditDefaultSwapShort
000CDT01P00006442TCDS"CreditDefaultSwapShort
000CDT01P000CDT02TCDT"CreditDefaultSwapIndexTranche
000CDT01P000CDT02TCDT"CreditDefaultSwapIndexTranche
i want the output as below
IF 19:3 = CDS THEN add 'PMS' at the end of the record
Code:
000CDT01P00006443TCDS"CreditDefaultSwapShort 'PMS'
000CDT01P000CDT02TCDS"CreditDefaultSwapShort 'PMS'
000CDT01P000CDT02TCDS"CreditDefaultSwapShort 'PMS'
000CDT01P00006442TCDS"CreditDefaultSwapShort 'PMS'
000CDT01P00006443TCDS"CreditDefaultSwapShort 'PMS'
000CDT01P00006443TCDS"CreditDefaultSwapShort 'PMS'
000CDT01P00006443TCDS"CreditDefaultSwapShort 'PMS'
000CDT01P00006442TCDS"CreditDefaultSwapShort 'PMS'
000CDT01P00006442TCDS"CreditDefaultSwapShort 'PMS'
000CDT01P000CDT02TCDT"CreditDefaultSwapIndexTranche
000CDT01P000CDT02TCDT"CreditDefaultSwapIndexTranche
please corrcet my syntax.
Code:
SORT FIELDS=COPY
OUTREC IFTHEN=(WHEN=(19,3,CH,EQ,'CDT'),
BUILD=(42,3,C'PMS')),...
Back to top
Frank Yaeger DFSORT Developer Joined: 15 Feb 2005Posts: 7129 Location: San Jose, CA
You didn't say what you mean by 'end of the record', so I assumed you meant you want 'PMS' in positions 59-63 in which case you can use this DFSORT OUTREC statement:
Code:
OUTREC IFTHEN=(WHEN=(19,3,CH,EQ,C'CDS'),
OVERLAY=(59:C'''PMS'''))
If you want another starting position for 'PMS', change 59: to what you want.
Back to top
Please enable JavaScript!