Skip to Content
avatar image
Former Member

Message Mapping - Trim the incoming characters in Field

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

1a97x.png (16.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jul 05, 2017 at 07:16 PM

    Pooja,

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

    Br,

    Manoj

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 06, 2017 at 12:00 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 06, 2017 at 12:00 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 06, 2017 at 07:38 AM

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

    Add comment
    10|10000 characters needed characters exceeded