Word count

[cb2loac]

Hi,

I have a table like this

Client     Text

1            I like the product a lot

2            The product is expensive

...           ....

Now, I want to count the number of words for each row. So, I want to produce a new column like that:

Client     Text                                          Wordcount

1            I like the product a lot               6

2            The product is expensive         4

...           ....

Any idea how to do this?

Thanks a lot,

Best,

cb2loac

[dataMack · Accepted solution]

In a formula tool use the CountWords(String) function.  It would look like CountWords([Text]) and you tell it to make that a numeric column called Wordcount

[cb2loac · Accepted solution]

Nice! It works!

Thx!

[anthonyw]

Thanks