Result type:           
Country-specific data:      
Number of results:

 Order  Column Title Data Type Examples Options  Help 

Add

SQL Options

Database
Database table name
XML Options

Root node name
Record node name
CSV Options

Delimiter Character(s)

 Generate # words

 Enter values separated by |
Generate # to # words
  
 Between and
 From: To:
 Format code: 
 Start at:    Increment:
Name

This data type randomly generates human names (mostly Western) according to the format you specify. The following strings will be converted to their random name equivalent:

Name A first name, male or female.
MaleName A male first name.
FemaleName A female first name.
Initial An upper-case letter, A-Z.
Surname A random surname.
Phone/Fax Numbers

Whatever text you enter into the options text field will be used to generate telephone numbers. Capital X's will be converted to a random number between 1 and 9; lower-case x's will be converted to a random number between 0 and 9.

Select one of the values in the example dropdown for some ideas. Remember: anything other than the X and x character are left unconverted.

Text: Fixed Number of Words

This option generates a fixed number of random words, pulled the standard lorem ipsum latin text. The Starts with "Lorem Lipsum..." checkbox makes the text begin with lorem ipsum. If it is checked, every result will contain the same words.

Text: Random Number of Words

This option generates a number of random words - the total number with the range that you specified (inclusive). As with the Fixed number option, the words are pulled the standard lorem ipsum latin text.

Custom List

Enter a list of items, separated by a pipe | character. Then select whether you want Exactly X number of items, or At most X items from the list. Multiple items are returned in a comma-delimited list in the results.

Number Range

This randomly generates a number between the values you specify. Both fields allow you to enter negative numbers.

Alphanumeric

This data type lets you generate random alpha-numeric strings. The following table contains the character legend for this field.

L An uppercase Letter. V An uppercase Vowel.
l A lowercase letter. v A lowercase vowel.
D A letter (upper or lower). F A vowel (upper or lower).
C An uppercase Consonant. x Any number, 0-9.
c A lowercase consonant. X Any number, 1-9.
E A consonant (upper or lower).
Postal / Zip Code

Generates a random America or Canadian zip code. For greater control, use the alpha-numeric data type option.

State / Province / County

Generates random Canadian provinces, US states and UK counties, based on the options you select. The Full Name and Abbreviation sub-options determine whether the output will contain the full string (e.g. "British Columbia") or its abbreviation (e.g. "BC"). For UK counties, the abbreviation is the standard 3-character Chapman code.

Date

This data type randomly generates a date between the dates specified, and allows for unique formatting of the result. See the table below for a list of viable formatting rules (these are cribbed from the standard PHP date() formatting options). Take a look at the example dropdown to select from existing formatting options.

Char Description Example
Day
d Day of the month, 2 digits with leading zeros 01 to 31
D A textual representation of a day, three letters Mon through Sun
j Day of the month without leading zeros 1 to 31
l A full textual representation of the day of the week Sunday through Saturday
S English ordinal suffix for the day of the month, 2 characters st, nd, rd or th. Works well with j Sunday through Saturday
w Numeric representation of the day of the week 0 (for Sunday) through 6 (for Saturday)
z The day of the year (starting from 0) 0 through 365
Week
W ISO-8601 week number of year, weeks starting on Monday 42 (the 42nd week in the year)
Month
F A full textual representation of a month, such as January or March January through December
m Numeric representation of a month, with leading zeros 01 through 12
M A short textual representation of a month, three letters Jan through Dec
n Numeric representation of a month, without leading zeros 1 through 12
t Number of days in the given month 28 through 31
Year
L Whether it's a leap year 1 if it is a leap year, 0 otherwise.
Y A full numeric representation of a year, 4 digits 1999 or 2003
y A two digit representation of a year 99 or 03
Auto-increment

Generates a column that contains a unique number on each row, incrementing by whatever value you enter. This option is helpful for inserting the data into a database field with an auto-increment primary key.