Html conv and <br />

Hi all,

I have a MySQL field that stores product descriptions and allows for html to be embedded, I have no problem with tbs displaying correctly formatted html but I also want it to replace newlines with <br />.  It would seem tbs cannot do both, I have my field like so: [pro.proWebDesc;htmlconv=no], with this it correctly formats the text but newlines are gone, but with [pro.proWebDesc;htmlconv=yes] I have newlines replaced with <br /> but no formatting.

Does anyone know how to resolve this issue?

Kind Regards,
OuTa-SyNc

Hi OuTa,

TBS cannot convert only new lines in native. But you can make it using parameter 'onformat' and a custom function.

It is strange to store text converted into HTML but new lines.

I realise it is not normal to do it the way I have but I have no choice as our company use a Windows based EPoS and database system which in turn manages the website fully.  In order to keep symbols etc readable from the Windows program they are not converted to their HTML equivalent, html formatting is saved as-is, so when reloaded into our app it is then readable.

I will use an ondata custom function to do what is needed, I hoped there would be a more optimised way of doing it.

Thank you for your help