To count how many times a letter appears in a string of text, both lowercase and capital case, you could replace all instances of the letter with “nothing” and find the difference in length of the modified text string and the original. That would look like:
(LEN({Field Name}) - LEN(SUBSTITUTE(LOWER({Field Name}), "a", ""))) & " (a)"
^ you could have a single formula field that covers all letters by following this pattern:
TRIM(
(LEN({Field Name}) - LEN(SUBSTITUTE(LOWER({Field Name}), "a", ""))) & " (a) " &
(LEN({Field Name}) - LEN(SUBSTITUTE(LOWER({Field Name}), "b", ""))) & " (b) " &
(LEN({Field Name}) - LEN(SUBSTITUTE(LOWER({Field Name}), "c", ""))) & " (c) " &
...
)
Wrapping everything in TRIM() removes extra spaces at the front/end of the result. If you don’t want to list letters that don’t appear, you can replace all "0 (x) " by doing
REGEX_REPLACE(
rformula above],
"0\\s\\("0:alpha:]]\\)\\s",
""
)
``
To count how many times a letter appears in a string of text, both lowercase and capital case, you could replace all instances of the letter with “nothing” and find the difference in length of the modified text string and the original. That would look like:
(LEN({Field Name}) - LEN(SUBSTITUTE(LOWER({Field Name}), "a", ""))) & " (a)"
^ you could have a single formula field that covers all letters by following this pattern:
TRIM(
(LEN({Field Name}) - LEN(SUBSTITUTE(LOWER({Field Name}), "a", ""))) & " (a) " &
(LEN({Field Name}) - LEN(SUBSTITUTE(LOWER({Field Name}), "b", ""))) & " (b) " &
(LEN({Field Name}) - LEN(SUBSTITUTE(LOWER({Field Name}), "c", ""))) & " (c) " &
...
)
Wrapping everything in TRIM() removes extra spaces at the front/end of the result. If you don’t want to list letters that don’t appear, you can replace all "0 (x) " by doing
REGEX_REPLACE(
rformula above],
"0\\s\\("0:alpha:]]\\)\\s",
""
)
``
Thank you for your response!
One more question -
Is there a way to filter out words that have less than 3 vowels?
I know I could manually make filters and new views…but that would be a ton of views and they’d be separated.
Essentially I’d want all 3+ vowel words in 1 view.