Get Word ✂️
Danny Roden Administrator
edited July 2021 in Functions Library
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.
Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.