Repeated word from a field

[Anonymous]

Hi All,

I need help to find repeated word from a field , I am using word cloud extension object to highlight repeated word.

Example

Reason

Work shift

Training not provided

No proper Training provided

Dissatisfied with work

Dissatisfied with Team

Now the word Training and Dissatisfied is appearing twice. I have to highlight in word cloud.

Thanks in advance

[jmvilaplanap · Accepted solution]

Hi

You can use substringcount function made a loop for each subfield(string, ' ') then you can count the number of repetitions for each word.

Regards

[effinty2112]

HI Shan,

Maybe

Phrases:

Load

RecNo() as ID,

SubField(Phrase,' ') as Word;

LOAD * Inline [

Phrase

Reason

Work shift

Training not provided

No proper Training provided

Dissatisfied with work

Dissatisfied with Team

];

Result:

Word	count(Word)
Dissatisfied	2
provided	2
Training	2
with	2
No	1
not	1
proper	1
Reason	1
shift	1
Team	1
Work	1
work	1

Work appears twice, once as 'Work' and once as 'work'. In your script you could use Lower or Upper functions to correct for this.

cheers

Andrew

[Anonymous]

Hi Jose,

Thanks for the reply, can you please send sample script

[jmvilaplanap]

Hi

I used the sample of Andrew, is easier than my answer.

Regards