Adding Symbols around the last word in a string

[RokasC]

Hi all!

I have a fairly complicated challenge which has me stumped. I have a column which gives the names of many chemicals as well as the region focus all in the same string. However, I need to bracket the location word. The issue comes from the multitude of chemical names so I don't think splitting this out with text to columns and then formula will work. The region is always at the end with no spaces (Even in the case of "Asia-Pacific").

Example of desired result:

Ethyl Acetate Europe   > Ethyl Acetate (Europe)

Gas Europe  > Gas (Europe)

Poly Asia-Pacifici    >  Poly (Asia-Pacific)

Many thanks in advance!!

Rokas

[vizAlter · Accepted solution]

@RokasC   — Hope attached the solution will be helpful, if not let me know.

1st you need a RegEx tool and use "Parse" Output Method:

(.*)(\s.+$)

Then

[RokasC]

Worked Perfectly! Thank you so much

[Amarendra]

@RokasC You can do this using a the following formula

 '(' + ReverseString(GetWord(ReverseString([Chemical]),0)) + ')'