We are in the process of masking flat files from various different sources. One of the challenge we have now is to avoid the blank spaces in the flat file and to consider them as NULLS. Used couple of option from the options(BlanksAsNULLS & EMPTYASNULL) tab but those did not helped.
eg: email is blank in the original file. But in the masking routine we used CONCAT option to concatenate last name and the company domain and enabled the keep nulls & Use masked values options. The resultant masking output is considering the blank spaces as characters and producing a value.
Kindle let me know if there is any other option to handle this.