Is there any way to count a search item within a string? I’ve got a single line with values in it separated by semi-colons, and I’m trying to determine how many values are in the string. COUNTA() only works with multiple values, not with a single string value. In Filemaker I could do this with PATTERNCOUNT(), but it doesn’t seem there’s an equivalent in Airtable.
Counting commas and semi-colons
+2This topic has been closed for replies.
Assuming none of the items includes an embedded semi-colon, this should do it:
(LEN({String}) - LEN(SUBSTITUTE({String},";",""))) + 1
(Formula courtesy @Simon_Brown.)
+2Assuming none of the items includes an embedded semi-colon, this should do it:
(LEN({String}) - LEN(SUBSTITUTE({String},";",""))) + 1
(Formula courtesy @Simon_Brown.)
PERFECT. Thank you so much.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.