MobileRead Forums - View Single Post - Using re-function in columns

Divingduck · 10-30-2017, 06:23 AM

Hi m.s.
this will change blanks with regex:

Code:

re(field('series'), '\s', '+')

Edit:
If you want to use it in a custom column, make it via program mode:

Code:

program:
suchtext=re(field('series'), '\s', '+');
suchtext=re(suchtext, '\&', '%26');
strcat('<a href=','https://www.goodreads.com/search?utf8=%E2%9C%93&q=',suchtext,'&search_type=books','">Find on Goodreads</a>')

Column type: "Column build from other columns"
and if you want to use it in book details as clickable value check "Show as HTML in Book details" (maybe hit visibility as column).

10-30-2017, 06:23 AM	#2
Divingduck Wizard Posts: 1,166 Karma: 1410083 Join Date: Nov 2010 Location: Germany Device: Sony PRS-650	Hi m.s. this will change blanks with regex: Code: re(field('series'), '\s', '+') Edit: If you want to use it in a custom column, make it via program mode: Code: program: suchtext=re(field('series'), '\s', '+'); suchtext=re(suchtext, '\&', '%26'); strcat('<a href=','https://www.goodreads.com/search?utf8=%E2%9C%93&q=',suchtext,'&search_type=books','">Find on Goodreads</a>') Column type: "Column build from other columns" and if you want to use it in book details as clickable value check "Show as HTML in Book details" (maybe hit visibility as column). Last edited by Divingduck; 10-30-2017 at 07:36 AM.