View Single Post
Old 02-03-2023, 05:41 AM   #1
Doum
Connoisseur
Doum began at the beginning.
 
Posts: 66
Karma: 10
Join Date: Jun 2020
Device: Kobo Aura HD
program move from "publisher" to a new column with conditions

Hi,
There no second series column possibility, so before I know the existing of "custum column" I used "publisher" to store my reference "SN <number>" but only in some specifics books

But now, I want to create a new custum column (SN) and use this number only if the format "SN [0-9][0-9][0-9][0-9]" exist in my publisher's column
(and also remove/replace this name in publisher)

Do you think it's possible? (with search&replace ?)

A program like that
create a new column SN
for each ebook in my library
do
If regex publisher tag is like SN [0-9][0-9][0-9][0-9]
then
copy the number in the SN column
replace publisher column with "Gallimard"
else
donothing
fi
done

Example SN 0345 (string in publisher column) ==> 345 (number in SN column )

THanks for your suggestions (and sorry for my English)

PS : my first idea was to create a SQL scripts directly on the sqllite (metadata) but it's very risky. I prefere using internal command if it(s possible

Last edited by Doum; 02-03-2023 at 06:07 AM.
Doum is offline   Reply With Quote