Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 08, 2023 08:40 PM - edited Jul 08, 2024 06:11 PM
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}))))))
Solved! Go to Solution.
Feb 08, 2023 09:58 PM
Hm okay, if so, try this:
IF(
FIND(
"ibex",
LOWER(Name)
),
"IBEX Global Philippines"
)
Feb 09, 2023 03:04 AM
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)
Feb 08, 2023 09:04 PM - edited Feb 08, 2023 09:05 PM
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?
Feb 08, 2023 09:07 PM
Hi Adam,
The output should be if "ibex","IBEX Global Philippines"
Feb 08, 2023 09:58 PM
Hm okay, if so, try this:
IF(
FIND(
"ibex",
LOWER(Name)
),
"IBEX Global Philippines"
)
Feb 09, 2023 03:04 AM
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)
Feb 12, 2023 04:29 PM
Thank you for all the help! It worked!