Wilcard Formula

[mdewhurst]

I am trying to write a formula in Crystal Version 9.

What i am trying to do is say if the text in a "Memo" field is between some text for example.

Hello <b>Mr Smith</b>, goodbye.

This text is typed in SQL and when its prints in Crystal i want it to look like this

Hello (in bold or underline etc) MR Smith, goodbye

So all text in between a the <b> and </b> will have its formatting options changed.

Any help would be great, Regards Mike Mdewhurst@elucid.co.uk

 

[kenhamady]

I would write formulas using the INSTR() function to locate where the characters should go. Then I would write a separate formula that parses the memo and puts the characters into the appropriate places. Then format this formula to use HTML or RTF interpretation. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com