topic Re: Splitting a paragraph into a record per word in QlikView

Splitting a paragraph into a record per word

DavidFoster1 — Thu, 10 Jul 2014 09:47:27 GMT

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.

Re: Splitting a paragraph into a record per word

alexandros17 — Thu, 10 Jul 2014 10:22:17 GMT

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

Re: Splitting a paragraph into a record per word

DavidFoster1 — Thu, 10 Jul 2014 11:12:54 GMT

Example?

Re: Splitting a paragraph into a record per word

alexandros17 — Thu, 10 Jul 2014 11:25:32 GMT

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

let me know

Re: Splitting a paragraph into a record per word

DavidFoster1 — Thu, 10 Jul 2014 11:51:43 GMT

Brilliant thanks