Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Formula to Extract a Certain Text

Solved
Jump to Solution
2790 0
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
12 - Earth
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)

 

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
12 - Earth
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)

 

Francoloco23
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you for all the help! It worked!