> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# ETL: ExtractUrlPart

> Extract a specific component (host, path, port, query) from a URL field. Use EXTRACTURLPART for URL parsing and analysis in ETL pipelines.

## Description

Extracts a specified part from a URL field.

## Syntax

`ExtractUrlPart(url, url_part)`

## Arguments

*url* - string expression indicating a url

*url\_part* - string with these possible values to retrieve the corresponding component of the url:

* scheme or protocol returns protocol identifier
* host returns host name
* port returns port number
* path returns path
* query returns query
* ref or fragment returns reference

## Examples

`ExtractUrlPart('http://someurl.com:80/path1/path2/file.html?origin=135#PORTION1', 'protocol')` returns: 'http'

`ExtractUrlPart('http://someurl.com:80/path1/path2/file.html?origin=135#PORTION1', 'host')` returns: 'someurl.com'

`ExtractUrlPart('http://someurl.com:80/path1/path2/file.html?origin=135#PORTION1', 'port')` returns: '80'

`ExtractUrlPart('http://someurl.com:80/path1/path2/file.html?origin=135#PORTION1', 'path')` returns: 'path1/path2/file.html'

`ExtractUrlPart('http://someurl.com:80/path1/path2/file.html?origin=135#PORTION1', 'query')` returns: 'origin=135'

`ExtractUrlPart('http://someurl.com:80/path1/path2/file.html?origin=135#PORTION1', 'fragment')` returns: 'PORTION1'

## Return value datatype

String

## Notes

If the specified part is not supported an exception is thrown.

## Impact of null value

If any (or all) inputs are null, or the specified part is not present in the url or an exception is thrown, returns null.