Splitting a paragraph into a record per word

[DavidFoster1]

challenge for the gurus. Is it possible to take a paragraph of normal narrative text and split it down into individual words with each word as a separate record. I think I need to identify each word as a field and then pivot the fields, but not sure who to do this in QlikView.

This will be used to populate a word cloud.

This is early steps into analyzing unstructured data held in text,but searching the community for unstructured data pulls out a load of posts from people who do not understand all the flavours of structured data you can get these days (and bygone days).

Any thoughts appreciated.

[alexandros17 · Accepted solution]

Even if there is the need of a parser I send you this example, let me know

[DavidFoster1]

Example?

[alexandros17]

Open the original discussion, you will find 2 files attached in my reply ...

let me know

[DavidFoster1]

Brilliant thanks