Regex replace everything after matching word - can you help please

Question

Hi folks

I think Regex replace is the right thing to do but not quite sure how to achieve it...basically if there is a matching SPA on its own and not part of another work like SPAIN then I would want everything removed after we find that word

So

KPMG SPA REVISIONE E ORGANIZZAZIONE CONTABILE

Would become

KPMG SPA

Could someone help please?

Thanks

Cass

atcodedog05 · Accepted Answer

Hi @ck2024

Your hunch is right. Here is the regex you can use

REGEX_Replace([Input], "SPA\s.*", "SPA")

Basically, if there is SPA followed by space and any characters replace it with SPA.

Workflow:

Hope this helps 🙂