Find Records That End w/ a Letter

[hellyars]

I have a text field.  It is primarily consists of numbers (in a vstring).  But, a small number end in a letter -- to designate something being added.

I want to search the field and find only the entries that end in a letter.  How?

Line Number	Find
1
1a	1a
2
43
43a	43a
43b	43b
100
101
128
128X	128X
129

[atcodedog05 · Accepted solution]

Hi @hellyars 

Use formula like below. By default, regex is case insensitive hence \u check for any letter irrespective of case.

IIF(REGEX_Match([Line Number], ".+\u"), [Line Number], Null())

Workflow:

Hope this helps : )

[patrick_digan · Accepted solution]

@hellyars You could also take advantage of the way alteryx converts strings to numbers. It would drop the letters at the end. A formula like this would return false for the records you're interested in

tostring(tonumber([Line Number]))=[Line Number]

[atcodedog05]

Happy to help : ) @hellyars 

Please vote and support our amazing Alteryx Community to win the Best User Group Program. Because we know it is ‌‌: )
https://community.alteryx.com/t5/General-Discussions/Lets-Vote-for-Our-Alteryx-community/td-p/836963 

Cheers and have a nice day!