|
Field Extractor allows you to automatically generate a value
for the appropriate field. You can set the program to generate:
- random numbers;
- random characters;
- current date.
To set the Field Extractor to generate a field value, do the
following:
1. Type a name of a field to generate in the
Field Name box.
2. Select Generated value
from mask menu in the Source box.
3. Enter a mask for a field
value you want to generate in the empty box:
d - denotes random numeric values from 0 to 9
w - denotes random characters from 'a' to 'z'
W - denotes random capital characters from 'A' to 'Z'
\ - inserts the symbols d, w, W (for example, \d means that the program inserts
'd' and do not replace it with a random number from 0 to 9)
\\ - inserts the \ symbol
Examples:
If you enter a mask ddddd, the program will generate a value
for your field from 5 random numbers: 86632.
If you enter a mask like this Or\derID: dddd-ddd-ddd-dddd,
the program will generate the following: OrderID: 2435-645-987-0921.
You are also able to set a special mask to generate a current
date. To do this, enter DateTime: in the
appropriate box and then specify the format of the date you want to be
generated. For example: DateTime: dd-mm-yyyy.
The following formats of date are supported:
|
c |
Displays the date using the format given by the ShortDateFormat global
variable, followed by the time using the format given by the LongTimeFormat
global variable. The time is not displayed if the fractional part of the
DateTime value is zero. |
|
d |
Displays the day as a number without a leading zero (1-31). |
|
dd |
Displays the day as a number with a leading zero (01-31). |
|
ddd |
Displays the day as an abbreviation (Sun-Sat) using the strings given by the
ShortDayNames global variable. |
|
dddd |
Displays the day as a full name (Sunday-Saturday) using the strings given by
the LongDayNames global variable. |
|
ddddd |
Displays the date using the format given by the ShortDateFormat global
variable. |
|
dddddd |
Displays the date using the format given by the LongDateFormat global
variable. |
|
m |
Displays the month as a number without a leading zero (1-12). If the m
specifier immediately follows an h or hh specifier, the minute rather than
the month is displayed. |
|
mm |
Displays the month as a number with a leading zero (01-12). If the mm
specifier immediately follows an h or hh specifier, the minute rather than
the month is displayed. |
|
mmm |
Displays the month as an abbreviation (Jan-Dec) using the strings given by
the ShortMonthNames global variable. |
|
mmmm |
Displays the month as a full name (January-December) using the strings given
by the LongMonthNames global variable. |
|
yy |
Displays the year as a two-digit number (00-99). |
|
yyyy |
Displays the year as a four-digit number (0000-9999). |
|
h |
Displays the hour without a leading zero (0-23). |
|
hh |
Displays the hour with a leading zero (00-23). |
|
n |
Displays the minute without a leading zero (0-59). |
|
nn |
Displays the minute with a leading zero (00-59). |
|
s |
Displays the second without a leading zero (0-59). |
|
ss |
Displays the second with a leading zero (00-59). |
|
t |
Displays the time using the format given by the ShortTimeFormat global
variable. |
|
tt |
Displays the time using the format given by the LongTimeFormat global
variable |
|
am/pm |
Uses the 12-hour clock for the preceding h or hh specifier, and displays
'am' for any hour before noon, and 'pm' for any hour after noon. The am/pm
specifier can use lower, upper, or mixed case, and the result is displayed
accordingly. |
|
a/p |
Uses the 12-hour clock for the preceding h or hh specifier, and displays 'a'
for any hour before noon, and 'p' for any hour after noon. The a/p specifier
can use lower, upper, or mixed case, and the result is displayed
accordingly. |
|
ampm |
Uses the 12-hour clock for the preceding h or hh specifier, and displays the
contents of the TimeAMString global variable for any hour before noon, and
the contents of the TimePMString global variable for any hour after noon. |
|
/ |
Displays the date separator character given by the DateSeparator global
variable. |
|
: |
Displays the time separator character given by the TimeSeparator global
variable. |
|
'xx'/"xx" |
Characters enclosed in single or double quotes are displayed as-is, and do
not affect formatting. |
View Generated Value
tab allows you to view a field value that will be generated by the program
according to the specified mask. Enter a mask in the
Mask field and click
Generate. You will see the appropriate
value in Generated value window. Every
time you click the Generate button, the program will generate a new value for
your field that match the indicated mask.
|
