How do i extract all data to the right after a specific character

[Jdelagu11]

I'm trying to extract all the data from a field after the very last underscore "_" in the data (see below screenshot).

So the data highlighted in RED would be the extract. I tried using formulas but nothing seems to work. Can this be done in a formula?

... or does it need to be done in REGEX? If it needs to be done in regex, can someone help me with what the code would like?

Still a beginner with REGEX unfortunately.

2024_08_07_August RNR Green FB_A24FN170DAADAAD

2024_08_05_August RNR TS AM FB_A24FN206DAADAAD

2024_08_05_August RNR TS AM_B24FN206DAPDAARR

2024_08_05_August RNR TS AM_A24FN207DANOA

2024_08_05_August RNR TS AM_G24FN206

Thanks for any help!  Javier

[binuacs · Accepted solution]

@Jdelagu11 one way of doing this

[Jdelagu11]

That worked! Thanks so much for the quick resolution! I'm going to have to start studying what all those characters mean! :)