Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

SEARCH formula not finding a character

Topic Labels: Formulas
Solved
Jump to Solution
552 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