Hi, I have a data column named “project cycle” that displays text and occasionally numeric value at the end.
For example sample data values would look like:
Project A_cycle1
Project A_cycle 10
Project A
I only want to see the data where there is a number at the end of the text field. So using above example, only Project A_cycle1 and Project A_cycle 10 will return.
How do I achieve this?
I am used to working in SQL query , where I would simply do right(“project cycle”,1) like ‘[0-9]’ , but QuickSight seem to work very differently.
Thank you for any help in advance.