Skip to Content
avatar image
Former Member

Pattern matching in Transformations

HI,

Does MDM data manager supports pattern matching in Transformations.

We have the scenario where we need to trim the leading zeros.

Could you please help in this regard!

Thank you,

Kiran.G

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    May 19, 2008 at 10:50 AM
    Add comment
    10|10000 characters needed characters exceeded

  • May 19, 2008 at 11:29 AM

    Hi,

    I assume your requirement is some thing as below. Correct me if i am wrong.

    There is a text field which has values like 01,02,03....etc.

    Now you want to convert these values to 1,2,3....

    The Assignment with Absolute operation will do this. Create an assignment in data manager with the following expression

    ABS(<Field>).

    Run this assignment. It will trim all the leading zeros

    Best regards,

    Arun prabhu S

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      what if the values are something as below:

      001A, 002B, 003C

      I'm also looking for a solution for this problem.

      Transformations based on patterns will be much helpful....

      Regards

      Madan