- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 30, 2022 10:35 AM
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 :slightly_smiling_face:
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 30, 2022 10:57 AM
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*$"
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 30, 2022 10:57 AM
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*$"
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 30, 2022 02:30 PM
Thanks so much @kuovonne
