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.
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!