RandomString

Description

Returns a random series of characters

Syntax

RandomString(<length>,[ForceUnique], [CharType], [CaseType], [InputChars])

Arguments

Argument Type Description Optional
Length Numeric Value The length of string to return No
ForceUnique Boolean Whether all values returned should be forced to be unique Yes [Default = True]
CharType CharType What type of characters to return (e.g. alpha/numeric/alphanumeric) Yes [Default = AlphaNumeric]
CaseType CaseType The character case to return (e.g. upper/lower/mixed) Yes [Default = Lower]
InputChars Text A set of characters to draw the random string from Yes [Default = “” (Blank)]

CharType

Value Description
1 AlphaNumeric
2 Alpha
3 Numeric
4 Custom

CaseType

Value Description
1 Lower
2 Upper
3 Mixed

Returns

Text

Examples

Expression: RANDOMSTRING(5, True, 1, 3)
Returns: AAbb1

Download

Download Example