regular expressions!?

[ali_hijazi]

Hello

got a field that contains HTML code for example ...<p>text</p> <br> 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

[robert_mika]

Could that be any  string length with any HTML code?

[petter]

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 "<.*?>"

[ali_hijazi]

mainly formatting tags like <b>, new paragraph <p> new line <br>

[MarcoWedel]

Hi,

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

• http://www.qlikfix.com/2010/10/18/regular-expressions-in-the-load-script/  by Barry Harmsen
• How to use regular expressions by Andrea Ghirardello

regards

Marco

[robert_mika]

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

=Replace(Replace(Replace('<p>text</p> <br>','<p>',''),'</p>',''),'<br>','')

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