Skip to main content
Workday User Guide
Last Updated: 2023-06-23
EXTRACT_COOKIE

EXTRACT_COOKIE

Description

EXTRACT_COOKIE
is a row function that extracts the value of the given cookie identifier from a semi-colon delimited list of cookie key/value pairs. This function can be used to extract a particular cookie value from a combined web access log Cookie column.

Syntax

EXTRACT_COOKIE
("
cookie_list_string
",
cookie_key_string
)

Return Value

Returns the value of the specified cookie key as type
TEXT
.

Input Parameters

cookie_list_string
Required. A field of type
TEXT
or literal string that has a semi-colon delimited list of cookie
key=value
pairs.
cookie_key_string
Required. The cookie key name for which to extract the cookie value.

Examples

Extract the value of the
vID
cookie from a literal cookie string:
EXTRACT_COOKIE("SSID=ABC; vID=44", "vID") returns
44
Extract the value of the
vID
cookie from a field named
Cookie
:
EXTRACT_COOKIE([Cookie],"vID")