Formula

[Feras95p]

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?

[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.

[Kenda · Accepted solution]

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.

[morr-co]

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

[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?

[pedrodrfaria · Accepted solution]

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.

[Feras95p]

@pedrodrfaria Thank you ! it works great! 

Could you please have a look here 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Cross-tab/m-p/686119#M162199