Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Discard lines from File

Dear All,

I have an inbound file to PI.

In the file, there are few lines which are not to be used ... those appear in the top, bottom as well as somewhere in the middle of the file.

I know how to take care of undesired lines from the top, but how to take care of those coming in the middle and the bottom? The number of rows for these undesired extra lines in top, middle and bottom of the file will always be fixed.

Example:-

TOP_LINE1 (Extra line)

TOP_LINE2 (Extra line)

DATA_LINE1

.

.

.

MID_LINE1 (Extra line - HELP required)

MID_LINE2 (Extra line - HELP required)

DATA_LINE1

.

.

.

BOTTOM_LINE1 (Extra line - HELP required)

BOTTOM_LINE2 (Extra line - HELP required)

BOTTOM_LINE3 (Extra line - HELP required)

As I mentioned earlier, the number of rows for these extra lines will always be fixed.

Any suggestions / help will be highly appreciated.

Thanks,

--Abhi

replied

Hi,

>>>The number of rows for these undesired extra lines in top, middle and bottom of the file will always be fixed.

why not create a date type that will inport those additional lines as normal lines

and just remove them in the mapping ?

Regards,

Michal Krawczyk

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question