Help

Regex to extract 1, 2 or 3 digit number after character

Solved
Jump to Solution
1462 2
cancel
Showing results for 
Search instead for 
Did you mean: 
JN_tp
6 - Interface Innovator
6 - Interface Innovator

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:

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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*$"
)

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

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*$"
)
JN_tp
6 - Interface Innovator
6 - Interface Innovator

Thanks so much @kuovonne