How to mask file with delimiter ^A

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • Answered
Have a delimiter file with ^A and same is defined in delimiter field of Ruleset. Still i don't see masking is working as expected. What am i missing?
Photo of santosh kumar

santosh kumar

  • 450 Points 250 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of David Wells

David Wells

  • 120 Points 100 badge 2x thumb
Hi Santosh, I believe we have an open issue with using control characters as delimiters right now. For the time being, what customers have been doing is replacing them with a unique sequence of characters that do not exist elsewhere in the file, using that sequence as the delimiter, masking the file, and then replacing the character sequence with the original control characters after masking.
Photo of santosh kumar

santosh kumar

  • 450 Points 250 badge 2x thumb
Thanks Dave for response. So, outside delphix, i can invoke some script to replace ^A with |A and then mention same thing in delimiter section. After masking, call the script again to replace all | with ^A. 

Is that you are suggesting?
Photo of David Wells

David Wells

  • 120 Points 100 badge 2x thumb
Yep - you just have to be careful not to pick a sequence that already is being used in the file. When I have had to do this in the past I have used a simple sed "pre" script, then execute the masking job via the API, then execute a simple sed "post" script. Note that your delimiter can be more than one character - you could use |@|
 for example...