Hi there

I've got some text in a mediumtext field in my database and I'd like to display it on the page with the carriage returns/new lines intact.

At present when I show the text on the page it's all in a single line.

Is there a text formatting option that I can use similar to PHP's nl2br() that will show the new lines in the text and <BR> tags on the web page?

thanks in advance
Bruce

Hi Bruce

Try using a dmx-html attribute:
www.dmxzone.com/go/32764/dmxzone-app-connect-manual/32934/display-html-formatted-content-on-your-page

Tom

Thanks Tom

Do I need to buy App Connect Medium Editor for this to work?
If so, is there an alternative? Is there a simple command that works just like nl2br() ?

Bruce

I've found a script that's supposed to work:

<script type="text/javascript">
function nl2br (str, is_xhtml) {
var breakTag = (is_xhtml || typeof is_xhtml === 'undefined') ? '<br />' : '<br>';
return (str + '').replace(/([^>\r\n]?)(\r\n|\n\r|\r|\n)/g, '$1'+ breakTag +'$2');
}
</script>

But I don't know how to call this in relation to the text held in the database.

I've added that script to the page and then tried doing this:

<script>nl2br({{serverconnectseriescontacts.data.queryseriescontacts[0].nameandaddress}});</script>

but nothing displays on the page.

Any ideas what I'm doing wrong?

Did you try using the dmx-html attribute? You don't need any extra extensions for this.

Hi Tom

Yes I did, but it didn't work.

The database field doesn't contain any html. It just contains new lines in the text, which the php function nl2br() converts into html BR tags when displayed on the page.

So is there a way to use the javascript I found (above) to do the same with the data I'm displaying using app connect?

Or do you know another way to do this?

Bruce

Sorry - I was assuming there were <br> tags in the data.

Hopefully there is a simpler way to do this, but I think this works:

<p dmx-html="yourField.replace(&quot;\n&quot;, &quot;&lt;br&gt;&quot"></p>

Again, it uses the dmx-html attribute, in addition to the 'replace' function. Using the interface, select:
Dynamic Attributes - Inner HTML - and use the value yourField.replace("\n", "<br>" (via Data Formats)

Tom

Hi Guys,
There are 3 ways of doing this with app connect:

- Use replace(/\r\n|\r|\n/g, '<br>') with the dmx-html attribute (as the replace won't work without this attribute)
- Put your text in a <pre> tag
- Do this using CSS with the white-space: pre; property.

Thanks Teodor

Put it into a <pre> tag and styled it to match the rest of the text on the page.

Works a charm. Thanks

Bruce