Skip to main content
Solved

Formula to Extract a Certain Text

  • February 9, 2023
  • 5 replies
  • 31 views
F
Forum|alt.badge.img+6

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

Best answer by TheTimeSavingCo

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

1 Attachments
ChrisShernaman

5 replies

TheTimeSavingCo
Forum|alt.badge.img+31

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?

Adam, Airtable Consultant - thetimesaving.company
F
Forum|alt.badge.img+6
  • Francoloco23
  • Author
  • Known Participant
  • February 9, 2023

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"

TheTimeSavingCo
Forum|alt.badge.img+31

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

Adam, Airtable Consultant - thetimesaving.company
ChrisShernaman
Alexey_Gusev
Forum|alt.badge.img+25

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)

 

ChrisShernaman
F
Forum|alt.badge.img+6
  • Francoloco23
  • Author
  • Known Participant
  • February 13, 2023

Thank you for all the help! It worked!

Terms & ConditionsAccessibility statement