Find Records That End w/ a Letter

Question

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 NumberFind1 1a1a2 43 43a43a43b43b100 101 128 128X128X129

atcodedog05 · Accepted Answer

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 Answer

@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]