Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 10-10-2019, 03:34 PM   #1
carmenchu
Zealot
carmenchu is a name known to allcarmenchu is a name known to allcarmenchu is a name known to allcarmenchu is a name known to allcarmenchu is a name known to allcarmenchu is a name known to allcarmenchu is a name known to allcarmenchu is a name known to allcarmenchu is a name known to allcarmenchu is a name known to allcarmenchu is a name known to all
 
Posts: 117
Karma: 159672
Join Date: Dec 2010
Device: Win7,Win10,Lubuntu,smartphone
Help, please: column type

Hello! I would be very grateful for some help in this:
  1. I have a custom colum in my database, of type TEXT, where I have been manually entering the 'year of creation' of each book.
  1. 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...
carmenchu is offline   Reply With Quote
Old 10-10-2019, 03:47 PM   #2
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 23,751
Karma: 27620664
Join Date: Aug 2009
Location: The Central Coast of California
Device: K4NT, Galaxy Tab A, Kobo Aura2
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 )
theducks is online now   Reply With Quote
Old 10-10-2019, 04:22 PM   #3
carmenchu
Zealot
carmenchu is a name known to allcarmenchu is a name known to allcarmenchu is a name known to allcarmenchu is a name known to allcarmenchu is a name known to allcarmenchu is a name known to allcarmenchu is a name known to allcarmenchu is a name known to allcarmenchu is a name known to allcarmenchu is a name known to allcarmenchu is a name known to all
 
Posts: 117
Karma: 159672
Join Date: Dec 2010
Device: Win7,Win10,Lubuntu,smartphone
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
carmenchu is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 04:02 PM.


MobileRead.com is a privately owned, operated and funded community.