Replace text before a string

[Mancunian]

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.

[Jonathan-Sherman]

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

[Mancunian]

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

[Jonathan-Sherman · Accepted solution]

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