You are here:

String statements

String statements convert and query strings and return values.

Statement	Description
Chr	Returns the character representation of a Unicode value.
ContainsSubStr	Returns True or False to indicate if a string contains a substring.
DecimalSeparator	Returns the decimal separator based on regional settings.
DecryptString	Decrypts an encrypted text string and returns it in plain text.
EncryptString	Encrypts a text string.
EndsWithSubStr	Returns True or False to indicate if a string ends with a substring.
FindSubStr	Returns the index of the first occurrence of a substring in a string.
Format	Returns a formatted string using values from an array.
Left	Returns a number of characters from the beginning of a string.
Length	Returns the number of characters in a string.
Lower	Converts characters in a string to lowercase and returns the string.
MakeRegExpression	Returns a regular expression built from a string.
MakeURL	Returns a full URL constructed by combining a root URL and a component.
Mid	Returns a number of characters starting with a position in a string.
ParseString	Returns an array of substrings from an original delimited string.
Replace	Replaces text in a string and returns the resulting string.
Right	Returns a number of characters from the end of a string.
StartsWithSubStr	Returns True or False to indicate if a string starts with a substring.
Str	Converts a value and returns it as a string.
StrCompare	Returns an integer to indicate if two strings match or the string sorted first based on alphabetical order comparison.
StrEquals	Returns True or False to indicate if two strings match.
Trim	Returns a string with the leading and trailing spaces removed.
Upper	Converts characters to uppercase and returns the string.