Whatever message this page gives is out now! Go check it out!

String functions

Last update:
May 18, 2026
FunctionDescription
AscFinds the ASCII value of a character.
BinaryDecodeConverts a string to a binary object.
BinaryEncodeConverts binary data to a string.
CanonicalizeCanonicalize or decodes the input string.
CharsetDecodeConverts a string to its binary representation.
CharsetEncodeUses the specified encoding to convert binary data to a string.
ChrConverts a numeric value to a UCS-2 character.
CJustifyCenters a string in a field length.
ComparePerforms a case-sensitive comparison of two strings.
CompareNoCasePerforms a case-insensitive comparison of two strings.
DayOfWeekAsStringDetermines the day of the week as a string from 1-7.
DecryptDecrypts a string that is encrypted with the Encrypt function.
EncodeForCSSEncodes the input string for use in CSS.
EncodeForDNEncodes a given string for safe output in LDAP Distinguished Names.
EncodeForHTMLEncodes the input string for safe output in the body of a HTML tag.
EncodeForHTMLAttributeEncodes the input string for safe output in the attribute value of a HTML tag.
EncodeForJavaScriptEncodes the input string for use in JavaScript.
EncodeForLDAPEncodes an input string for a safe output in LDAP queries.
EncodeForURLEncodes the input string for use in URLs.
EncodeForXMLEncodes a string for XML.
EncodeForXMLAttributeEncodes a string that can be used as an XML attribute.
EncryptEncrypts a string.
FindFinds the first occurrence of a substring in a string, from a specified start position.
FindNoCaseFinds the first occurrence of a substring in a string, from a specified start position. The search is not case-sensitive.
FindOneOfFinds the first occurrence of any one of a set of characters in a string, from a specified start position.
FormatBaseNConverts number to a string, in the base specified by a radix.
GenerateSecretKeyGenerates a secure random key value.
GetTokenDetermines whether a token of the list in the delimiters parameter is present in a string.
HashConverts a string into a fixed length hexadecimal string.
HmacCreates Hash-based Message Authentication Code for the given string based on the algorithm and encoding.
HTMLCodeFormatReplaces special characters in a string with their HTML-escaped equivalents and inserts <pre> and </pre> tags at the beginning and end of the string.
HTMLEditFormatDeprecated function
InsertInserts a substring in a string after a specified character position.
JSStringFormatEscapes special JavaScript characters, such as single-quotation mark, double-quotation mark, and newline.
LCaseConverts the alphabetic characters in a string to lowercase.
LeftReturns up to the leftmost count characters in a string.
LenDetermines the length of a string or binary object.
ListValueCountCounts instances of a specified value in a list. The search is case-sensitive.
ListValueCountNoCaseCounts instances of a specified value in a list. The search is case-insensitive.
LJustifyLeft justifies characters in a string of a specified length.
LSIsCurrencyDetermines whether a string is a valid representation of a currency amount in the current locale.
LSIsDateDetermines whether a string is a valid representation of a date/time value in the current locale.
LSIsNumericDetermines whether a string is a valid representation of a number in the current locale.
LSParseCurrencyConverts a locale-specific currency string into a formatted number.
LSParseDateTimeConverts a string that is a valid date/time representation in the current locale into a date/time object.
LSParseEuroCurrencyFormats a locale-specific currency string as a number.
LSParseNumberConverts a string that is a valid numeric representation in the current locale into a formatted number.
LTrimRemoves leading spaces from a string.
MidExtracts a substring from a string.
MonthAsStringDetermines the name of the month that corresponds to month_number.
ParagraphFormatReplaces single and double newline characters with spaces and HTML paragraph tags respectively.
ParseDateTimeParses a date/time string according to the English (U.S.) locale conventions.
REFindUses a regular expression (RE) to search a string for a pattern. The search is case sensitive.
REFindNoCaseUses a regular expression (RE) to search a string for a pattern, starting from a specified position. The search is case-insensitive.
REMatchUses a regular expression (RE) to search a string for a pattern, starting from a specified position. The search is case sensitive.
REMatchNoCaseUses a regular expression (RE) to search a string for a pattern, starting from a specified position. The search is case sensitive.
RemoveCharsRemoves characters from a string.
RepeatStringCreates a string that contains a specified number of repetitions of the specified string.
ReplaceReplaces occurrences of substring1 in a string with an object in a specified scope. The search is case sensitive.
ReplaceListReplaces occurrences of the elements from a delimited list in a string with corresponding elements from another delimited list. The search is case sensitive.
ReplaceNoCaseReplaces occurrences of substring1 with substring2, in the specified scope. The search is case-insensitive.
REReplaceUses a regular expression (RE) to search a string for a string pattern and replace it with another. The search is case sensitive.
REReplaceNoCaseUses a regular expression to search a string for a string pattern and replace it with another. The search is case-insensitive.
ReverseReverses the order of items, such as the characters in a string or the digits in a number.
RightGets a specified number of characters from a string, beginning at the right.
RJustifyRight justifies characters of a string.
RTrimRemoves spaces from the end of a string.
SpanExcludingGets characters from a string, from the beginning to a character that is in a specified set of characters.
SpanIncludingGets characters from a string, from the beginning to a character that is not in a specified set of characters.
StringSortSorts an input string.
StringSomeCalls a given closure/function with every element in a given string and returns true, if one of the closure calls returns true.
StringReduceIterates over every element of the string and calls the closure to work on the elements of the string.
StringMapIterates over every entry of the string and calls the closure function to work on the element of the string.
StringFilterFilters a string to its elements for which the callback function returns true.
StringEveryDetermines if all elements of a string satisfy a given condition.
StringEachiterates over a string and runs the closure function for each element in the string.
StripCRDeletes return characters from a string.
ToBase64Calculates the Base64 representation of a string or binary object.
ToBinaryCalculates the binary representation of Base64-encoded data, PDF document, or a spreadsheet.
ToStringConverts a value to a string.
TrimRemoves leading and trailing spaces and control characters from a string.
UCaseConverts the alphabetic characters in a string to uppercase.
URLDecodeDecodes a URL-encoded string.
URLEncodedFormatGenerates a URL-encoded string.
ValConverts numeric characters that occur at the beginning of a string to a number.
WrapWraps text so that each line has a specified maximum number of characters.
XmlFormatEscapes special XML characters in a string so that the string can be used as text in XML.

Share this page

Was this page helpful?
We're glad. Tell us how this page helped.
We're sorry. Can you tell us what didn't work for you?
Thank you for your feedback. Your response will help improve this page.

On this page