Pattern matching in Transformations

Former Member · ‎05-19-2008

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

former_member206107 · ‎05-19-2008

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

Former Member · ‎05-19-2008

Hi Kiran,

This can be done with the help of normalization in MDM.

Hope this helps,

+ An

Edited by: An. on May 19, 2008 3:40 PM

Please dont forget to close your questions when answered

Re: SAC BW live connection: Error Illegal State: d...