Searching and counting substrings within a text field
JMP Add-in did a great job importing hundreds of MSWord documents into a table. I have a column called "comment (original)" that I wish to count the number of "no comment" phrases. When I use the formula,N Rows(
Loc(
Words( :"comment (white space collapsed)"n, " " ),
"comments"
)
)it returns the number of occurrences for the term "comments". However, the Loc function will not accept "no comments" as ...