Number of expressions (text or number) per row

[ohb60]

Hello

I would like to count the number of expressions per row, whatever the method.

Could you help me please ? 

Example : 

row1 => the apple is green => number of expressions = 4

row2 = 1 chair in the office => number of expressions = 5

O.

[Anonymous · Accepted solution]

Hi,

You can try with this:

Number of Expressions= LEN(Table[Field])-LEN(SUBSTITUTE(Table[Field];" ";""))+1

[ohb60]

ks a lot Chiara it works perfectly !

[Anonymous]

As per my knowledge, there is no direct way to count string, easier is to write a stored procedure and read it from there.

BEGIN
FOR i IN 1..Length(str) LOOP
p := Substr(str, i, 1);
IF p = ' ' THEN
noofwords := noofwords + 1;
END IF;
END LOOP;