View Source

Finds the suffix value after the domain from a valid URL. Input values must be of URL or String type.

This function is part of a set of functions for processing URL data.

URL literal examples:

derive type:single value: SUFFIX('http://www.example.com' ) as: 'myDomain'

Output: Generates a column containing the value com.

derive type:single value: SUFFIX('http://www.exampl.e.com' ) as: 'myDomain'

Output: Generates a column containing the value com.

Column reference example:

derive type:single value: SUFFIX(myURLs) as: 'myDomain'

Output: Generates the new myDomain column containing the suffix values extracted from the myURLs column.

derive type:single value: SUFFIX(column_url)

Argument	Required?	Data Type	Description
column_url	Y	string	Name of column or String or URL literal containing the suffix value to extract

Name of the column or URL or String literal whose values are used to extract the suffix value.

Required?	Data Type	Example Value
Yes	String literal or column reference (URL)	`http://www.example.com`