07-16-2021, 12:14 PM | #1 |
Enthusiast
Posts: 26
Karma: 84276
Join Date: Aug 2011
Location: Tuscaloosa, AL
Device: Samsung Tablet
|
Wanting 1 column to have (up to) 4 other columns as individual tags
I have multiple series columns (the regular {series}, then {#series2}, {#series3}, and {#series4}).
I want them in one column where I can use it to search for the series as a tag. I tried using the Column Built From Other Columns, Behaves Like Tags, but it added the series all together into one tag, no matter how I tried breaking it up. I want each individual series as its own tag. Is there a way to do this? |
07-16-2021, 01:36 PM | #2 |
Wizard
Posts: 1,085
Karma: 1948136
Join Date: Aug 2015
Device: Kindle
|
User a composite column (built from other columns) with the following template:
Code:
program: series = 'series,#series2,#series3,#series4'; res = ''; sep = ','; for col in series: res = list_union(res, field(col), sep) rof; res |
Advert | |
|
07-16-2021, 03:22 PM | #3 |
Grand Sorcerer
Posts: 11,734
Karma: 6690881
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Take a look at grouped searches (Preferences / Searching / Grouped searches). A grouped search is a pseudo-column that combines all the source columns.
|
07-19-2021, 03:10 PM | #4 |
Enthusiast
Posts: 26
Karma: 84276
Join Date: Aug 2011
Location: Tuscaloosa, AL
Device: Samsung Tablet
|
@capink: That worked perfectly. Thanks!
@chaley: I wanted the column to use with Calibre Companion, so I needed it as a real column. (Or at least I think so.) :-D |
07-19-2021, 05:38 PM | #5 | |
null operator (he/him)
Posts: 20,558
Karma: 26954694
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Quote:
BR |
|
Advert | |
|
07-21-2021, 09:59 AM | #6 | |
Enthusiast
Posts: 26
Karma: 84276
Join Date: Aug 2011
Location: Tuscaloosa, AL
Device: Samsung Tablet
|
Quote:
|
|
Tags |
custom columns, multiple series |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Alphabetize tags on individual records | laszlopanaflex | Library Management | 6 | 11-10-2018 04:57 PM |
How to "copy" or combine tags in two columns not as a built column? | jecilop | Library Management | 7 | 09-04-2014 07:26 PM |
custom columns from only certain tags | areyou | Library Management | 2 | 12-15-2012 05:33 AM |
Regex to selectively grab individual tags? | Sidetrack | Library Management | 1 | 05-02-2012 02:33 AM |
Exporting based on individual tags | BookJunkieLI | Library Management | 7 | 02-22-2012 04:18 PM |