subString function in Message mapping

[Former Member]

Hi Guys,

               I am using subString function in message mapping to take last 8 characters of 10 character field. But it returns all 10 digits.

Here is the screen shot

[Former Member · Accepted solution]

hi ... i dont know why you was mapped  to target rootnode (Messagetype:MT_D)

you have to create :

BELNR -> substrring -> BELNR insted of calling NS0:MT_D

and substring functionality is coorect for ur requirement and it's read only last 8 chars

[Former Member · Accepted solution]

I am going to call an UDF after the substring for dynamic file creation.

[prateek · Accepted solution]

In the subString function, have you added 2,8 as input which would mean starting from 2nd position for next 8 characters? Can you also show the queue entry you see?

Regards,
Prateek Raj Srivastava

[Former Member · Accepted solution]

I think its not working because I assign it to the header node. Which will not hold any data. I am testing this before add UDF function in between though.

Thanx for your replies.

[markangelo_dihiansan · Accepted solution]

Hello,

substring(2, 0) will also work.

Regards,

Mark

[Former Member]

Hi Sam

you have used substring(2,10) which will give u 10 char as output

because substring(starting point of string index,number of characters)

you can use substring(2,8) which will give you 8 char as output.

Regards

Raj

[Former Member]

Hi Sam

Use substring (2, 😎

Regards

Monika