Remove HTML-code

Published by Henk on

Removing/finding HTML-code using regular expressions:

SELECT regexp_replace(name, ‘<.*?>’)  name_without_tags FROM table WHERE regexp_like(name, ‘<.*?>’)

 

 

Categories: Apex

Related Posts

Apex javascript

Background color row in interactive Report

Change the background color of a row in an interactive report based on a column  value I have the following columns ID (link) and GEKOPPELD and some other columns The column GEKOPPELD contains a X Read more…

Apex javascript

Call apex page from javascript , referer

I wanted to check whether apex is called from a browser session by entering an url or from an internet application. The command I wanted to use is: owa_util.get_cgi_env(‘HTTP_REFERER’); This command returns the (parent) url. Read more…

Apex

Dynamically change theme-style

I wanted to change dynamically the style of the theme of my application so you could easily see if you are running the application in development, test, acceptance or production. One solution is of course Read more…