Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r097

D toc

Excerpt

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.

D s lang vs sql
 

D s
snippetBasic

URL literal examples:

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value: suffix('http://www.example.com' ) as: 'myDomain'

suffix('http://www.example.com')

Output: Returns the value com

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value: suffix('http://www.exampl.e.com') as: 'myDomain'

suffix('http://www.exampl.e.com')

Output: Returns the value com

Column reference example:

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value: suffix(myURLs) as: 'myDomain'

suffix(myURLs)

Output: Returns the suffix values extracted from the myURLs column. 

D s
snippetSyntax

D lang syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextderive type:single value: suffix(column_url)

suffix(column_url)


ArgumentRequired?Data TypeDescription
column_urlYstringName of column or String or URL literal containing the suffix value to extract

D s lang notes

column_url

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

  • Missing input values generate missing results.
  • Multiple columns and wildcards are not supported.

D s
snippetusage

 

Required?Data TypeExample Value
YesString literal or column reference (URL)http://www.example.com

D s
snippetExamples

Example - Domain, Subdomain, Host, and Suffix functions

Include Page
EXAMPLE - Domain Functions
EXAMPLE - Domain Functions

D s also
labelother