Skip to Content
0
May 07, 2010 at 04:50 AM

Need Help in Sender File Content Conversion

78 Views

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"