Test Data Manager

Expand all | Collapse all

How to Mask variable length strings using a separator

Jump to Best Answer
  • 1.  How to Mask variable length strings using a separator

    Posted 04-17-2018 10:09 AM

    Hi,

     

    We are masking one column in oracle which has values separated by one " | " (ID | COMPANY NAME).we want to mask both parts separably using FDM .Is there any function we can use ?

     

    Regards,

    Krushna



  • 2.  Re: How to Mask variable length strings using a separator
    Best Answer

    Posted 04-17-2018 05:10 PM

    If you are on TDM 4.5, then you could use the From Occurrence and To Occurrence fields in FDM where you can specify a delimiter for a particular field.

     

    So for e.g. to mask the first field in the delimited column you would use the masking rule and set the From Occurrence to Blank and To Occurrence to 1(|) and to mask the second field you would use 1(|) and 2(|) respectively.



  • 3.  Re: How to Mask variable length strings using a separator

    Posted 04-27-2018 09:59 AM

    Hi Anil,

     

    Thank you ,its really help full . I am able to mask now .

     

    Regards,

    Krushna



  • 4.  RE: Re: How to Mask variable length strings using a separator

    Posted 04-15-2020 10:51 AM
    Hi Anil,
    I am applying same logic while masking excel file but its not working :(  , any idea ' From Occurrence and To Occurrence ' supports in Excel also ?

    Thanks,
    Krushna