topic Re: HOW to count the word as there is a column about sentence in Discussions

HOW to count the word as there is a column about sentence

Rongyu_Kuang — Sat, 10 Jun 2023 23:59:18 GMT

hi,

I have a question about how to count the word in a column about sentences.

for example, if a participant writes "I like chocolate bars" , it would be counted as 4 words. if the sample size is 100, how can I count words in this column by each participant?

best wishes,

Rongyu

Re: HOW to count the word as there is a column about sentence

txnelson — Tue, 21 Mar 2023 15:34:15 GMT

It is a simple task. Just count the number of elements that are created using the Words() function.

Names Default To Here( 1 );
string = "I like chocolate bars";
Show( Length( Words( string ) ) );

Re: HOW to count the word as there is a column about sentence

StarfruitBob — Tue, 21 Mar 2023 16:04:14 GMT

Building on what txnelson mentioned, if you have a column with strings, column: Strings, then consider something like this

Create new column: Num of Words
Set formula to
```
Length( Words( :Strings ) )
```

This will fill in the Num of Words column with the number of words found in the Strings column. The data type will initially be character, but you can modify the data type and modeling to your needs.

Re: HOW to count the word as there is a column about sentence

Rongyu_Kuang — Wed, 22 Mar 2023 12:57:40 GMT

many thanks indeed!!

may I ask another question, if I need to count the number of sentences in a string, what should I do?

thanks again.

Re: HOW to count the word as there is a column about sentence

txnelson — Wed, 22 Mar 2023 13:06:38 GMT

All of the JMP functions are defined in the Scripting Index. The description of the Words() function shows that it allows for a second element which defines what delimiter(s) are to be used in the specification of what is a "Word".

The default delimiter is a blank. If you change the delimiter element to specify both a period and a question mark, I believe what you will get is a separate entry in the output list, for each sentence.

Re: HOW to count the word as there is a column about sentence

pmroz — Wed, 22 Mar 2023 13:21:53 GMT

To parse out sentences you could use punctuation marks as delimiters to the words function.

sentences = "The quick brown fox jumped over the lazy dog.  Hello World!  Where's Waldo?";

slist = words(sentences, ".!?");
print(slist);

nsentences = nitems(slist);
print(nsentences);

Output from the log window:

{"The quick brown fox jumped over the lazy dog", "  Hello World", "  Where's Waldo"}
3

Re: HOW to count the word as there is a column about sentence

jthi — Wed, 22 Mar 2023 13:40:38 GMT

Other option could be to replace punctuation marks with "" and then check for string lengths

Names Default To Here(1);

sentences = "The quick brown fox jumped over the lazy dog.  Hello World!  Where's Waldo?";
sentences_new = Substitute(sentences, {".", "!", "?"}, ""); // or regex with GLOBALREPLACE
show(sentences_new);
nsentences = Length(sentences) - Length(sentences_new);
show(nsentences);