enclosureSign parameters problem?

[Former Member]

Has anyone any idea how to configure the file adapter so that get only 1212,400 as the input to mapping.

I send : "Nummer"1212,"Version"400

I need : 1212,400

I've specified now:

Structure.fieldSeparator ,

Structure.enclosureSign "

Structure.enclosureSignEscape ""

<b>I've already tried the enclosureSign parameters but-No, it doesn't work.</b>

SXMB_MONI ;

<?xml version="1.0" encoding="utf-8" ?>

- <ns:MT_FING xmlns:ns="http://FinancialDatabase">

- <Record>

- <Row>

<Nummer><b>Nummer1212</b></Nummer>

<Version><b>Version400</b></Version>

</Row>

</Record>

</ns:MT_FING>

Thanks for any answer,

Fatih

[Shabarish_Nair · Accepted solution]

Hmmmm not sure why it is not working (cant try out at my end since the server is down )

you handle the same in your mapping (if it is urgent), write a udf to remove the text within the quotes ...

so when u pick the file avoid the enclosureSign parameters. so you message sud come as

<Nummer>"Nummer"1212</Nummer>

<Version>"Version"400</Version>

then write a srting function to remove the text.

[Former Member]

Hi,

just go through this document

http://help.sap.com/saphelp_nw2004s/helpdata/en/0d/00453c91f37151e10000000a11402f/content.htm

according to that document enclosureSign and enclosureSignEsc will remove

only the "" between the text it wont delete the text within the quotes. even i tried i didnt happen.

So as shabharish said u can use <b>substring function</b> in the input XML structure,and delete the requried text.

regards

jithesh

[Former Member]

I was confused. But thank you for the answers.