Remove the last two charecters from right

[Former Member]

HI,

I need to remove the last two charecters from right for the receiver side where i am getting the value from source.

Here the length of charecters : 6

Please suggest me here ....as i need to write UDF? and help me out to resolve this..

Thanks in Advance..

Regards,

Y. Raj.

[SudhirT · Accepted solution]

if the length is fixed 6 then use standard substring function with (0,4).

Thanks!

[Former Member · Accepted solution]

Sudhir,

It's really perfectly fine. Thanks alot..

Thanks to all help here for this blog

Regards,

Y.Raj.

[Former Member]

Hi,

if your field has always! a length of 6 you could use the standard substring function with parameters (4, 2).

But maybe you should check the length with the standard function length and a if function before using the substring function to avoid an error in the mapping.

Regards

Patrick

[Shabarish_Nair]

use the substring standard function available in message mapping.