Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

SEARCH formula not finding a character

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