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.