Skip to Content
avatar image
Former Member

How to ignore particular lines in File Adapater

Hi ,

We are aware we can ignore the comments in the begning of the file by putting the document offset in the sender adapater

but is there a way we can ignore comments if the occure in the middle of the line

like if my i/p file is like

#

  1. transactionId=3c68ffae-10d61001cd5

  2. uniqueId=3c68ffae-10d61001cd5

  3. Wed Aug 30 21:33:20 UTC 2006

#

  1. recordindex=0

broker_domain broker_org Accepted With Changes 29Aug2006110525 4500000020 $null 29Aug2006110525 Discrete_Order 0000352119 vendor1 SSP_CUSTOMER SSP_CUSTOMER $null $null $null $null $null $null $null $null $null $null $null $null $null 0001 $null $null $null $null $null 29Aug2006000000 $null $null $null $null $null 10 S107999436 Test Material created on 29 August 2006 SSP_CUSTOMER_domain S107999436 Test Material created on 29 August 2006 0000352119_domain 100000.0 $null EUR EA Accepted With Changes 29Aug2006110525 29Aug2006110525 S107999436 $null $null $null $null $null 1 Sup_Change_UI Accepted With Changes 29Aug2006110522 500.0 29Aug2006000000 29Aug2006000000 500.0 29Aug2006000000 $null $null $null 5302 $null $null $null $null $null $null $null $null 29Aug2006110522 $null $null $null $null $null $null $null $null $null $null $null $null $null 1 $null $null $null $null $null $null $null $null 600.0 29Aug2006000000 $null $null $null $null $null $null

  1. recordindex=1

broker_domain broker_org Accepted With Changes 29Aug2006110525 4500000020 $null 29Aug2006110525 Discrete_Order 0000352119 vendor1 SSP_CUSTOMER SSP_CUSTOMER $null $null $null $null $null $null $null $null $null $null $null $null $null 0001 $null $null $null $null $null 29Aug2006000000 $null $null $null $null $null 10 S107999436 Test Material created on 29 August 2006 SSP_CUSTOMER_domain S107999436 Test Material created on 29 August 2006 0000352119_domain 100000.0 $null EUR EA Accepted With Changes 29Aug2006110525 29Aug2006110525 S107999436 $null $null $null $null $null 2 Sup_Change_UI Accepted With Changes 29Aug2006110522 500.0 30Aug2006000000 30Aug2006000000 500.0 30Aug2006000000 $null $null $null 5302 $null $null $null $null $null $null $null $null 29Aug2006110522 $null $null $null $null $null $null $null $null $null $null $null $null $null 1 $null $null $null $null $null $null $null $null 400.0 30Aug2006000000 $null $null $null $null $null $null

I dont want to read lines with #

Is there a way we can achieve this

Thanks

Amit

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 04, 2006 at 07:23 AM

    Hi,

    the only way to achive this is to use an adapter module

    of java proxy

    inside the adapter module or java proxy you can

    delete those lines easily by deleting from java

    all lines that start with # and end with a new line

    Regards,

    michal

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2006 at 11:01 AM

    Hi,

    Could you also try using the conversion agent to handle this type of problem ?

    Only a thought.

    http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm

    Kind regards

    Colin.

    Add comment
    10|10000 characters needed characters exceeded