Replace Character with a hard return

[mdtimo]

I have data in a table that allows for hard returns but represents them with a "`" sign. I can't seem to do a replace so that every "`" is turned into a hard return.

Any ideas on how to do this?

 

[Madawc]

If you want to print text on a new line, CHR(13) within the text string will do this. Is this what you're after?

Madawc Williams
East Anglia, Great Britain

 

[bdreed35]

If you mean line break when you say hard return then create a formula with this in it:

Replace ({table.field}, "`", chr(13))

~Brian

 

[mdtimo]

My data looks something like this
Patent Application No: 09/342,233`Light Creating Diode`Inventor name: Joe Smith' Application Date : January 2003` Reference No. : 205802

I want to display the same data but with a hard return wehre there is a "`"

I used the formula and only the first line of data displayed.

 

[Madawc]

Does your display field have 'Can Grow' set? Right-click and format field to check.

Madawc Williams
East Anglia, Great Britain