Help parsing characters at the end of a string

[AllieRuiz]

Hi all, I have an incredibly large set of data that has numbers and letters joined in one cell in many columns, example below. I have tried all of the common regex expressions I have seen on google to no avail. Maybe because its stored as a string?

Any help would be much appreciated.

Fee

.000012BNB

92170.2500000000PEPE

9.6233000000ARPA

6.7000000000NKN

[alexnajm]

What is your end goal?

[jrgo · Accepted solution]

Hi @AllieRuiz 

Is the below what you're trying to achieve? If so, here's the REGEX i used. Note that the Case Sensitive option is unchecked. This should also work if using Desktop Designer if mistakenly posted in the Cloud board.

.+?([a-z]+)$

[AllieRuiz]

Yes, thank you so much!