Topic
  • 2 replies
  • Latest Post - ‏2013-03-14T04:25:21Z by TransformTest
TransformTest
TransformTest
3 Posts

Pinned topic Masking(Conversion) in Optim

‏2013-03-13T09:30:23Z |
Hi all,

I was trying out to perform a kind of conversion(masking) in optim. In this process, the objective is to mask a field in the following steps:
1. Alphabets in the field should be replaced with anyother alphabets.
2. Numbers to be replaced with any other number.
3. Special character to be replaced with any other Special character.

For example if the data in my field is "$$@ I know 12345". This should be masked(converted)to something like "%#& h idls 58293". Here, the alphabets are replaced by some other alphabets and same with numbers & special characters.

I want to implement this. Can anyone help me with approach(logic) which involves minimum no. of steps to acheive the result.

Thanks in Advance :)
Updated on 2013-03-14T04:25:21Z at 2013-03-14T04:25:21Z by TransformTest
  • SystemAdmin
    SystemAdmin
    304 Posts

    Re: Masking(Conversion) in Optim

    ‏2013-03-13T14:40:12Z  
    What version of Optim are you using? Looks like you're looking for something like TRANS COL:
    http://www-01.ibm.com/support/docview.wss?uid=swg21424217
  • TransformTest
    TransformTest
    3 Posts

    Re: Masking(Conversion) in Optim

    ‏2013-03-14T04:25:21Z  
    What version of Optim are you using? Looks like you're looking for something like TRANS COL:
    http://www-01.ibm.com/support/docview.wss?uid=swg21424217
    Thanks for your response John.

    Thats right. But I dont think TRANS COL could mask the special characters as stated in my main post.

    It would be helpful if any logic/fuctions to build this could be provided using simple functions.

    I am also trying this out.. will post once I get this.

    It would be great if you could help.