String Functions

String	Description
Asc	Returns a number representing the character code of the first character in string.
Base64DecodeBinary	Returns decoded binary string of a Base64 encoded string.
Base64DecodeString	Given a Base64 encoded string, returns its decoded version as a string.
Base64DecodeToFile	Decodes a given base 64 string to a binary file.
Base64EncodeBinary	Returns Base64 encoded version of a binary string.
Base64EncodeFile	Returns Base64 encoded version of a file.
Base64EncodeString	Returns Base64 encoded version of given Text.
Chr	Returns a one character string containing the character whose character code is number. Number must be in the range 0-255, or a run-time error will occur.
ConvertAscii	Converts a Unicode string to ASCII.
DequotedString	Returns a properly dequoted string.
DropChars	Removes all occurrences of each character in a string, from another string.
FormatBankAccountNo	Formats a BankAccountNo from a valid BankAccountNo and Pattern string for a specified country.
FormatTaxNo	Formats a TaxNo from a valid TaxNo and Pattern string for a specified country.
GenerateGUID	Returns a Globally Unique Identifier (GUID) as a string.
InStr	Returns the position of one string within another string.
InstrRev	Returns the position of one string within another string, from the end of the string.
Join	Joins an object and a delimiter, and returns a delimited string.
KeepChars	Removes all occurrences of any character not contained in a string, from another string.
Left	Returns the leftmost characters of a string, of a selected length.
Len	Returns the length of string.
Lower	Returns a string in lower case.
LPad	Left pad string to a specified number of characters.
LTrim	Removes leading spaces from a string.
MakeValidCode	Strips non-printing and invalid characters from a code.
MatchRegEx	Returns a Boolean indicating whether regular expression matches string.
Mid	Returns a sub-string of a string.
PadAcctNo	Creates a bank account number from a Bank Account string and a Pattern string, using a Pad Character.
Proper	Returns a string in proper case.
QuotedString	Returns a properly quoted string.
Replace	Replaces a specified substring with another substring.
ReplaceRegEx	Returns a replaced string based on regular expression.
Right	Returns the rightmost characters of a string, of a selected length.
RPad	Right pad string to a specified number of characters.
RTrim	Removes trailing spaces from a string.
Str	Converts an expression into a string.
Split	Splits a text string into a list of strings, separated by a delimiter.
TransformPhoneNo	Returns transformed Phone no using transformations.
Trim	Removes leading and trailing spaces from a string.
Upper	Returns a string in upper case.
ValidBankAccountNo	Returns a boolean indicating whether given AccountNo is valid for a specified country (currently only NZ).
ValidCode	Validates a code.
ValidEmailAddress	Validates an Email Address.
ValidFileName	Return a valid file name.
ValidTaxNo	Returns a boolean indicating whether given TaxNo is valid for a specified country (currently only NZ).
WordAmount	Returns string with an amount in words.