topic Re: regular expressions!? in QlikView

regular expressions!?

ali_hijazi — Wed, 06 May 2015 11:58:02 GMT

Hello

got a field that contains HTML code for example ...text etc....

is there a way to remove all HTML tags and keep the rest of text to display it properly on a table box?

please advise

Re: regular expressions!?

robert_mika — Wed, 06 May 2015 12:00:55 GMT

Could that be any string length with any HTML code?

Re: regular expressions!?

petter — Wed, 06 May 2015 12:05:08 GMT

You can call a Macro function from the Load Script. The Macro function could be a JScript (Microsofts JavaScript that comes with your Windows OS). This has a Regular Expression component that could be invoked. If you have a regular expression that strips HTML you can use this approach to solve your problem....

Maybe just using PowerShell is the best, using the Execute statement in the Load Script ...

This is a one-liner with PowerShell:

$myStr -replace "<.*?>"

Re: regular expressions!?

ali_hijazi — Wed, 06 May 2015 12:18:03 GMT

mainly formatting tags like , new paragraph new line

Re: regular expressions!?

MarcoWedel — Wed, 06 May 2015 12:20:58 GMT

Hi,

if you are looking for regular expressions, maybe these links on using RegEx in QlikView might help:

regards

Marco

Re: regular expressions!?

robert_mika — Wed, 06 May 2015 13:01:07 GMT

This does not solve your problem but you can use 4-5 Repalce to get what you need:

=Replace(Replace(Replace('text ','',''),'',''),' ','')

Could you post some "real" examples to play with VBS?