for those interested, this is what I came up with after 8 days of struggling...
program:
frst = template('{tags:sublist(0,1,\,)}');
scnd = template('{tags:sublist(1,2,\,)}');
thrd = template('{tags:sublist(2,3,\,)}');
frth = template('{tags:sublist(3,4,\,)}');
a = test(frst, strcat(field('#collection'), ".", frst), field('#collection'));
b = test(scnd, strcat(", ", field('#collection'), ".", scnd), "");
c = test(thrd, strcat(", ", field('#collection'), ".", thrd), "");
d = test(frth, strcat(", ", field('#collection'), ".", frth), "");
strcat(a, b, c, d);
#collection contains the main genre, tags the subgenres, output placed in new custom column
|