It was for an example I referred above.
say if the column name in the .csv file is TaxID and it has value as shown below

Code:

TaxID
1259755
5485656
4874455

Then aftermasking it is expected that the inside .csv file under the column TXID

Code:

xxx-xx-xx
xxx-xx-xx
xxx-xx-xx

Please note it is not that a six digit field to a nine character field containing seven <x>s and two hyphens.. In future the Tax id values can be more than 10 digits. so here the intent is if the column name is Tax_ID then mask. There can be more than one tax related column in the .csv file. Example : TaxID_1 , TaxID_2, Tax_ID3 and so on. All we are looking here is the column names that will be hard coded in the script.

How to handle if a column name is like TAX-ID or DATE-OF-BIRTH?

The script reads the input from a table as I said earlier which will have the file name ,the column names and the position of the columns where masking needs to happen.

Example : yes you are right 9999-12-31 should be the one. It was type error my end earlier. It is not the heading am asking to replace but for the values in that column. As I said the table will indicate the position number of the column that needs to be masked.


The .csv file can contain more than 1 column that are related to DOB, Date of Birth or DATE-OF-BIRTH.



Either at one go the file must be either comma delimited or pipe. but not both.

As I shared the script code earlier the flow goes as shown below
First the script will read the table that contains the column position for dob and tax related column . say the position is 5 and 10 for a column name DateOfBirth and Tax_Id respectively then as these two column names are hard coded in side the script it in an array. It will search for these two column names and if found then mask . Finally we will see in the out put masked file 5 and 10 positions will have 9999-12-31 and xxx-xx-xx

thanks
Mahesh G