Apologies for the vague title but I’m hoping the example below makes it clearer
| Name | #Messages |
| US-In-Temperature | 5 |
| US-In-Delta | 10 |
| EU-In-Temperature | 2 |
| EU-In-Delta | 0 |
I want to write a query which creates a table that with regex pulls out the US/EU part and put it in a third column next to the Name and #Messages but for the life of me I can’t figure out how to get regex to work outside of WHERE statements. It’s fine if it’s through a transform rule also.
Thanks in advanced for the help!