<div dir="ltr"><div class="gmail_default" style="font-family:georgia,serif;color:rgb(7,55,99)"><br></div><div class="gmail_extra"><br><div class="gmail_quote">On 13 September 2017 at 22:15, Andrew Beeken <span dir="ltr"><<a href="mailto:anbeeken@lincoln.ac.uk" target="_blank">anbeeken@lincoln.ac.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-GB">
<div class="gmail-m_6857486707866096181WordSection1">
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif">Hi Matthew – this looks like the kind of solution we’re after! Your fix for multiple fields hasn’t done the trick so would you be able to share your
hack for the fieldlist_sizes function? I’ve taken a look and I’m really not sure what I need to change. This isn’t a mega issue, just more of an annoyance, but I do want to get it cleaned up!<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif">Thanks!<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif">Andrew<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif"><u></u> </span></p></div></div></blockquote></div><div class="gmail_default" style="font-family:georgia,serif;color:rgb(7,55,99)"><br></div><div class="gmail_default" style="font-family:georgia,serif;color:rgb(7,55,99)">It is not a graceful solution. To be honest, it probably makes more sense to use Alan's suggestion and prune the NULL values in the grouping function, though that does mean fetching more values from the database than you need and processing them in perl.</div><div class="gmail_default" style="font-family:georgia,serif;color:rgb(7,55,99)"><br></div><div class="gmail_default" style="color:rgb(7,55,99)"><span style="font-family:georgia,serif">If this is the path you want to go down, I've chucked the relevant bits into a gist: </span><font face="arial, helvetica, sans-serif"><a href="https://gist.github.com/phluid61/4a4e2da2c20c299c9dc39005ef65b654">https://gist.github.com/phluid61/4a4e2da2c20c299c9dc39005ef65b654</a></font></div><div class="gmail_default" style="font-family:georgia,serif;color:rgb(7,55,99)"><br></div><div class="gmail_default" style="font-family:georgia,serif;color:rgb(7,55,99)">Hopefully you can work out what to do with it from that.</div><div class="gmail_default" style="font-family:georgia,serif;color:rgb(7,55,99)"><br></div><div class="gmail_default" style="font-family:georgia,serif;color:rgb(7,55,99)">Cheers</div>-- <br><div class="gmail_signature"><div dir="ltr"> Matthew Kerwin<br> <a href="http://matthew.kerwin.net.au/" target="_blank">http://matthew.kerwin.net.au/</a></div></div>
</div></div>