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

@ARHWAN0 one way of doing this

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