SUBSTR

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Extracts a substring from a string.

1substr(<string>, <start> [, count])

• <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.

1SELECT substr('alphabet', 3, 2) AS result;

Returns 'ph'.

• String Types