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