I have values in a column that read NS50367 Base and 56789 Case 2.
How do I get the values to only be Base and Case? The numbers and later before base and case will always change. Base and Case will always remain the same.
I see! In that case you could use REGEX_Replace([Value], '.*?((?:Base|Case).*)', '$1')
If this solves your issue please mark the answer as correct, if not let me know!
Regards,
Jonathan
Hi @Mancunian,
You could use: REGEX_Replace([Value], '.*(Base|Case).*', '$1')
I should have been more specific. My values are actually this
How do I get these to only remove the prefixes before Base and Case. So that I get the following.
