MobileRead Forums - View Single Post - column from other columns with hierarchy and names

chaley · 10-01-2018, 04:03 PM

Given that I don't have the columns you describe, the best I can do is a guess at something that might solve your problem.

Code:

program:
	a = list_re(field('#letterers'), '&', '(.*)', 'letterers.\1');
	b = list_re(field('#illustrators'), '&', '(.*)', 'illustrators.\1');
	c = list_re(field('#colorists'), '&', '(.*)', 'colorists.\1');
	t = list_union(a, b, '&')
	list_union(c, t)

There is probably a better way to merge the results of the 3 list_re functions given that they are orthogonal , but I leave that to you. Good luck!

10-01-2018, 04:03 PM	#2
chaley Grand Sorcerer Posts: 12,454 Karma: 8012886 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	Given that I don't have the columns you describe, the best I can do is a guess at something that might solve your problem. Code: program: a = list_re(field('#letterers'), '&', '(.)', 'letterers.\1'); b = list_re(field('#illustrators'), '&', '(.)', 'illustrators.\1'); c = list_re(field('#colorists'), '&', '(.*)', 'colorists.\1'); t = list_union(a, b, '&') list_union(c, t) There is probably a better way to merge the results of the 3 list_re functions given that they are orthogonal , but I leave that to you. Good luck!