Can “Date”/”Timestamp” Be Added to Search Field in “Search and Replace?”

stardot · 06-05-2025, 07:12 PM

Hi,

I've been using the field "Date", that has the lookup name "timestamp", as the first published date. Now I have created new field called "first published" that will replace the "Date" field.

I have a lot of books, and I wanted to do the "search and replace" method to copy all dates from field "Date" to field "first published."

The problem is that in the search field in the "search and replace" window does not contain the field "Date"/"timestamp". Can it be added or fixed?

Thank you very much

theducks · 06-05-2025, 08:14 PM

Try using {template} for the field (top item in the pulldown)
and {timestamp} as the template The (value of the Template)
Search for (.+)
replace with \1
Destination <your custom datefield>

stardot · 06-09-2025, 07:24 AM

Thanks

06-05-2025, 07:12 PM	#1
stardot Member Posts: 10 Karma: 10 Join Date: Dec 2020 Device: Laptop	Can “Date”/”Timestamp” Be Added to Search Field in “Search and Replace?” Hi, I've been using the field "Date", that has the lookup name "timestamp", as the first published date. Now I have created new field called "first published" that will replace the "Date" field. I have a lot of books, and I wanted to do the "search and replace" method to copy all dates from field "Date" to field "first published." The problem is that in the search field in the "search and replace" window does not contain the field "Date"/"timestamp". Can it be added or fixed? Thank you very much

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
search by date added	Gardenman	Library Management	3	05-04-2017 12:09 AM
Regex in search problems (NOT Search&Replace; the search bar)	lairdb	Calibre	3	03-15-2017 07:10 PM
Search and Replace: want to remove value that matches another field	einniv	Library Management	0	07-25-2013 08:18 PM
Search for Date added	Compere	Library Management	6	06-08-2013 04:27 PM
Search on Added Date	nynaevelan	Calibre	6	11-10-2010 09:15 PM

06-05-2025, 08:14 PM	#2
theducks Well trained by Cats Posts: 30,952 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Try using {template} for the field (top item in the pulldown) and {timestamp} as the template The (value of the Template) Search for (.+) replace with \1 Destination <your custom datefield>

06-09-2025, 07:24 AM	#3
stardot Member Posts: 10 Karma: 10 Join Date: Dec 2020 Device: Laptop	Thanks

Advert