How to ignore particular lines in File Adapater

[Former Member]

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

[Former Member]

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.

[MichalKrawczyk]

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