ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

FormatEncryptString function is not supporting email address


Article ID: 228315


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


Using FormatEncryptString function for email address in CA TDM portal data generation. we are getting below error

contains a mismatched bracket in expression: @formatencryptstring([email protected])@


FormatEncryptString being a code type of function cannot work with extra "@" symbols and is expectedly throwing the error.


Release : 4.9.x

Component : TDM Portal


Below is a complex workaround using some inbuilt functions to identify position of @ symbol, extract the left side and right side of @ symbol, then mask these with two calls to formatencryptstring function.


If above workaround doesn't work then you have to look at other functions(may be in combination) to meet your masking requirements.