Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula to Extract a Certain Text

Topic Labels: Formulas
Solved
Jump to Solution
3731 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Francoloco23
5 - Automation Enthusiast
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"
)

Screenshot 2023-02-09 at 1.58.00 PM.png

Link to base

See Solution in Thread

Alexey_Gusev
13 - Mars
13 - Mars

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)

 

See Solution in Thread

5 Replies 5
TheTimeSavingCo
18 - Pluto
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?

Hi Adam,

 

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

Hm okay, if so, try this:

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

Screenshot 2023-02-09 at 1.58.00 PM.png

Link to base

Alexey_Gusev
13 - Mars
13 - Mars

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)

 

Francoloco23
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you for all the help! It worked!