With the launch of four new NRQL functions, you can now transform string data right within your query.
Better formatting and easier comparisons
substring()extracts part of a string
position()finds the location of a substring within a string
lower()changes a string to lowercase
upper()changes a string to uppercase
Combine functions to query what you need
By combining these new string functions, you can extract and format the data you want right within your NRQL query. This can be especially powerful when combined with our recently announced NRQL variables feature for even faster insights:
Review the docs for substring(), position(), upper(), and lower() and start working with strings in your queries!