Data Company Central

The source file is a pipe(|) delimited and data having "(double quotes) enclosed.
Source file like this:

Source file:
"ID" | "Name" | "DOB" 
"111111111" | "AAAAAAA" | "1999-08-22"

After masking Name by using SL algorithm like below:

"ID" | "Name" | "DOB" 
"999999999" | BBBBBBBBB | "1999-08-01"

For the Name column it is removing Quotes but after masking also want to be "BBBBBBBBB" instead BBBBBBBBB.
Could you please suggest what exactly i need to do? 



------------------------------
THIMMA REDDY BOGATHI
DATA ENGINEER
Capgemini America
------------------------------

This was cross-posted. Closing this thread. Please see updates here.

------------------------------
Michael Torok
Director of Knowledge and Community Management
Delphix
------------------------------

Original Message:
Sent: 04-21-2021 02:05:11 PM
From: THIMMA REDDY BOGATHI
Subject: Having issue in Pipe(|) delimited with "(Quotes) enclosed data masking

The source file is a pipe(|) delimited and data having "(double quotes) enclosed.
Source file like this:

Source file:
"ID" | "Name" | "DOB"
"111111111" | "AAAAAAA" | "1999-08-22"

After masking Name by using SL algorithm like below:

"ID" | "Name" | "DOB"
"999999999" | BBBBBBBBB | "1999-08-01"

For the Name column it is removing Quotes but after masking also want to be "BBBBBBBBB" instead BBBBBBBBB.
Could you please suggest what exactly i need to do?



------------------------------
THIMMA REDDY BOGATHI
DATA ENGINEER
Capgemini America
------------------------------