Sort library by length of title (or author, etc) ?

[copyrite]

Originally Posted by chaley

Use "program:format_number(strlen(field('title')), '{0:d}')"

Originally Posted by theducks

Good you included a screen shot
That screen shows 'Digits' (text), not Numbers, which is why the Search term (for a numeric field) does not work.

The column needs to be Floating Point for that to work
or you need to pad enough leading 0's (blanks are just too hard to see ) to match the highest digit count

So... how do I modify chaley's template (above) to achieve my goal?

[theducks]

Originally Posted by copyrite

So... how do I modify chaley's template (above) to achieve my goal?

chaley is way beyond me


Only a Guess : change

{0:d}

to

{0>3f}

[chaley]

Originally Posted by copyrite

Sorting by the header sort of works, but it gives me wonky results. Here's a mere sampling of my library to show you what I mean:

Spoiler:

That was the exact phrase I attempted to search for, yes, from the page you indicated, but it didn't work, maybe because the RegEx needs to allow for two numeric place holder values?

Change the sort type of the custom column (made from other columns) to number.

[copyrite]

Thank you!

One of my titles from Amazon is 161 characters long. *shakes head*

[Rob557]

Originally Posted by chaley

Change the sort type of the custom column (made from other columns) to number.

Thanks chaley ... I should have mentioned that aspect before and so belatedly inserted a more complete description of the process earlier in this thread. I'll repeat some of it here for more convenient reference:

In setting up the custom column (by right-clicking on the existing row of column descriptors and selecting "add your own columns", then clicking on the "+" icon (or the "i" icon after the column is set up)), after inputting a name of your choice and choosing the column type "column built from other columns", and inputting the template description that chaley provided

"program:format_number(strlen(field('title')), '{0:d}')"

it is important (as chaley also identifies herein) to also select the accompanying option to sort/search column by "number".

[copyrite]

Oh never mind. The Quality Check plug-in can achieve the same output.

[Rob557]

Originally Posted by copyrite (as self-edited)

Oh never mind. The Quality Check plug-in can achieve the same output.

Just to clarify copyrite's post-edit comment in the immediately preceding posting, he was not referring to the subject of this thread (sort by length of title), but he was instead referring to the following posting that he had made, and subsequently replaced with the above comment, regarding checking tags:

Originally Posted by copyrite (self-deleted)

Rather than creating a new thread since this is a similar idea, how do you create a custom column that lists the number of tags in each entry using "{tags:count(,)}". Is this still a 'column build from other columns'? I tried a bit of cut and paste from the previous example "program:format_number(strlen{tags:count(,)}), '{0:d}" but it did not work ...

copyrite was noting that the Quality Check plug-in has an option that handles tags ("check metadata / check excess tags"), but note that the Quality Check plugin does not currently identify the character length of titles, authors, etc. and so the information provided by chaley (and theducks) in this thread was quite useful.