Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

SEARCH formula not finding a character

Topic Labels: Formulas
Solved
Jump to Solution
507 4
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m searching for the occurrence of a specific character in a text field with SEARCH but it doesn’t return any answer, can you help?

Screen Shot 2020-06-11 at 9.01.41 AM

1 Solution

Accepted Solutions

Hi @Jorge_Guerra_Martine,

Welcome to Airtable Community ! :slightly_smiling_face:

You should put the String To Find before the Where To Search, so it should be

SEARCH("r", AppUnNomre, 0) (although the 0 is default and you do not need to put it if you want to start from the beginning)

BR,
Mo

See Solution in Thread

4 Replies 4

Hi @Jorge_Guerra_Martine,

Welcome to Airtable Community ! :slightly_smiling_face:

You should put the String To Find before the Where To Search, so it should be

SEARCH("r", AppUnNomre, 0) (although the 0 is default and you do not need to put it if you want to start from the beginning)

BR,
Mo

Thanks you … That was sure a DUMB mistake on my part

… And that is why I shouldn’t post questions before my first coffee. THANKS!

Welcome , anytime :slightly_smiling_face: It is sometimes confusing