Macro Commands

Previous  Top  Next

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

 

Also see the Macro Editor.

 

When creating a macro, the following are legal macro command 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)

@

Random domain name and top level domain name concatenated to this format: randomname.randomtld

eg: hotmail.com

[...]

Literal text, the text between brackets is taken as a constant

{n[:r]}

Random entry taken from a "data library", n is the number of a data library

Optionally remove special characters if you add "r".

{F[r,s,u]:<filespec>}

Random, sequential or unique value from the given file. Defaults to "random". Make sure to include the closing character "}".

{C:<column number>[:r]}

Take a generated value from column column number and use it. The first column in the table is 1, these numbers are visible in the tree view with tables and columns. Make sure to include the closing character "}".

Optionally remove special characters if you add "r".

#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

 

 

Random e-mail address:

{3000}[.]{4000}[@]@

 

 

Last name, First name:

{4000}[, ]{3000}

 

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;