Create url like in ecxel

Hello everyone,

is it possible to create a urls like in excel? For example:
=HYPERLINK(CONCATENATE(https://www.google.de/search?q=;EXAMPLE))
The “EXAMPLE” should be out of the KNIME-table.

All the best
TheScientist

Hi there, you can use the node called ‘String Manipulation’. Choose function join(“https://www.google.de/search?q=;”,columnEXAMPLE)

1 Like

Thank you very munch.

The concatenate works, but in the .xlsx I can’t click on the link.
It should be a hyperlink.

Hi @TheScientist

Can you try adding the the =HYPERLINK to the string like this
join("=HYPERLINK(https://www.google.de/search?q=;”,columnEXAMPLE, ")")?

best,
Gabriel

Thank you, for your reply.
I tried it, but in the excel sheet stands now:
“=HYPERLINK(https://www.google.de/search?q=example)”
When I write it like that in excel it would work, but with KNIME there’s only the expression.

Ok I figured out the problem:

  1. you need to encode the url in a special way, the full formula needs to be enclosed by quotation marks, the arguments as by double quotation marks: "=HYPERLINK(""https://example.com/"",""name"")"


2. This only works when writing the table as CSV, not with the Excel Writer, also you need to set the column seperator to something else than “,”, e.g. “;”, as well as disable the quotation option in the settings of the CSV Writer. I have attached an example workflow that demonstrates how to do this: Create HYPERLINK CSV.knwf (6.4 KB)
best,
Gabriel

1 Like

It still doesnt work. I think its because excel want to have the url http://whatever.com/ with quotation marks before and after. When I added them in the expression: =HYPERLINK(https://www.google.de/search?q=example) the hyperlink works. Is it possible to add them with the “String Manipulation” and use other punctuation marks? Or is it possible to mask two quotation marks?

Ok I got it. I mask them with " and save it as .csv.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.