ETL: ExtractQueryStringParam

Extract the value of a specific query string parameter from a URL field. Use for URL parsing and web analytics processing in ETL data pipelines.

Description

Extracts the value from a specified query string parameter for a url field.

Syntax

ExtractQueryStringParam(url, param_name)

Arguments

url - url string expression

param_name - string expression indicating the parameter to extract

Examples

ExtractQueryStringParam('http://someurl/?origin=135&target=example', 'origin') returns: ‘135’

ExtractQueryStringParam('http://someurl/?origin=135&origin=246,id=321', 'origin') returns: ‘135,246,id=321’

Return value datatype

String

Impact of null value

If any (or all) inputs are null, returns null.