Return the position of the last alphanumeric character in a string

[ARHWAN0]

Hi,

Trying to come up with a formula that will return the position of the last alphanumeric character in a string.  Some examples:

ABCD,(*&&%&        would return 4
12346?>_                   would return 5
XXXXXXX                  would return 7
)&*()&%                       would return -1 (no alphanumeric exists)

Any help would be greatly appreciated!

[binu_acs · Accepted solution]

@ARHWAN0 one way of doing this

IIF(Length(REGEX_Replace([Data], '[^A-z0-9]', '')) <=0,-1,Length(REGEX_Replace([Data], '[^A-z0-9]', '')))

[ARHWAN0 · Accepted solution]

@binu_acs  Perfect, that was exactly what I was looking for; thanks!