String Functions by Reference System

December 16, 2025 ยท View on GitHub

Reference Systems

  • [Alteryx]
  • [Sql Down Under]
  • [SQL Server]

Alteryx

  • Contains(String, Target, CaseInsensitive=1)
  • CountWords(String)
  • DecomposeUnicodeForMatch(String)
  • EndsWith(String, Target, CaseInsensitive=1)
  • FindString(String,Target)
  • GetWord(String, n)
  • Left(x, len)
  • Length(x)
  • LowerCase(x)
  • MD5_ASCII(String)
  • MD5_UNICODE(String)
  • PadLeft (str, len, char)
  • PadRight (str, len, char)
  • REGEX_CountMatches(string,pattern,icase)
  • REGEX_Match(string,pattern,icase)
  • REGEX_Replace(string, pattern, replace,icase)
  • Replace(Str, Target, Replacement)
  • ReplaceChar(x, y, z)
  • ReplaceFirst(Str, Target, Replacement)
  • ReverseString(Str)
  • Right(String, len)
  • StartsWith(String, Target, CaseInsensitive=1)
  • STRCSPN(x, y)
  • StripQuotes(x)
  • STRSPN(x, y)
  • Substring(x, start, length)
  • TitleCase(x)
  • Trim(x, y)
  • TrimLeft(x, y)
  • TrimRight(x, y)
  • Uppercase(x) Converts a string to upper case
  • UuidCreate()

Sql Down Under

  • AlphabeticOnly - Removes any non-alphabetic characters from a string
  • AlphanumericOnly - Removes any non-alphanumeric characters from a string
  • AsciiOnly - Removes non-ASCII characters from a string
  • CamelCase - Converts a string to camelCase
  • CobolCase - Converts a string to COBOL-CASE
  • CountWords - Counts the number of words in a string
  • DigitsOnly - Removes non-digit characters from a string
  • ExtractToken - Extracts a specific token number from a delimited string like a CSV or TSV
  • ExtractTrigrams - Extracts trigrams (segments of up to 3 characters) from a string for fast searching
  • ExtractTrimmedWords - Extracts words from a string and trims them
  • InitialsFromName - Extracts a person's initials from their name
  • InvertString - Returns an upside down version of the string
  • KebabCase - Converts a string to kebab-case
  • LeftPad - Left pads a string
  • NullIfBlank - Returns NULL if a string is blank or trims the string
  • PascalCase - Converts a string to PascalCase
  • PercentEncode - Encodes reserved characters that are used in HTML or URL encoding
  • PreviousNonWhitespaceCharacter - Finds the previous non-whitespace character working backwards from the current position
  • ProperCase - Converts a string to Proper Case
  • QuoteString - Quotes a string
  • RightPad - Right pads a string
  • ScreamingSnakeCase - Converts a string to SCREAMING_SNAKE_CASE
  • SeparateByCase - Inserts spaces in Pascal-cased or camel-cased strings
  • SingleSpaceWords - Trims a string and replaces multiple spaces with single spaces
  • SnakeCase - Converts a string to snake_case
  • SplitDelimitedString - Splits a delimited string (often CSV or TSV)
  • SplitDelimitedStringIntoColumns - Splits a delimited string (often CSV or TSV) into separate columns
  • SpongeBobSnakeCase - Converts a string to sPoNgEbOb_sNaKeCaSe
  • StringLength - Returns the length of a string (Properly)
  • StripDiacritics - Strips diacritics (accents, graves, etc.) from a string
  • TitleCase - Converts a string to Title Case
  • TrainCase - Converts a string to Train-Case
  • Translate - Replaces a set of characters in a string
  • TrimWhitespace - Removes any leading or trailing space, tab, carriage return, and linefeed characters
  • XMLDecodeString - XML decodes a string
  • XMLEncodeString - XML encodes a string

Sql Server

  • ASCII Returns the ASCII value for the specific character
  • CHAR Returns the character based on the ASCII code
  • CHARINDEX Returns the position of a substring in a string
  • CONCAT Adds two or more strings together
  • Concat with + Adds two or more strings together
  • CONCAT_WS Adds two or more strings together with a separator
  • DATALENGTH Returns the number of bytes used to represent an expression
  • DIFFERENCE Compares two SOUNDEX values, and returns an integer value
  • FORMAT Formats a value with the specified format
  • LEFT Extracts a number of characters from a string (starting from left)
  • LEN Returns the length of a string
  • LOWER Converts a string to lower-case
  • LTRIM Removes leading spaces from a string
  • NCHAR Returns the Unicode character based on the number code
  • PATINDEX Returns the position of a pattern in a string
  • QUOTENAME Returns a Unicode string with delimiters added to make the string a valid SQL Server delimited identifier
  • REPLACE Replaces all occurrences of a substring within a string, with a new substring
  • REPLICATE Repeats a string a specified number of times
  • REVERSE Reverses a string and returns the result
  • RIGHT Extracts a number of characters from a string (starting from right)
  • RTRIM Removes trailing spaces from a string
  • SOUNDEX Returns a four-character code to evaluate the similarity of two strings
  • SPACE Returns a string of the specified number of space characters
  • STR Returns a number as string
  • STUFF Deletes a part of a string and then inserts another part into the string, starting at a specified position
  • SUBSTRING Extracts some characters from a string
  • TRANSLATE Returns the string from the first argument after the characters specified in the second argument are translated into the characters specified in the third argument.
  • TRIM Removes leading and trailing spaces (or other specified characters) from a string
  • UNICODE Returns the Unicode value for the first character of the input expression
  • UPPER Converts a string to upper-case

External references