func.substring

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 1: 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 April 06, 2022 at 10:08 AM EST: Initial Documentation Commit (371ae8f)