Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 07, 2010 at 03:33 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks everyone for their valuable suggestions.

      As Michal suggested, I will try to clean up the payload in the mapping ... full points to him, rest of the folks equally awarded.

      I am closing the thread, but might open it again if I get stuck up somewhere 😊

      Thanks and I appreciate your kind efforts.

      --Abhi