Skip to main content

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}))))))

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?

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"

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"
)

Link to base

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)

 

Thank you for all the help! It worked!

Reply


Terms & Conditions