Data Company Central

 View Only
Expand all | Collapse all

Having issue in Pipe(|) delimited with "(Quotes) enclosed data masking

  Thread closed by the administrator, not accepting new replies.
  • 1.  Having issue in Pipe(|) delimited with "(Quotes) enclosed data masking

    Posted 04-21-2021 02:05:00 PM
    No replies, thread closed.
    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
    ------------------------------


  • 2.  RE: Having issue in Pipe(|) delimited with "(Quotes) enclosed data masking

    Posted 04-21-2021 02:43:00 PM
    No replies, thread closed.
    This was cross-posted. Closing this thread. Please see updates here.

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