Adding Symbols around the last word in a string

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

Custom Tools

Parse

Dynamic Processing

Expression

Accepted answers

@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

Keep in ( ).yxmd

All comments

@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

Keep in ( ).yxmd

Worked Perfectly! Thank you so much

@RokasC You can do this using a the following formula

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703