Product Home
DTM Data Generator Online Documentation Prev Page Prev Page
General
Product Profile
Product Versions
Quick Start
Rule Wizard
System requirements
Connect to Database
Project Properties
Program Settings
General
Interface
Rule and project
Execution
Date and Time Formats
Execution
Random BLOB Loader
Project migration
Database Model Viewer
Fill Table Rule
Table Fill Modes
Table Fill Options
Tables options
Columns options
Row count tab
Scripts
Rule Output
Preview
Fill Methods
Method Options
Random values
Values list
From table
List from file
From Values Library
Incremental
By mask
By SQL statement
By formula
Custom generator
Named Generators
Field groups
Advanced Rules
Clear Rule
Tables Creation Options
Objects Creation
File Rule
Advanced Features
Tables Selection
Table Information
Value Library
Command Line
Performance Tips
Performance mode
Format Strings
Select column
Data export
How to...
Additional Info
Product Ordering
Database Utilities
Licence agreement
Demo version
Install
Uninstall
Upgrade
Support
Glossary

By mask fill method

A mask is a text string with any number of 'A', 'a' and 'N' characters. During the value generation process the 'A' and 'a' characters is 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 mask characters will be moved to the result value without any changes.
If you want to specify several different masks for filling a field, you should use the "From the List" method and specify masks as values with the "Use list items as a mask" mode on.
You can use '\' character for escape next mask sign. For example, \a will be used as a 'a' letter without any replacements. Also, you can use I or I{n} item for autoincremental field. n is field size, I{3} means 001,002,...,999

There are mask 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, value will be used from 1 to n times. n should be from 1 to 999.
  • {=n} - repeater, value will be used n times.
  • {n;m} - repeater, value will be used from n to m times. n should be less then m and both numbers from 1 to 999.
  • I{n} - autoincremental value from 1 to 10**n.
  • # - copy value of the last used {} block.
  • L{item name} - reference to value library item.

By mask fill method setup window

Examples:

Mask Sample values
I{2} A 01 F,02 A,03 B,04 Z,...
I{2}-# 01-01,02-02,03-03,04-04,...
ANNaaN K15rb6,J46xm7,V02bq9,A30et4,...
N{3} L{US_Streets} 3 Jackson Hole Court,342 Christine Avenue,34 Koyuk Avenue...