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.
Solved! Go to Solution.
Hi @Mancunian,
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
I should have been more specific. My values are actually this
10201 Base Case |
5337 Case 2 - 12position |
Ns5337 Case 3 - Increase Size |
How do I get these to only remove the prefixes before Base and Case. So that I get the following.
Base Case |
Case 2 - 12position |
Case 3 - Increase Size |
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