Skip to Content
0
Former Member
Apr 18, 2010 at 09:46 PM

PI 7.1 Sender File Adapter - FCC

33 Views

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