By pattern data generation method

This generation method allows the user to specify pattern as data generator.

Pattern

The pattern is a text string with any number of 'A', 'a' and 'N' characters. During the value generation process, the 'A' and 'a' characters are replaced with a random letter (from 'A' to 'Z' and from 'a' to 'z') and the 'N' character is replaced with a random figure. {n} means iterate last sign 1 to n times. All the rest of the pattern characters will be moved to the result value without any changes.
If you want to specify several different patterns for filling a field, you should use the "$List" function.
You can use '\' character for escape next pattern sign. For example, \a will be used as an 'a' letter without any replacements.

There are easy pattern items:

  • A - letter from 'A' to 'Z'.
  • a - letter from 'a' to 'z'.
  • N - digit from '0' to '9'.
  • X - hexadecimal digit from '0' to '9' and 'A' to 'F'.
  • {n} - repeater, the value will be used from 1 to n times. n should be from 1 to 999.
  • {=n} - repeater, the value will be used n times.
  • {n;m} - repeater, the value will be used from 'n' to 'm' times. 'n' should be less than 'm' and both numbers from 1 to 999.

Please refer to detailed pattern engine manual (on-line).

DTM Data Generator: By pattern data generation method

The tool offers a few useful predefined patters. They available via menu:

DTM Data Generator: predefined patterns selection menu

Examples

PatternSample values
ANNaaNK15rb6,J46xm7,V02bq9,A30et4,...
N{3} $Lib{Streets}3 Jackson Hole Court,342 Christine Avenue,34 Koyuk Avenue...