count of keywords?

[#1]

hi,

i need to know how to script a expression to count the number of times a word appears in a column?

could you please assist?

=Count(if(Comments,'*BlackBerry*'))

[alexandros17]

Try:

Sum(if(Comments = '*BlackBerry*', 1 , 0))

let me know

[rubenmarin]

Hi Marvin, for a sample data like:

LOAD * Inline [

words

BlackBerry

aid BlackBerry

BlackBerry 2

other words

];

You can use an expression like:

=Sum(Aggr(If(Index(words, 'BlackBerry'), 1, 0), words))

[alexandros17]

This is better:

Sum(if(WildMatch(Comments, '*BlackBerry*')>0, 1 , 0))

[#5]

hi ,

Thanks Alessandro it works ...... awesome stuff....

[#6]

thanks i will do this for the inline .... awesome stuff