1[% USE CSV -%] 2[% CSV.dump([ 'MAC' 'Vendor' 'Switch' 'Port' 'IPs' ]) %] 3 4[% FOREACH row IN results %] 5 [% mylist = [] %] 6 [% mylist.push(row.mac.upper) %] 7 [% mylist.push(row.vendor) %] 8 [% mylist.push(row.dns || row.name || row.switch) %] 9 [% mylist.push(row.port) %] 10 [% mylist.push(row.ip_count) %] 11 [% CSV.dump(mylist) %] 12 13[% END %] 14