Using re-function in columns

[m.s]

I want to use the re-Function for use in a column for the search series on Goodreads.

Here is the source from my column:

<a href="https://www.goodreads.com/search?utf8=%E2%9C%93&query={series}">Find on Goodreads</a>

If a series has an ampersand (eg. "Alpha & Omega"), goodreads finds only the first word. So I want to replace the blanks with "+" and the ampersands with "%26". But I´ve problems to understand the re-function. I´ve tried:

{series:re(field('series'), " ", "+")}

but it doesn't work. Whats wrong here?

[Divingduck]

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

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

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

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).

[m.s]

Ah, great. Now I understand this. Thank you!

[Divingduck]

Your'e wellcome