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

Formula for specific character count in string

Topic Labels: Formulas
Solved
Jump to Solution
2630 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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

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: