Masked Values
Previous  Top 

"Masked Values" is a type of value that generates random data according to an user-defined mask. It's a powerful way of generating custom string data.

When creating a mask, the following are legal characters:

A
Random upper case alphabetical character
a
Random lower case alphabetical character
C or c
Random mixed case alphabetical character
N or n
Random numerical digit
R or r
Random character, including digits, punctuation etc...
H or h
Random hexadecimal digit (0..9, A-F)
[...]
Literal text, the text between brackets is taken as a constant
{n}
Random entry of a datalibrary, n is the number of a data library
{F[r,s,u]:<filespec>}
Random, sequential or unique value from the given file. Defaults to "random". Make sure to include the closing character "}".
#S[:n[:m][:t]];
Sequential value, optionally use n digits, starts at m and use t to trim leading zeroes. "n" and "m" are integers. Make sure to include the closing character ";"
#R[:n[:m][:o][:t]];
Random value, optionally uses n digits, bottoms at m, tops at o and use t to trim leading zeroes. All values are integers, make sure to include the closing character ";".


Examples:

Dutch Zip-code:
NNNN[ ]AA

Possible results:
4214 PO
7645 AB

Last name, First name:
{1}[, ]{5}

Possible results:
Gerda, Iglehart
Justin, Kleinke

Unique value from file "c:\temp\testvalues.txt":
{Fu:c:\temp\testvalues.txt}

Random values, from 1000 to 9999:
#R:4:1000;

or

#R:4:1000:9999;