Random test data generator help


Settings Remark
Show custom data type 1..5 You can create your own custom data type by entering a format string.

Format strings:
  • Number!Character

    The Number followed by an exclamation mark "!" indicates a fixed length output. The Number indicates the total length of the output and the Character determines which letters and/or digits should be displayed randomly.

    Number = 1, 2, 3...
    Character = c, C, D, E, F, l, L, n, v, V, x, X, z

    The generated output is limited to max. 100 characters.
    For example "101!L" is not allowed.

    Character Description Format string

    Output
    c A lowercase consonant:
    b,c,d,f,...    		 5!c

    jkfty
    C An uppercase consonant:
    B,C,D,F,...    		 5!C

    JKFTY
    D A letter (uppercase or lowercase):
    a-z,A-Z    		 5!D

    aEjmK
    E A consonant (uppercase or lowercase):
    b,c,d,f,...,B,C,D,F,...    		 5!E

    HrTZq
    F A vowel (uppercase or lowercase):
    a,e,i,o,u,A,E,I,O,U    		 5!F

    aEiOo
    l A lowercase letter:
    a-z    		 5!l

    ndaop
    L An uppercase letter:
    A-Z    		 5!L

    NDAOP
    n Any number (number never starts with 0):
    0-9    		 5!n

    94024
    06353
    v A lowercase vowel:
    a,e,i,o,u    		 5!v

    aiaou
    V An uppercase vowel:
    A,E,I,O,U    		 5!v

    AIAOU
    x Any number:
    0-9    		 5!x

    05709
    X Any number:
    1-9    		 5!X

    15769
    z Any letter (uppercase or lowercase) or number:
    a-z,A-Z,0-9    		 5!z

    y9ZaT

  • NumberCharacter

    The Number without an exclamation mark "!" indicates a maximum length output. The minimum length of the output is always 1. The Number indicates the maximum length of the output. The Character determines which letters and/or digits should be displayed randomly.

    Number = 1, 2, 3...
    Character = c, C, D, E, F, l, L, n, v, V, x, X, z

    The generated output is limited to max. 100 characters.
    For example "101L" is not allowed.

    Character Description Format string

    Output
    c A lowercase consonant:
    b,c,d,f,...    		 5c

    jkfty
    jk
    C An uppercase consonant:
    B,C,D,F,...    		 5!C

    JKFTY
    JK
    D A letter (uppercase or lowercase):
    a-z,A-Z    		 5!D

    aEjmK
    aE
    E A consonant (uppercase or lowercase):
    b,c,d,f,...,B,C,D,F,...    		 5!E

    HrTZq
    Hr
    F A vowel (uppercase or lowercase):
    a,e,i,o,u,A,E,I,O,U    		 5!F

    aEiOo
    aE
    l A lowercase letter:
    a-z    		 5!l

    ndaop
    nd
    L An uppercase letter:
    A-Z    		 5!L

    NDAOP
    ND
    n Any number (number never starts with 0):
    0-9    		 5!n

    94024
    94
    06353
    v A lowercase vowel:
    a,e,i,o,u    		 5!v

    aiaou
    ai
    V An uppercase vowel:
    A,E,I,O,U    		 5!v

    AIAOU
    AI
    x Any number:
    0-9    		 5!x

    05709
    05
    X Any number:
    1-9    		 5!X

    15769
    15
    z Any letter (uppercase or lowercase) or number:
    a-z,A-Z,0-9    		 5!z

    y9ZaT
    y9

  • [String | String | ..]

    Place one or more Strings between the square brackets "[ ]".
    Separate the Strings by a pipe "|".
    A String consists of one or more characters.
    Any character can be used ((including space), except: {  }  [  ]  <  >

    If only 1 String is used between the square brackets, this String is displayed as-is, for example:

    Format string:
    [OFFICE item-234-]

    Output:
    OFFICE item-234-
    OFFICE item-234-
    OFFICE item-234-
    :

    If three Strings are used between the square brackets, randomly one of the three strings is displayed, for example:

    Format string:
    [Mr.|Mrs.|Ms.]

    Output:
    Mr.
    Mr.
    Mrs.
    :

    The generated output is limited to max. 100 characters.
    For example
    "[AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
    AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA]" is not allowed.

  • <Number>

    Place a positive or negative number between the arrow brackets "< >"
    This custom data format creates numbers which starts with:
    Number, Number+1, Number+2,...

    The generated output is limited to max. 100 characters.

    If the Number has one or more leading zeros, the generated numbers have leading zeros. The number of characters between the arrow brackets "< >" determines how many leading zeros should be added.

    Format string (without leading 0):
    <43>

    Output:
    43
    44
    45
    :

    Format string (with leading 0 and 100 records should be generated):
    <000105>

    Output:
    000105
    000106
    :
    000204

    Format string (with leading 0 and 100 records should be generated):
    <00099>

    Output:
    00099
    00100
    :
    00198

    Format string (with leading 0 and 5000 records should be generated):
    <010>

    Output:
    0010
    0011
    :
    5009

    Format string (negative number):
    <-1>

    Output:
    -1
    0
    1
    :

  • {MinNumber, MaxNumber, Option}

    Place MinNumber, MaxNumber and Option between curly brackets "{ }".
    MinNumber, MaxNumber and Option must be separated by a commas.

    MinNumber = respresents a minimum number and can be a positive or negative number.

    MaxNumber = respresents a maximum number and can be a positive or negative number. MaxNumber must be bigger than MinNumber

    Option = random, sequential, digit_1_c, digit_2_c, digit_3_c, digit_4_c, digit_5_c, digit_1_d, digit_2_d, digit_3_d, digit_4_d, digit_5_d

    This custom data format generates numbers which alway lies between the MinNumber and MaxNumber range.
    The Option determines which numbers should be generated within the range.

    The generated output is limited to max. 100 characters.

    Option Description Format string

    Output
    random Randomly generates numbers within the range. {1,10,random}

    2
    1
    3
    3
    10
    :


    {-10,10,random}

    -10
    1
    0
    3
    10
    :
    sequential Sequentially generates numbers within the range. {1,10,sequential}

    1
    2
    :
    9
    10
    1
    2
    :
    9
    10

    {-10,10,sequential}

    -10
    -9
    :
    9
    10
    -10
    -9
    :
    9
    10

    digit_1_c
    digit_2_c
    digit_3_c
    digit_4_c
    digit_5_c

    digit_1_d
    digit_2_d
    digit_3_d
    digit_4_d
    digit_5_d     		Randomly generates decimal numbers within the range.

    The number of digits to the right of the decimal point can be between 1 or 5.

    The decimal point can be a comma or a dot.     		{1,10,digit_2_c}

    3,06
    2,80
    9,74
    2,93
    4,71

    {100,200,digit_5_d}

    123.41764
    109.18656
    143.32037
    150.47596
    107.21899

    {-10,10,digit_1_d}

    9.0
    -8.5
    2.1
    6.9
    -4.5



  • The previous described formats strings can be combined in any order Number!Character
    NumberCharacter
    [String | String | ..]
    <Number>
    {MinNumber, MaxNumber, Option}

    The generated output is limited to max. 100 characters.

    Here below are several examples:

    Format string:
    [ITEM-]5!L[-]<00001>

    Output:
    ITEM-UDTUM-00001
    ITEM-IGHPY-00002
    ITEM-TADGX-00003
    ITEM-CRMGS-00004
    ITEM-TERJC-00005

    Format string:
    [SHIRT-][GREEN|BLUE|BLACK|WHITE]

    Output:
    SHIRT-BLUE
    SHIRT-BLACK
    SHIRT-BLUE
    SHIRT-GREEN
    SHIRT-BLACK

    Format string (Password):
    5!D3!x[!|?|#|*]

    Output:
    BsDiA055#
    HseOU209?
    gpcrm624#
    JtCOe842*
    lvijy366!

    Format string (Money):
    {0,1000,digit_2_d}[ Euro]

    Output:
    531.00 Euro
    269.12 Euro
    553.71 Euro
    435.48 Euro
    631.64 Euro

    Format string (Phone Canada):
    [(]3!n[) ]3!n[-]4!x

    Output:
    (224) 460-1936
    (641) 161-5614
    (152) 508-3405
    (235) 550-7640
    (918) 212-4659

    Format string (Phone Canada):
    [1-]3!n[-]3!n[-]4!x

    Output:
    1-707-699-1656
    1-949-230-8399
    1-705-313-3520
    1-943-577-7573
    1-903-718-4182

    Format string (Phone UK):
    [1 ]2!n[ ]3!n[ ]4!n[-]4!x

    Output:
    1 79 909 7003-6324
    1 74 572 3252-5166
    1 65 724 9874-7445
    1 81 794 1866-1461
    1 55 567 7840-5527

    Format string (Date):
    {1,28,random}[-]{1,12,random}[-]{1970,2010,random}

    Output:
    28-4-1995
    9-5-2000
    12-10-1980
    26-12-1985
    10-5-1977

    Format string:
    90!L11!x

    The format string is invalid.
    The generated output is limited to max. 100 characters.