Use search and replace to add leading zeroes

[zimpt]

I want to use search and replace on a bulk of files named "Chapter 1, Chapter 2... Chapter 100" to include leading zeroes so every file is 3 digit long: "Chapter 001, Chapter 002... Chapter100". If I enter "\d+" in the "Search for" field it detects the numbers but I don't know what to put in the "Replace with" field. \\n refers back to the number but how can i modify it conditionally?

[Karellen]

Where exactly are you trying to do this?
Is it in the Editor? Is it the xhtml files or the chapter headings in those files, or is it somewhere else?

I am just not sure where you would see that in "Library Management".

[zimpt]

Originally Posted by Karellen

Where exactly are you trying to do this?
Is it in the Editor? Is it the xhtml files or the chapter headings in those files, or is it somewhere else?

I am just not sure where you would see that in "Library Management".

In the virtual library selecting them all and clicking "Edit Metadata". Thought it was the right Channel because it has "managing metadata" in its description

[Karellen]

Maybe you can post a screenshot because I am not really understanding where you are seeing "Chapters" in the library listing.

[theducks]

The place is correct.
What we don't understand is WHY-WHERE this is to be done???
Numeric fields do not show leading 0's (integer>=1). 0.5 will show a single 0

Padding with 0 (or a space) is only valid for Text
You can 'format' filename strings in the send to Disk (or device) template
{series_index:0>5.2f}
That is my template for series_index when included in a filename.
2 digits before the . and 2 after (the 5)

[zimpt]

Originally Posted by Karellen

Maybe you can post a screenshot because I am not really understanding where you are seeing "Chapters" in the library listing.

I want to merge all those epubs. But because sorting by "Title" it sorts digit after digit instead of the whole number I thought it would be the best to add leading zeroes so the chapters are in the right order
(images are not shown for some reason https://imgur.com/a/an1SuqA, https://imgur.com/a/V5tn2Pd)

[BetterRed]

Suggest you look at the EPUBMerge plugin ==>> Index of plugins

BR

[chaley]

Originally Posted by zimpt

I want to merge all those epubs. But because sorting by "Title" it sorts digit after digit instead of the whole number I thought it would be the best to add leading zeroes so the chapters are in the right order

@BetterRed's suggestion is best, but you can get what you want by checking
the option Preferences / Behavior / Recognize numbers inside text when sorting.


With the option unchecked:


With the option checked:


You can also use a bulk search & replace with source "template" to change the titles to have a fixed number of leading zeros This is complicated and error prone so I don't recommend it. The template would be something like this, assuming that the number always appears at the end and that it can be floating point:

program:
	text = re($title, '^(.*?)[\d\.]*$', '\1');
	digits = re($title, '.*?((\d+(?:\.\d*)?|\.\d+)).*?', '\1');
	digits = format_number(digits, '08.2f');
	title = text & digits

[zimpt]

Originally Posted by chaley

@BetterRed's suggestion is best, but you can get what you want by checking
the option Preferences / Behavior / Recognize numbers inside text when sorting.
Attachment 206323

With the option unchecked:
Attachment 206322

With the option checked:
Attachment 206324

You can also use a bulk search & replace with source "template" to change the titles to have a fixed number of leading zeros This is complicated and error prone so I don't recommend it. The template would be something like this, assuming that the number always appears at the end and that it can be floating point:

program:
	text = re($title, '^(.*?)[\d\.]*$', '\1');
	digits = re($title, '.*?((\d+(?:\.\d*)?|\.\d+)).*?', '\1');
	digits = format_number(digits, '08.2f');
	title = text & digits

fixed it thanks