Help, please: column type

carmenchu · 10-10-2019, 03:34 PM

Hello! I would be very grateful for some help in this:

I have a custom colum in my database, of type TEXT, where I have been manually entering the 'year of creation' of each book.

Now, I would like to create another custom colum, of tipe DATE, and fill it with values from the first colum, putting the day and month to 01/01, i.e.
value -> 01/01/{imported value}

Is there some way (command line/plugin...) to do such a thing?
I suspect that the trouble is in the types of data. It easy to convert a DATA value to a text string. But, is it possible to 'make' a DATA value by concatening text strings and converting?
If the answer is 'no', I would appreciate it nonetheless...

theducks · 10-10-2019, 03:47 PM

Have you tried (Bulk mode) Metadata edit: S&R (tab)?
NOT TESTED
search your txt column (\d+)
replace: your date column \1 (if that does not work try 01/01/\1 )

carmenchu · 10-10-2019, 04:22 PM

Thanks a lot! 01 Jan \1 works.
I had tried something like that some 9 years ago, and ... no soap--which froze my thinking. But Calibre has changed--and so our acquaintance with regexp.
Thanks again.

10-10-2019, 03:34 PM	#1
carmenchu Groupie Posts: 191 Karma: 266070 Join Date: Dec 2010 Location: Spain Device: Win10,Win11,Ubuntu,PockbookLux44	Help, please: column type Hello! I would be very grateful for some help in this: I have a custom colum in my database, of type TEXT, where I have been manually entering the 'year of creation' of each book. Now, I would like to create another custom colum, of tipe DATE, and fill it with values from the first colum, putting the day and month to 01/01, i.e. value -> 01/01/{imported value} Is there some way (command line/plugin...) to do such a thing? I suspect that the trouble is in the types of data. It easy to convert a DATA value to a text string. But, is it possible to 'make' a DATA value by concatening text strings and converting? If the answer is 'no', I would appreciate it nonetheless...

10-10-2019, 04:22 PM	#3
carmenchu Groupie Posts: 191 Karma: 266070 Join Date: Dec 2010 Location: Spain Device: Win10,Win11,Ubuntu,PockbookLux44	Thanks a lot! 01 Jan \1 works. I had tried something like that some 9 years ago, and ... no soap--which froze my thinking. But Calibre has changed--and so our acquaintance with regexp. Thanks again. Last edited by carmenchu; 10-10-2019 at 04:39 PM. Reason: typo

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Annoyance - Column Type Long Text	BetterRed	Calibre	4	08-28-2016 11:29 PM
Want a custom column showing the indentifiers type	OldLincoln	Library Management	3	10-09-2015 01:45 AM
Using "Build column from other column" custom-column type	HFC3	Library Management	3	07-07-2013 03:11 AM
Question about series_index, and related column type	ElMiko	Calibre	3	10-14-2011 09:10 AM
Changing column type for reading queue	paulfiera	Calibre	7	05-31-2011 01:10 PM

10-10-2019, 03:47 PM	#2
theducks Well trained by Cats Posts: 31,064 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Have you tried (Bulk mode) Metadata edit: S&R (tab)? NOT TESTED search your txt column (\d+) replace: your date column \1 (if that does not work try 01/01/\1 )

Advert