Formula

Dear all,

I have a cell which contains a string type a sentence I want to have only the word which is inside two bracket for example I have in the cell Feras is eating an (orange) and watching TV I want the output of the cell is to get rid out of all the words except the word inside the bracket which is Orang.

Any help in that please?

Workflow

Output

Udacity

Accepted answers

Kenda

Hi @Feras95p

In this case, I think RegEx would be helpful. Using a formula tool, try the following expression:

REGEX_Replace([Field1], ".*\((.*)\).*", "$1")

Basically, this takes your field and says find the parenthesis and only keep what is within those and get rid of everything else.

Hope this helps!

pedrodrfaria

Hi @Feras95p

You can use the Regex again and extract that info:

If you want to still use the Formula Tool, you can do something like this:

Also, additionally, the recommendation is that you always open a new post if you have a different question. You can still ask here and mark more than one reply as the correct answer. But as a tip, open a new one to make sure you other question will always be answered.

Pedro.

New Workflow11.yxmd

All comments

pedrodrfaria

Hi @Feras95p

You can do it using Regex or maybe a findstring and substring functions inside of the formula tool. I attached an example extracting the information inside of the parenthesis using regex.

Pedro.

New Workflow11.yxmd

Kenda

Hi @Feras95p

In this case, I think RegEx would be helpful. Using a formula tool, try the following expression:

REGEX_Replace([Field1], ".*\((.*)\).*", "$1")

Basically, this takes your field and says find the parenthesis and only keep what is within those and get rid of everything else.

Hope this helps!

rkapoor

@Feras95p I used regex to do this in the attached sample workflow for you.

feras.yxmd

morr-co

Hi @Feras95p - the regex tool will get you there. Attached is an example.

regex.yxmd

Feras95p

Thanks @Kenda , it works well!

One more question please I have an other cell which contains the address information like this

address:Work,neigborhood:Joe ,street:Oxford ,company:Feras ,floor: five

I want to have only the output the company name which is in this case Feras any idea how it can be done?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703