Liveware Publishing Support Forum

Ok, I am pretty sure that I read somewhere that RR doesn^t use/understand HTML... that it uses it^s own syntax for bold commands, etc.____Here^s my dilemna...____I^m using RR to read a text field in a database and reproduce that memo field onto a report. However, if it sees this in the database:____==================================================__<b>AWESOME DEAL!</b> The best player in the world.__==================================================____RR understands the <B> as bold, strips the code and starts the text off in bold. However, it does NOT understand any other HTML commands and therefore leaves them in tact on my report. So I get the following, all in bold!:____==================================================__AWESOME DEAL!</b> The best player in the world.__==================================================____Can I run an HTML conversion before RR calculates my report results, or is there a way to build an expression into my field that strips all characters with the brackets (<>), including the brackets, and simply returns text?____Running RR for Windows, XBase ver. 9.0.005____Thanks!

Clarification:____The field I^m reading is a MEMO field, not a TEXT field.____Chris

Not a way around the problem I am afraid...____Kathleen__R&R Support

Hi:____Have a look at the STRREP() function.____Regards__John________Example:____To replace every occurrence of the text "LP" with "Liveware Publishing" in a character field named COMMENT, create a field with the following expression:___STRREP(COMMENT,"LP","Liveware Publishing")____© 2003 Liveware Publishing Inc. All rights reserved.

The problem is that STRREP() only works for character fields and not for memos. HOWEVER if you use the SQL version instead of the Xbase, the memo field would be treated as character and you could indeed use STRREP(). So maybe the SQL version would be the better choice for this one report.____Kathleen__R&R Support