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
Quick Start
Direct Connection
Connect to Desktop File
Data Sources
DSN File
OLE DB Connection
Connection Profile
Connection Information
Troubleshooting Guide
Project Properties
Project Report
Program Settings
General
Interface
Rule and Project
Execution
Date and Time
Execution
Random BLOB Loader
Project Migration
Database Model Viewer
Fill Table Rule
Table Fill Modes
Table Fill Options
Tables Options
Columns Options
Row count
Scripts
Rule Output
Preview
Fill Methods
Method Options
Random Values
Value List
From Table
List from File
From Value Library
Incremental
By Pattern
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
Bulk Project Modification
Table Information
Value Library
Variables
Execution Report
Change Target Table
Command Line
Performance Tips
Performance Mode
Format Strings
Select Column
SQL Console
Data Export
How to...
Additional Info
Product Ordering
Database Utilities
Licence Agreement
Demo Version
Install
Uninstall
Upgrade
Support
Log File
Trademark Information
Glossary

By pattern fill method

Pattern 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 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 "From the List" method and specify patterns as values with the "Use list items as a pattern" mode on.
You can use '\' character for escape next pattern sign. For example, \a will be used as a '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, 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.

Pease refer to detailed pattern engine manual (online).

DTM Data Generator: By pattern fill method

Examples:

Pattern 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} $Lib{Streets} 3 Jackson Hole Court,342 Christine Avenue,34 Koyuk Avenue...