Message Mapping - Trim the incoming characters in Field

[Former Member]

Hi Experts ,

I am trying to use the Substring function for cutting the field characters length. But when the characters are less compared in substring its throwing an error.

Do I have to use UDF for this solution. or can I achieve this just using graphical mapping

Thanks in Advance.

Regards,
Pooja

[manoj_khavatkopp · Accepted solution]

Pooja,

You can have a look at this blog : Dynamic Substring.

Br,

Manoj

[Harish]

Hi Pooja,

One more option is to check the length from text function and if the length is greater than 10 then only apply the substring (using substring). else pass the value as it is to target.

regards,

Harish

[former_member186851]

What value should be passed if the length is less than 10?

[Harish]

Hi Pooja,

One more option is to check the length from text function and if the length is greater than 10 then only apply the substring (using substring). else pass the value as it is to target.

regards,

Harish