How to count the number of word enter into a TextArea in ApEx 4.2

Question

While ApEx has an inbuilt character counter, I want to show the number of words entered as the user enters text into a textarea.

How would I go about achieving this?

Possible duplicate of [Counting and limiting words in a textarea](https://stackoverflow.com/questions/17909646/counting-and-limiting-words-in-a-textarea) — Rene, Jun 16 '17 at 05:55

score 0 · Answer 1 · answered Jun 21 '17 at 22:10

Easiest way is to calculate the string length minus the string length after removing (single) whitespaces and then adding one. For example,

(length(text) - length(text, ' ',''))+1

This may not work if your text has multiple white space. You may wanna replace multiple whitespace with a single one, before doing this.

score 0 · Answer 2 · answered Jan 18 '18 at 16:34

0

You can count number of white spaces and then add one to it. That would be a simple word counter. Regexp_count comes handy in this: https://docs.oracle.com/cd/B28359_01/server.111/b28286/functions135.htm#SQLRF20014

SELECT REGEXP_COUNT('This is my life.', ' ', 1, 'i')+1 word_count FROM DUAL;

answered Jan 18 '18 at 16:34

Sejal Parikh

use regular expressions to count multiple whitespaces. – Sejal Parikh Jan 18 '18 at 16:45

2 Answers2