I am hoping somebody can point me in the right direction. I think REGEX_EXTRACT and SUBSTITUTE are the right way to go here.
I have titles that all have the word “BPM” followed by a space towards the end. I want to extract everything to the right of "BPM " (and the space).
Examples of the titles I am working with:
DAM301_203 PULSE WITH SYNTH 80 BPM A FLAT
what I’d like to extract is “A FLAT”
DAM100_001 PULSE DEEP END 105 BPM F SHARP
what I’d like to extract is “F SHARP”
DAM201_400 PULSE TICKING CLOCK 125 BPM C
what I’d like to extract is “C”
So I am thinking I need to “substitute/extract” everything up to and including "BMP ", and I should end up with what I’d like to keep, regardless of length. Is my thinking correct? If yes, how would I do that? I have not managed to come up with a regular expression that captures what I"d like to capture.
Thank you so much in advance.