This expression counts how many times each unique word appears in a sentence.

Suppose:

ri!s = "Hello hello test hello world test"

Step 1 — Convert to lowercase, remove commas, and split

local!words: split(

substitute(lower(ri!s), ",", ""),

" "

)

How it works

lower() converts everything to lowercase.
substitute() removes commas.
split() breaks the sentence into individual words.

Output:

{"hello", "hello", "test", "hello", "world", "test"}

Step 2 — Get unique words

local!uniqueWords: union(local!words, local!words)

How it works

union() removes duplicate values.

Output:

{"hello", "test", "world"}

Step 3 — Count occurrences of each word

a!forEach(

items: local!uniqueWords,

expression: fv!item & " - " &

count(wherecontains(fv!item, local!words))

)

How it works

Loop through each unique word.

For every word:

wherecontains(fv!item, local!words)

returns the positions where that word appears.

Example:

The expression formats each result as:

word - count

Final Output

{

"hello - 3",

"test - 2",

"world - 1"

}

Flow Summary

Sentence

│

▼

lower()

│

▼

substitute(",", "")

│

▼

split()

│

▼

{"hello","hello","test","hello","world","test"}

│

▼

union()

│

▼

{"hello","test","world"}

│

▼

forEach

│

▼

wherecontains() + count()

│

▼

{

"hello - 3",

"test - 2",

"world - 1"

}