Formatting Formula

I am modifuying a report which was created by someone else,I 'm not sure what this formula is doing :

dim strInput
strInput = {Header.INSTRUCTIONS}
formula = replace(replace(replace(strinput, "<br>", chr(10) & chr(13)), "<b><u>",""), "</u></b>", " :") & chr(10) & chr(13) & " "

would someone guide whats going on as have not enough time for research !

Thanks.Hi, I replied to your post in the CR web site.
Modified formula slightly, to test, this is in basic syntax

dim strInput
strInput = "TEXT1<br>TEXT2<b><u>TEXT3</u></b>TEXT4"

formula = replace(replace(replace(strinput, "<br>", chr(10) & chr(13)),"<b><u>",""), "</u></b>", " :") & chr(10) & chr(13) & " "

chr(10) is a 'line feed' and chr(13) is a 'carriage return'

Output from my test looks like this.

TEXT1

TEXT2TEXT3 :TEXT4

So when the formula sees <br> it adds a 'line feed' and a 'carriage return'

when it sees <b><u> it does not add anything, when it sees

"</u></b>", " :") if should add the :|||thank you very much for clear and detail reply!It helps.|||If you only want to show the HTML or RTF text then you can use the Text Interpretation (RTF Text / HTML Text) This will show the text as it is shown in the html or rtf document you don't need to create custom functions.

Creat a formula containg the text or put the database field on the report. Right click -> Format Field -> Paragraph Tab -> Text Interpretation.