How can I boolean OR several tags into one custom column?

[bmix]

Hi,

I tried setting up a Usercolumn (user defined custom tags) because I want to use it to flag the book as part of a Kindle Collection, using the Collections plugin's import/export feature, that reads/fills this custom colum.

The column shall be named "Philosophy & Essays" if any of the tags of the book contain ("Philosophy" OR "Philosophie" OR "Essay" OR "Essays" OR "History" OR "Geschichte"). So, basically, I want to automate the addition of a flag.

The template I used first was:

{tags:'contains($,"Philosophy","Philosophie & Essays", "")'}

But, obviously, this only checks for a sinlge tag. What I need is a boolean OR. There is the or(value, value, ...) function, but I do not know how to apply it in this context.

{tags:'contains($,or("Philosophy", "Philosophie"),"Philosophie & Essays", "")'}

does not solve it.

On this: What do you guys use in order to test-evaluate such templates? The search-input in the main interface for the library does not play well with this, since the contains() function has a string output as a result.

EDIT: I found the template test GUI. So the last question is answered.

Thanks, Andreas

[DaltonST]

Trivial for the Derive Genres plugin. Just set the Custom Column in Configuration to be what your #customcolumn is (it defaults to #genre), then update the Boolean Tag rules .csv file accordingly. Follow the User Guide. Excel CANNOT be used because it is not UTF8 encoding compliant. Do not ignore the User Guide about UTF8 or the job will fail. Do not use Excel or try to fake it out. Waste of time. Follow the User Guide.

DaltonST

[eschwartz]

Or just do it with a simple program template:

in_list()

in_list(val, separator, pattern, found_val, not_found_val) – treat val as a list of items separated by separator, comparing the pattern against each value in the list. If the pattern matches a value, return found_val, otherwise return not_found_val.

program:

in_list(
	field('tags'),
	',',
	'^(Philosophy|Philosophie|Essay(s)?|History|Geschichte)$',
	'Philosophy & Essays',
	''
)

[chaley]

Another way to do it that checks for exact matches in tags instead of containment:

program:
	t = field('tags');
	v = 'Philosophy, Philosophie, Philosophy & Essays, History, Geschichte';
	l = list_intersection(t, v, ',');
	test(l, 'Philosophy & Essays', '')

By exact match I mean that the tag 'History' should match but the tag 'Military History' should not.