Hi,
How exclude and ignore comma (,) and double quote (") when we mask data with GTXMSK on mainframe.
Example:
Table,Column,Function,Parm1,Parm2,Parm3,Parm4,Keep Nulls,Date Format,Cross Reference,Override SQL,Unique Columns,XPath Element,Substr start,Substr length,Notes,Preformat,Update,Use Masked Values,Restart Column,From Occurance,To Occurance,Parm5,Parm6,Parm7,Parm8,Parm9,Parm10
TEST_CLASSIFIER,EMAIL,FORMATENCRYPT1,,,,,Y,,,,,,,,Encrypt Email,,,,,,,1234AbCde45678FgHiJk,!#$%&'()*+-./:;<=>?@[]_{|}~¡¢£¤¥¦§¨©ª«¬®¯°±²³µ¶·¸¹º»¼½¾¿Ð×ØÞßð÷ø^´`\þ,ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÑÒÓÔÕÖÙÚÛÜÝÿàáâãäåæçèéêëìíîïñòóôõöùúûüý!#$%&'()*+-./:;<=>?@[]_{|}~¡¢£¤¥¦§¨©ª«¬®¯°±²³µ¶·¸¹º»¼½¾¿Ð×ØÞßð÷ø^´`\þ,,,
I can't put comma (,) into the parm5 and parm6 because that will indicate the end of the parm!
When I had double quote (") into the parm5 and parm6,the result of the masking was too different.
Is there a escape character on the mainframe?
Thanks !
Michel