Get Word ✂️

Danny Roden
Danny Roden Administrator
edited December 2023 in Functions library

Get Word

Extracts the 'nth' word from a string (where 'n' is defined when the function is executed). Where n = 2 the second word is retrieved, where n = -1 the last word is retrieved. This is useful as a building block for building other functions (such as match keys or for defining parsing logic).

See below for a screenshot of the function along with some sample output results (showing the second word being returned for the first 2x rows and the last word being returned for the bottom 2x rows):


This function is compatible with all instances of Data Studio from v2.1.11 onwards.