Regex help, column from other columns

Shakahron · 11-20-2021, 11:20 AM

Ok so I've been banging my head against this for a while now and I think it's just beyond me and I'm not even sure if it's actually possible.

I want to take a column built from other columns containing tags and enclose each tag in quotes. Example: Fantasy, Thriller, Action = "Fantasy", "Thriller", "Action".

Apologies if this sounds stupid. I use an android app called tachiyomi to view manga and comics and it requires you to create a json file with tags in that format for each entry.

chaley · 11-20-2021, 11:42 AM

Code:

{#comp2:'list_re($, ',', '^(.*)$', '"\1"')'}

Replace "#comp2" with the name of your column containing the tags.

Note that this won't work if any of the tags contain quotes because it makes no attempt to process/escape them.

Shakahron · 11-20-2021, 11:49 AM

Quote:

Originally Posted by chaley

Code:

{#comp2:'list_re($, ',', '^(.*)$', '"\1"')'}

Replace "#comp2" with the name of your column containing the tags.

Note that this won't work if any of the tags contain quotes because it makes no attempt to process/escape them.

Thank you so, so much. This is exactly what I was looking for. Hope you have an amazing day.

zaroz · 11-23-2021, 07:44 PM

Ooh, I have been wondering about the viability of using calibre with tachiyomi myself. Please share your solution when you have it worked out!

11-20-2021, 11:20 AM	#1
Shakahron Junior Member Posts: 2 Karma: 10 Join Date: Nov 2021 Device: Samsung Galaxy Tab S6	Regex help, column from other columns Ok so I've been banging my head against this for a while now and I think it's just beyond me and I'm not even sure if it's actually possible. I want to take a column built from other columns containing tags and enclose each tag in quotes. Example: Fantasy, Thriller, Action = "Fantasy", "Thriller", "Action". Apologies if this sounds stupid. I use an android app called tachiyomi to view manga and comics and it requires you to create a json file with tags in that format for each entry.

11-20-2021, 11:42 AM	#2
chaley Grand Sorcerer Posts: 12,525 Karma: 8065948 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	Code: {#comp2:'list_re($, ',', '^(.*)$', '"\1"')'} Replace "#comp2" with the name of your column containing the tags. Note that this won't work if any of the tags contain quotes because it makes no attempt to process/escape them.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to regex bulk update the Title column from another column?	halloleo	Library Management	10	04-16-2021 03:27 AM
Column with Ratio of 2 other Columns?	MarjaE	Library Management	4	02-21-2020 07:00 PM
Column Built from other Columns question	abqkjh	Library Management	2	09-15-2017 12:08 PM
Yes/No column built from other columns	barlowrm	Calibre	5	11-17-2016 03:34 PM
Can I generate sum of column or columns?	GeekyGal	Calibre	5	09-29-2011 08:32 PM

11-23-2021, 07:44 PM	#4
zaroz Member Posts: 11 Karma: 10 Join Date: Oct 2020 Device: Samsung Galaxy Tab S6	Ooh, I have been wondering about the viability of using calibre with tachiyomi myself. Please share your solution when you have it worked out!