Comments

[Rellwood]

Ok, so I have been adding to the comments in books to have data from the columns, and it has been working pretty good so far. I have been using the copy/replace to use templates that look a bit like this:

<b>Most Frequent Words: </b>{#mfw}<br><br><b>Original File Name: </b>{#original_file_name}<br><br>
<b>Booksource: </b>{#booksource}<br><br>
<b>Date Added: </b>{#dateadded}<br><br><b>GR Average Rating: </b>{#gr1}<br><br>
<b>Pages: </b>{#pages}<br><br>
<b>Word: </b>{#word}<br><br><b>Tags: </b>{tags}<br><br><b>Genre: </b>{#genre}<br><br>
<b>Comments:</b>


While it looks fine in the book details page and when I use them for catalogs and jackets, the tags all show up when I create a csv. Instead of being able to see the comments, all I get is a long line of html mixed with the information. No formatting or line breaks.

Suggestions? My goal is to make the comments show up without the formatting tags when I create a catalog.

I use this to see which comments need fixing.

[ownedbycats]

Do you mind using external programs after generating the catalogs?

CSV files can open in Notepad++ which would let you do search-and-replace.

[Rellwood]

I have notepad++

Acutally, I have been trying to do a search and replace in excel, it's slow going though, and it doesn't cover everything.

I'll try it! Thanks!

[ownedbycats]

I believe Notepad++ supports regexes and there's this regex to strip HTML tags.

[Rellwood]

Originally Posted by ownedbycats

I believe Notepad++ supports regexes and there's this regex to strip HTML tags.

Yeah, it's a process - too many books and I sometimes wonder if I should just start over. LOL