AnsweredAssumed Answered

Fixed Value masking with Substring Option

Question asked by Shrini_TSYS on Jun 21, 2018
Latest reply on Jun 25, 2018 by Sean-K-CA

I am trying to Mask a 16 Digit Credit Card number with the 1st 6 and Last 4 digits as same and the middle 6 digits to be replaced with a Fixed Value say '999999'.

 

I need to do this on SQL Server Database for a VARCHAR Field storing numeric values using Transformation Map (Not FDM).

 

I see that with FIXED value replacement, the Substring option does not work. Is there any Function available to implement above requirement?

Outcomes