how to read <br> and display a new line in crystal report labels

hi guys,

i have here a crystal report label (actually its a formula field).
this formula field can display long strings.
the strings are located in a notepad.

so when the text file consists of this line:
     blah blah blah blah blah <br> blah blah
     blah blah <br> blah blah blah blah

it prints the whole string including the <br> signs.

i want the <br> to act as a new line or a carriage return and i want the crystal report label to look like this:
     blah blah blah blah blah
     blah blah blah blah
     blah blah blah blah

please help....

thanks
batang_igatAsked:
Who is Participating?
 
frodomanConnect With a Mentor Commented:
You need to use a formula instead:

replace({inputtext},'<br>',chr(10)+chr(13))

This will display the same text but will replace all <br> instances with the c/r line/feed characters.

HTH

frodoman
0
 
bdreed35Commented:
You can actually do this without creating another formula.

Right click the field on the report, and choose Format Field.
Under the Paragraph tab, look for the drop down list at the bottom called Text Interpretation.
In the dropdown list, choose "HTML Text".
This will allow you to use certain valid HTML tags to format your text.
0
 
batang_igatAuthor Commented:
thank you both for your quick responses.

i really appreciate your help.
i used the frodoman's formula for my codes but i think bdreed35's suggestion is also correct.

thanks
0
 
frodomanCommented:
Thanks for the points.  For the record, bdreed's suggestion is also correct.

frodoman
0
All Courses

From novice to tech pro — start learning today.