I need some help writing a query, I have a tag value named “identifier” that is made up of two values separated by a “” For example:
I’d like a query that returned only the first section of the tag value, before the “”. I’d also like another query that returned the section after the “_”. So the first query in the example would return “Peter” and the second would return “Grayson”
Could anyone help me with this, if it’s actually possible?