Filter for column that contains numeric value at the end

Question & Answer
1

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.

2

@CWong please refer this post Extract numeric portion of a string to check if it can help you with extracting numeric part of the string value.