Help

Re: SEARCH formula not finding a character

Solved
Jump to Solution
1255 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jorge_Guerra_Ma
5 - Automation Enthusiast
5 - Automation Enthusiast

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
Mohamed_Swella1
13 - Mars
13 - Mars

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
Mohamed_Swella1
13 - Mars
13 - Mars

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

Jorge_Guerra_Ma
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Welcome , anytime :slightly_smiling_face: It is sometimes confusing