Using TDM facing issue while generating content with special characters like Tilda

Products

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

Issue/Introduction

We are facing an issue while data generation since it has a tilde '~' symbol present in its content.
Can you please try this and let us know the resolution.

example:
one of the fields is
          <Remit~190110~Bene Name Enh~>

So it is failing, giving the following error:
 An error occurred resolving TABLE: instrument_record COLUMN: payment_ref_1. The expression was <Remit~190110~Bene Name Enh~>.
The error is <resolve_meta_data_item: TDMServiceException: unknown variable: 190110> 

 

Environment

Test Data Manager
TDM Portal
datamaker

Cause

As "Tilda" is used in datamaker for variable representation, it is throwing an error.
An error occurred resolving TABLE: instrument_record COLUMN: payment_ref_1.
The expression was <Remit~190110~Bene Name Enh~>.
The error is <resolve_meta_data_item: TDMServiceException: unknown variable: 190110> 

Resolution

In order to use Tilda (~) character, replace ~ with @char(126)@ so that, data rule will covert 126 into ~ and generate the data.

Example:
[email protected](126)@[email protected](126)@Bene Name [email protected](126)@

will resolve as
Remit~190110~Bene Name Enh~ during publishing.