String

  • ASC text with full-width katakana and ASCII characters converted to half-width
  • CHAR the CP1252 (Windows-1252) character for the code point x
  • CLEAN text with any non-printable characters removed
  • CODE the CP1252 (Windows-1252) code point for the character c
  • CONCATENATE the concatenation of the strings s1, s2,…
  • DOLLAR num formatted as currency
  • EXACT TRUE if string1 is exactly equal to string2
  • FIND first position of string1 in string2 following position start
  • FINDB first byte position of string1 in string2 following byte position start
  • FIXED formatted string representation of num
  • JIS text with half-width katakana and ASCII characters converted to full-width
  • LEFT the first num_chars characters of the string s
  • LEFTB the first characters of the string s comprising at most num_bytes bytes
  • LEN the number of characters of the string s
  • LENB the number of bytes in the string s
  • LOWER a lower-case version of the string text
  • MID the substring of the string s starting at position position consisting of length characters
  • MIDB the characters following the first start_pos bytes comprising at most num_bytes bytes
  • NUMBERVALUE numeric value of text
  • PROPER text with initial of each word capitalised
  • REPLACE string old with num characters starting at start replaced by new
  • REPLACEB string old with up to num bytes starting at start replaced by new
  • REPT num repetitions of string text
  • RIGHT the last num_chars characters of the string s
  • RIGHTB the last characters of the string s comprising at most num_bytes bytes
  • SEARCH the location of the search string within text after position start
  • SEARCHB the location of the search string within text after byte position start
  • SUBSTITUTE text with all occurrences of old replaced by new
  • T value if and only if value is text, otherwise empty
  • TEXT value as a string formatted as format
  • TRIM text with only single spaces between words
  • UNICHAR the Unicode character represented by the Unicode code point x
  • UNICODE the Unicode code point for the character c
  • UPPER an upper-case version of the string text
  • VALUE numeric value of text