func.substring

The SUBSTRING() extracts a substring with a specified length starting from a location in an input string

The SUBSTRING() extracts a substring with a specified length starting from a location in an input string

Syntax

func.substring(string, start, length)

Examples

Example: Takes the first 5 characters from a 9 digit postal code

func.substring(table.ship_to_postal_code, 1, 5)
func.substring('Plaidcloud_string', 1,10) --> Plaidcloud
Last modified November 27, 2023 at 12:56 PM EST: Restructured the file structure/a few changes (f6c58b8)