SUBSTR

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Extracts a substring from a string.

  • <string>: The source string.
  • <start>: The starting position (1-based).
  • count: The number of characters to extract.

Returns a text value containing the extracted substring.

  • Same as substring(string from start for count) but with comma-separated arguments.
  • Position indexing is 1-based.

Extract two characters starting at position three.

Returns 'ph'.