Suppose I have a column called 'A' with 10 digits in length
I also have a column called 'B'
A B
1234567890 SAM
2345678912 HELLO
I want to mask column A and replace the first 5 digits with column B.
Post masking :
SAM 67890 (with 2 spaces)
HELLO78912
Could you please suggest what masking algorithm / approach can this be achieved?
Fast data Maker (FDM) 4.9.x
NA
FILL the first 5 characters of A with a space, followed by SQLFUNCTION left(B,5)
(select the "use masked values" checkbox)
FDM allows you to specify multiple mask routines on the same field.
Datamaker/Transformation Maps only let you specify 1;
You'll have to manually update the exported .csv file to reflect the 2nd function execution.
You'll have to provide your own Database reflecting the structure/content that John provided.
FDM mask & options files attached.
The above work for MS SQL server and mainframe as they both support the LEFT function.
Oracle database does not and you will need to use the SUBSTR