URL_PATH
Description
URL_PATH
is a row function that returns the path portion of a URL string.Syntax
URL_PATH
(URL_string
)Return Value
Returns the path portion of a URL as a
TEXT
value, NULL
if the URL or does not contain a path, or NULL
if the input string is not a valid URL.For example, in the string
http://www.workday.com/company/contact.html
, the path portion is /company/contact.html
. In the string
http://admin:admin@127.0.0.1:8001/index.html
, the path portion is /index.html
.In the string
mailto:username@mycompany.com?subject=Topic
, the path portion is username@mycompany.com
.Input Parameters
- URL_string
- Required. A field or expression that returns aTEXTvalue in URI (uniform resource identifier) format of:.protocol:authority[/path][?query][#fragment]
- The optional path portion of the URL is a sequence of resource location segments separated by a forward slash (/), conceptually similar to a directory path.
Examples
Return the path portion of URL string values in the
request
field:URL_PATH([request])
Return the path portion of a literal URL string:
URL_PATH("http://workday.com/company/contact.html")
returns /company/contact.html
.