How to count the number of words /alphabet in a sentence

[Anonymous]

Hi,

Can we count the number of words /alphabet used in the comments for different ID .

For example :-

For ID =1 its comments include 23 alphabets.

Thanks your suggestions in advance

ID	Comments
1	Every company has expenses.
2	This Expense Management application provides you with a way to discover unexpected expenses and track employee spending.  With the power of data association, QlikView helps you identify ways to save money for your organization.
3	Every sales or services company has traveling costs.  But most expense tools don't give you the insight information about how the expenses were spent.

[qv_testing · Accepted solution]

Hi,

Len(Your Dimension )

[Kushal_Chawda]

=len(keepchar(lower(trim(Comments)),'abcdefghijklmnopqrstuvwxyz')) as NumberOf Alphabets

[prat1507]

Maybe this

=Len(replace([Business Unit],' ',''))

[arvind_patil]

Hi Shweta,

Use Below Code

Load ID,

Comments,

Len(Comments) as COM_LEN

From....

Thanks,

Arvind Patil

[techvarun]

Try this for Alphabet count

Len(Comments) -substringcount( Comments ,' ')

Word count is typically number of spaces+1

substringcount( Comments ,' ') +1

[#7]

LOAD

  *

  // Count what is left here...

  ,Len(CommentsCleaned)-Len(PurgeChar(CommentsCleaned, ' ')) as NumberOfWords

  ,Len(PurgeChar(CommentsCleaned, ' ')) as NumberOfCharacters

;

LOAD

  *

  // Remove things you don't want to count here...

  ,Replace(Comments, '.','') as CommentsCleaned

;

LOAD * INLINE [

    ID, Comments

    1, Every company has expenses.

    2, "This Expense Management application provides you with a way to discover unexpected expenses and track employee spending.  With the power of data association, QlikView helps you identify ways to save money for your organization."

    3, "Every sales or services company has traveling costs.  But most expense tools don't give you the insight information about how the expenses were spent."

];

[Frank_Hartmann]

Straight Table:

Dimension = ID, Commnets

Expression:

count(subfield(Comments,' '))