topic Re: Cleaning up a data string with < > delimeters in QlikView

Cleaning up a data string with < > delimeters

Sat, 24 May 2014 12:35:58 GMT

Hi,

I'm trying to clean up data I'm getting from a forum db. The problem I'm having is that the body of the conversations include formatting tags. So in order to just leave the text parts I need to remove the tags. Fortunately all of the markup used is contained within < and >. How do I go about saying:

Clean(Field, Delete text from '<' to '>')

Is this possible?

E.g. the follow is what I currently have:

"anyone who has access to this forum should be on this list Project Leader: Legacy Lead Artist: "

and I want to just reduce it to "anyone who has access to this forum should be on this list Project leader: Lead Artist:"

UNLESS - there is a way to get Qlikview to actually use these tags and format these messages properly!

Thanks!

Re: Cleaning up a data string with < > delimeters

nagaiank — Sat, 24 May 2014 12:52:23 GMT

The following expression does what you want to do for the sample string:

Replace(' Project Leader: Legacy Lead Artist: ',' ','')

For other tags, you may try a combination of TextBetween() and Replace() functions.

Re: Cleaning up a data string with < > delimeters

rwunderlich — Sun, 25 May 2014 02:37:23 GMT

You may want to display the text in Stefan Walther's HTML2 extension.

QlikTip #39: Displaying Html content within QlikView (Minimalistic HtmlTextBox Object Extension)

If you don't want to use an extension, you can translate the tags as NagaianK suggested, but I would use MapSubstring for flexibility;

TagMap:

MAPPING

LOAD from, Evaluate(to) INLINE [

from, to

, chr(10)

, chr(10)

]

;

Raw:

LOAD MapSubString('TagMap',Raw) as TranslatedText