Hi community, is there a way to filter in a set of data for the following:
We need a way to only extract Information for et2
et2: random
et21: random
et22: random
We don´t know what random is prior to filtering and only want et2 as a result. *et2* would obviously report all three. Sorry for that dumb line of questioning here... I guess the question is: Are you et2 and et2 only without any other number following?
Hi Johannes, Thank you for using the Dojo community. I will make some assumptions, so feel free to correct me if I'm wrong on something.
If you would like to filter rows from a table available on the Data pages of an element, then you can make use of Regex in the filter box. I assume you would like to have filtering based on the part before the colon character. In that case, you could use the following regex: "*COLUMN NAME*":regex:et2[^0-9]+$
You can see below an example from my local setup:
Thank you Jarno, we´ll try it out and let you know if it works.
Please be aware that the “:” are just for the example, I´m looking for general syntax, I know I can solve this specific one by closing the filter with “:”