Help

Re: Formula for specific character count in string

Solved
Jump to Solution
2521 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Burner
7 - App Architect
7 - App Architect

Hi. I’m new to Airtable and trying to find a formula that will count the number of spaces in a string. For example, when this formula is applied to the string “How are you doing?”, I want the formula to return 3. I tried using the FIND function, but all that does is to find the position of the first instance of, say, a space in this example. I’m looking for a formula to count the number of spaces.

Thank you.

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

Compare the length of the original string with the length of a string that’s had all the spaces removed using the SUBSTITUTE() function:

LEN({String Field}) - LEN(SUBSTITUTE({String Field}, " ", ""))

See Solution in Thread

3 Replies 3
nnnnneil
8 - Airtable Astronomer
8 - Airtable Astronomer

Hey @Burner,
Check out @W_Vann_Hall’s code at Count multiple keywords in text
Cheers,
Neil

Justin_Barrett
18 - Pluto
18 - Pluto

Compare the length of the original string with the length of a string that’s had all the spaces removed using the SUBSTITUTE() function:

LEN({String Field}) - LEN(SUBSTITUTE({String Field}, " ", ""))

Excellent! Just what I needed. Thank you, Justin. :thumbs_up: