HTML Export Adding Line Breaks in Headers

Ignition
,
1

Hello All,

I have a dataset that I am converting to html for a quick export. I would like to insert line breaks for new lines in the header, but I am having difficulty.

For example:

data_param = system.db.runQuery("""SELECT id, machine, feederpressure as "Feeder<BR>Pressure", pressureaddon as "Pressure<BR>Add On" from  table ORDER BY id;""")
html = system.dataset.dataSetToHTML(True, data_param, "Machine Parameters Table")
system.perspective.download("export.html", html)

My html file header is then:

id | machine | Feeder<BR>Pressure | Pressure<BR>Add On

It seems like the converter is "too smart" and is automatically converting text that could be interpreted as html into special characters such that it renders. Is there a way I can achieve the desired result?

Thanks.

2

I did find a solution that works for me. It is not particularly clean, but I thought I would post it here in case anyone else can use it.

data_param = system.db.runQuery("""SELECT id, machine, feederpressure, pressureaddon from  table ORDER BY id;""")
html = system.dataset.dataSetToHTML(True, data_param, "Machine Parameters Table")
html = html.replace("<TH>feederpressure</TH>", "<TH>Feeder<BR>Pressure</TH>")
html = html.replace("<TH>pressureaddon</TH>", "<TH>Pressure<BR>Add On</TH>")
system.perspective.download("export.html", html)