I have a column with strings like below:
AN~Brand1_MK~HK
AN~Brand2_MK~US
I would like to extract the string between AN~ and _MK like below:
Brand1
Brand2
I tried using this regex: AN~(\w+)_
But when i ran it with the Regex Split node, it kept giving me this error:
WARN Regex Split 2:8 5218 input string(s) did not match the pattern or contained more groups than expected
I’m not sure what has gone wrong. Some help would be appreciated