FORMATENCRYPT1 - How to IGNORE and EXCLUDE comma (,) and double quote (") on mainframe

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Hi,

How exclude and ignore comma (,) and double quote (") when we mask data with GTXMSK on mainframe.

For 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,!#$%&'()*+-./:;<=>[email protected][]_{|}~¡¢£¤¥¦§¨©ª«¬®¯°±²³µ¶·¸¹º»¼½¾¿Ð×ØÞßð÷ø^´`\þ,ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÑÒÓÔÕÖÙÚÛÜÝÿàáâãäåæçèéêëìíîïñòóôõöùúûüý!#$%&'()*+-./:;<=>[email protected][]_{|}~¡¢£¤¥¦§¨©ª«¬®¯°±²³µ¶·¸¹º»¼½¾¿Ð×ØÞßð÷ø^´`\þ,,,

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?

 

 

Environment

Release : 4.9

Component : TDM ACTION SERVICE

Resolution

The only way to ignore and exclude comma(,) and double quote (“) on the mainframe  is to use :

FORMATENCRYPT1IGNORESPECIALCHARS=Y
FORMATENCRYPT1EXCLUDESPECIALCHARS=Y