Skip to main content

Hello, I’m trying to extract the final number at the end of a string like this:


Josh-B7-3

Ben-B8-28

Chris-BN-294


I want to extract just:

3

28

294


Any ideas? Appreciate your time 🙂

Try this. It features the $ control character for matching the end of a string that I recently talked about in the BuildOnAir podcast.


REGEX_EXTRACT(

    {field name},

    "\d*$"

)

Thanks so much @kuovonne

Reply


Terms & Conditions