Size COMMENTS column ?

[crnirg]

How can I make my column in which the length (size) of the COMMENTS column will be in characters or maybe just whether it is more or less than say 50?

[chaley]

Originally Posted by crnirg

How can I make my column in which the length (size) of the COMMENTS column will be in characters or maybe just whether it is more or less than say 50?

Make a "Column built from other columns" with the heading and lookup name whatever you want.

To show the length, set the template to this Single Function Mode template and set the column's Sort/search type to "Number".

{comments:strlen()}

To make it say "Yes" if the length is greater than or equal to 50, otherwise "No" use this Template Program Mode template

{comments:'cmp(strlen($), 50, 'No', 'Yes', 'Yes')'}

or this General Program Mode template

program:
	if strlen($comments) >=# 50 then 'Yes' else 'No' fi

or this Python Template Mode template

python:
def evaluate(book, context):
	comments = book.get('comments')
	return 'Yes' if comments and len(book.get('comments')) >= 50 else 'No'

[crnirg]

Thanks for the answer - I tried it and for an empty comment it shows exactly 0, but already for the test 0123456789 it shows 29.
And for larger comments, it makes mistakes - the bigger the comment, the bigger the error - let's say from 20-60 for lengths of 10-2300 characters.
I'm sure it's something small, but it's a joke.

[chaley]

Originally Posted by crnirg

Thanks for the answer - I tried it and for an empty comment it shows exactly 0, but already for the test 0123456789 it shows 29.
And for larger comments, it makes mistakes - the bigger the comment, the bigger the error - let's say from 20-60 for lengths of 10-2300 characters.
I'm sure it's something small, but it's a joke.

Comments are in HTML. Those characters count.

[crnirg]

Here is an example:


<div>
<p>Prevod: Živković Mirjana; Naslov originala: Anderson Poul THREE HEARTS AND THREE LIONS, 1961.</p>
<p>Prevod: Živković Mirjana; Naslov originala: Anderson Poul THREE HEARTS AND THREE LIONS, 1961.</p></div>

online says 211 my Calibre 188 .

That I don't bother you too much?

[chaley]

Using this text:

<div>
<p>Prevod: Živković Mirjana; Naslov originala: Anderson Poul THREE HEARTS AND THREE LIONS, 1961.</p>
<p>Prevod: Živković Mirjana; Naslov originala: Anderson Poul THREE HEARTS AND THREE LIONS, 1961.</p></div>

and using the template {comments:strlen()}, I get 213 characters.

If I manually count the displayed characters I also get 213, the same as the template. Don't forget that the end of line is a character.

Loading that text into Notepad++, a text editor, I get 217 characters. The difference between Notepad++ and the template is that Notepad is counting the components (bytes) of composed characters, for example Ž and ć, as two characters (bytes). There are 4 such characters in the string, making the length 4 longer: 217 instead of 213.

I have no idea where the 188 comes from. Nor do I know where the "online tool" gets 211.

In any event, the output of the template is the best count your going to get from calibre.

[crnirg]

Tried it and just like you say - it's probably because of the HMTL tags - in any case, thanks a lot for the answer.

[crnirg]

'7' seems to give me a lot of possibilities that I wanted - learning regex will remain a wish, so far as it goes