DataMigrator/Reporting Server > Simplified Character Functions > SPLIT: Extracting an Element From a String

SPLIT: Extracting an Element From a String

How to:

The SPLIT function returns a specific type of element from a string. The output is returned as variable length alphanumeric.

Syntax: How to Extract an Element From a String 

SPLIT(element, string)

where:

element

Can be one of the following keywords:

  • EMAIL_DOMAIN. Is the domain name portion of an email address in the string.
  • EMAIL_USERID. Is the user ID portion of an email address in the string.
  • URL_PROTOCOL. Is the URL protocol in the string.
  • URL_HOST. Is the host name of the URL in the string.
  • URL_PORT. Is the port number of the URL in the string.
  • URL_PATH. Is the URL path in the string.
  • NAME_FIRST. Is the first token (group of characters) in the string. Tokens are delimited by blanks.
  • NAME_LAST. Is the last token (group of characters) in the string. Tokens are delimited by blanks.
string

Alphanumeric

Is the string from which the element will be extracted.

Example: Extracting an Element From a String

SPLIT extracts the URL protocol from the string STRING1. 

SPLIT(URL_PROTOCOL, STRING1)

For 'http://www.informationbuilders.com', the result is http.

WebFOCUS

Feedback