Catalog generation with Word Count in Description

[slantybard]

I am trying to create catalogs that will include word count appended to the description. I see that there are options for custom columns to be added to the description from the catalog generation dialog boxes, but my column for "word count" as generated by the "count pages" plugin is not an accepted option (? maybe it's because it's not a text column ?).

Is there any easy way to get this info added to my catalog descriptions? I tried a search but could not find a solution that would apply to my case. If someone has already answered this or figured it out, can you please direct me to the resource needed or give any advice. Many thanks for your help.

[theducks]

Originally Posted by slantybard

I am trying to create catalogs that will include word count appended to the description. I see that there are options for custom columns to be added to the description from the catalog generation dialog boxes, but my column for "word count" as generated by the "count pages" plugin is not an accepted option (? maybe it's because it's not a text column ?).

Is there any easy way to get this info added to my catalog descriptions? I tried a search but could not find a solution that would apply to my case. If someone has already answered this or figured it out, can you please direct me to the resource needed or give any advice. Many thanks for your help.

Bulk Mode Search and replace
Search #pages (or whatever) : (\d+)
Replace Comments APPEND MODE <any words you want> \1

[slantybard]

Originally Posted by theducks

Bulk Mode Search and replace
Search #pages (or whatever) : (\d+)
Replace Comments APPEND MODE <any words you want> \1

Thanks, that is a great way to do it! I never thought of just directly adding all word counts to the comments via S&R. I have a follow up question though - is there any way to have the # formatted with commas in the replacement regex (ie, my word count column shows the number as xx,xxx where as the S&R preview shows the number as xxxxx without commas)?

Thanks for your help.

[theducks]

Originally Posted by slantybard

Thanks, that is a great way to do it! I never thought of just directly adding all word counts to the comments via S&R. I have a follow up question though - is there any way to have the # formatted with commas in the replacement regex (ie, my word count column shows the number as xx,xxx where as the S&R preview shows the number as xxxxx without commas)?

Thanks for your help.

I don't know if functions can be used here

[slantybard]

I have figured out a work around to the comma separated thousands. I am running 2 S&R to do so:

1. search "#wordcount" for

(\d+)

and then replace with

<br><br> \1 Words

in "comments" using "append to field" with the "split result" unchecked

2. search "comments" for

(\d)(?=(\d\d\d)+(?!\d))

and replace with

\1,

in "comments" using "replace field"

Not elegant, but works.