# Re: Formula to Extract a Certain Text

Solved
2574 2
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Good day team,

I would like to ask let's say for example I have these email addresses and I want to use a formula to get "ABC" to "ABC Company Philippines." What would be the correct formula?

For your reference, this is the formula that I am using right now.

IF(RIGHT({Email},LEN({Email})-FIND(".",{Email},FIND("@",{Email})))="abc", "abc company Philippines",IF(RIGHT({Email},LEN({Email})-FIND(".",{Email},FIND("@",{Email})))="bcd","bcd",IF(RIGHT({Email},LEN({Email})-FIND(".",{Email},FIND("@",{Email})))="cde",
"cde", RIGHT({Email},LEN({Email})-FIND(".",{Email},FIND("@",{Email}))))))

2 Solutions

Accepted Solutions

Hm okay, if so, try this:

``````IF(
FIND(
"ibex",
LOWER(Name)
),
"IBEX Global Philippines"
)``````

12 - Earth

Hi,

you need to extract part between @ and . , then substitute it with company name if it match name from list and show unchanged email for non-matches?

that should work:

``````SWITCH(LOWER(
MID(Email,1+FIND('@',Email),FIND('.',Email)-FIND('@',Email)-1)),
'ibex','IBEX Global Philippines',
'alorica','Alorica',
'infosys','Infosys',
Email)``````

5 Replies 5
18 - Pluto

Sorry, I don't really understand what we're trying to do.  Could you provide an example of what you'd like the data output to be?

For example, if your input text is `name@ibex.co`,  what would you want the output to be?

5 - Automation Enthusiast

The output should be if "ibex","IBEX Global Philippines"

Hm okay, if so, try this:

``````IF(
FIND(
"ibex",
LOWER(Name)
),
"IBEX Global Philippines"
)``````

12 - Earth

Hi,

you need to extract part between @ and . , then substitute it with company name if it match name from list and show unchanged email for non-matches?

that should work:

``````SWITCH(LOWER(
MID(Email,1+FIND('@',Email),FIND('.',Email)-FIND('@',Email)-1)),
'ibex','IBEX Global Philippines',
'alorica','Alorica',
'infosys','Infosys',
Email)``````

5 - Automation Enthusiast

Thank you for all the help! It worked!