AnsweredAssumed Answered

Comma delimited File Masking

Question asked by Azarwin on Sep 14, 2018
Latest reply on Sep 17, 2018 by Sean-K-CA

Hi All,

 

I have a comma delimited file to be masked and the strings in the fields are enclosed with double quotes ("). The client wants this to remain, but after masking the file the " are getting dropped from the file.

Ex:

Input file:

"I","VALUE","ABC,DEF","GET"

 

Output file:

I,MASKED,"ABC,DEF",GET

 

Expected:

"I","MASKED","ABC,DEF","GET"

 

Any help much appreciated.

 

Thanks

Azar

Outcomes