Hi Experts,
I need to pick a report file which is in the below given format. I am using PI 7.1 Sender File (FCC) to do this. First six lines are of no use to me, so I am putting Document offset as 6 in Sender File Adapter. But the last line says "END OF REPORT". I have couple of questions.
1. Is there any way to handle the last line END OF REPORT. I am thinking of using a before processing OS command to remove it. Is there any better way to do it?
2. This file contains around 3000 lines. I should not process the lines where second coloumn is not numberic (eg. for Test Bank3 - A789). How to do this in PI 7.1. I am using Graphical Mapping.
3. If there are any special characters (eg. for Test Bank4), Ignore that line and process others. Can I have a log of ignored lines?
Sample File -
"RPT TRIALB XYZ LIMITED"
" TRIAL BALANCE"
" FOR THE PERIOD ENDED DECEMBER 2009"
""
""
""
"","Test Bank1","123",100
"","Test Bank2","456",200
"","Test Bank3","A789",300
"","||Test Bank4",111,400
--
--
--
--
END OF THE REPORT