Hi All,
I request your expert advice on Sender File content Conversion. I need to process the below pasted file. I was able to achieve this by keeping a offset of 6 in Sender PI File Adapter (PI 7.1) to ignore first 6 lines and used a Unix script to remove last line"END OF REPORT".
Now my new requirement is I need to capture the date "DECEMBER 2009" from line 3. How can I do this. I have set offset as 6 so Adapter will start processing from line 7. If I don't set offset Interface fails. Please suggest. Thank you.
ABC LAB XYZ LIMITED"
TRIAL BALANCE"
FOR THE PERIOD ENDED DECEMBER 2009"
"TEST Bank","101000",-1589365.58,0.00,738295.08,0.00
"TEST Bank Clearing A/c","101200",0.00,0.00,14848018.55,0.00
"TEST Bank Sweeps","101250",104315957.19,0.00,7571985482.08,0.00
"TEST Receipts","101260",0.00,0.00,19788596.15,0.00
"TEST Corporate Deposits","101270",-7776629.87,0.00,-135914980.50,0.00
"SHARES","00SH",0.00,0.00,-7869890086.22,0.00
"","",,,,
"","",,,,
"END OF REPORT"