I'm testing the formula in the screenshot below but I cannot understand why this isn't working. Every RegEx tester online suggests that this string should work. I'm expecting this formula to return 12. Any help on this is really appreciated!
=REGEX.EXTRACT(C3,"/(/d+)-(/d+)/g",1,1)
I am no expert on regular expressions but to get just the digits before the dash, a simple =REGEX.EXTRACT(C3,"\d+") should do the trick unless you only want it to return a result if the string is of the form you showed, digits a dash then more digits.
Other than that, it appears you used forward slashes, not the required backward slashes for your regular expression and the \g at the end (after correcting with a backward slash) fails for me.
I am no expert on regular expressions but to get just the digits before the dash, a simple =REGEX.EXTRACT(C3,"\d+") should do the trick unless you only want it to return a result if the string is of the form you showed, digits a dash then more digits.
Other than that, it appears you used forward slashes, not the required backward slashes for your regular expression and the \g at the end (after correcting with a backward slash) fails for me.
You've got / but you need \.
If you're trying to extract the digits before the - you can do one of the first two of these:
Without the two optional parameters you can just use \d+
SG
That’s brilliant! Thank you :)
Error with REGEX.EXTRACT
