Being no formula expert, I am assuming that the new REGEX_EXTRACT formula function would be a good way to achieve the following.

I want to extract three digits from a name field. These three digits are always in the same place after an underscore.

Name Field: DAM301_010 POWERHOUSE

Extraction Formula Field: 010

Name Field: DAM204_115 DROP THE BALL

Extraction Formula Field: 115

I apologize if this seems extremely simple and obvious to the pros, but for a formula layman, it’s anything but.

Thank you so much in advance.