Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

felcar2013
Contributor II

how to clean a list of words

Hi

I want to clean a list of words, which is over 1 million long.

The base data was ratings given in form of sentences. I broke this down into words, with subfield(), but i get words with "commas" or "question marks" or other signs. As separator i used ' ' (empty). I need just the words, because i need to count the frequency.

Example

Word

bad

bad,

bad//

-bad

....bad

is considered as 3 different words, but it is only one. How can i eliminate all these signs around the words?

thanks

felipe

1 Solution

Accepted Solutions
MVP
MVP

Re: how to clean a list of words

Use KeepChar() or PurgeChar(). Like

Load

          KeepChar(Word, 'abcdefghijklmnopqrstuvwxyz') as FreshWord

2 Replies
MVP
MVP

Re: how to clean a list of words

Use KeepChar() or PurgeChar(). Like

Load

          KeepChar(Word, 'abcdefghijklmnopqrstuvwxyz') as FreshWord

felcar2013
Contributor II

Re: how to clean a list of words

thanks!

Community Browser