Solved

SEARCH formula not finding a character

+4

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?

Best answer by Mohamed_Swella1

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

+17

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

+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

+4

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

+17

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

Welcome , anytime :slightly_smiling_face: It is sometimes confusing

Sign up