I'm trying to do an export of the %publisher% field, I use it for transistion data. When I export using:
if there is no data in the publisher field while the rest of the fields that do have data, a table border is drawn around it if there is data in it, when there is no data, the table border is not drawn, if I put a -134 for example, then the publisher field draws the border and puts the related data there.
Is there a way in the export to do something like:
Which clearly doesn't work.
Any thoughts to handle this?
Thanks
Here is the full export script:
</p><p>$filename(%_directory%_ABP_MASTER.html)<html>
<html>
<head>
<meta name="GENERATOR" content="">
<meta HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
<style type="text/css"><!--
h1 { color: #FFAA55; font-family: Calibri; font-size: 11pt }
h2 { font-family: Calibri; font-size: 9pt }
h3 { color: #000000; font-family: Calibri; font-size: 9pt }
body { font-family: Calibri; font-size: 8pt }
table { font-family: Calibri; font-size: 8pt }
a {color: #A10000; text-decoration: none }
a:hover {color: #A10000; text-decoration: none}
#wrap { width: 95%%; }
.tbox { padding: 10px; margin: 10px; background-color: #EFEFEF;}
--></style>
</head>
<body>
<body bgcolor="000000">
<div id="wrap">
$loop(%_folderpath%)
<div class="tbox">
<table border="0" width="100%%">
<tr>
<td width="75%%">
<table border="0" width="40%%">
<tr>
<td width="5%%" valign="top">
<h1>ALBUM: </h1>
</td>
<td width="20%%" valign="top">
<h1>%album%</a></h1>
</td>
</tr>
<tr>
<td width="5%%" valign=top>
<h1>YEAR: </h1>
</td>
<td width="20%%" valign=top>
<h1>%year%</h1>
</td>
</tr>
</table>
</td>
<td width="25%%" rowspan=4 valign="top" align="right">
</td>
</tr>
</table>
<table border="2" bgcolor="DCDCDC" width="100%%">
<tr bgcolor="#AAAAAA">
<td align="center"><b>TRACK</b></td>
<td><b>ARTIST</b></td>
<td><b>TITLE</b></td>
<td align="center"><b>BPM</b></td>
<td align="center"><b>LABEL</b></td>
<td align="center"><b>INITIAL KEY</b></td>
<td align="center"><b>LENGTH</b></td>
<td align="center"><b>BITRATE</b></td>
</tr>
$loop(%_path%) <tr>
<h3>
<td width=1 valign="top" align="center">[$num(%track%,1)]</td>
<td width=1 td valign="top">$if(%album artist%,%artist% - ,)%artist%</a></td>
<td width=1 td valign="top">$if(%album artist%,%artist% - ,)%title%</a></td>
<td width=1 valign="top" align="center">%bpm%</td>
<td width=1 valign="top" align="center">if2(%PUBLISHER%,"1")</td>
<td width=1 valign="top" align="center">%initialkey%</td>
<td width=1 valign="top" align="center">%_length%</td>
<td width=1 valign="top" align="center">%_bitrate%</td>
<td width=1 valign="top" align="center"></td></h3>
</tr>
$loopend()
</table>
</div>
$loopend()
</div>
</div>
</body>
</html></p><p>