Support CSV import from Confluence with hyperlinks

Suggestion Box
1

In general, the CSV import from Confluence works quite well.

But when I export the Confluence table with hyperlinks, they are stored in CSV in form of =HYPERLINK(<URL>; <Title>), and Coda imports them as is, without converting them to proper URLs.

A lot of our Confluence tables contain hyperlinks, and we need a way to import these tables to Coda as easy as possible.

So, my suggestion is to handle the =HYPERLINK values properly during CSV import and convert them to nicely-looking links automatically.

2

I would use a workaround: just make a button to clean up your table: the code in the button would look something like this:

HyperLinkTable.filter(hyperlink.Containstext("=HYPERLINK(<")).ForEach(ModifyRows(CurrentValue,hyperlink,hyperlink.RegexExtract("\<(.*?)\>").last()))

Maybe the regex can be cleaned up a little better then this, but this works quick and simple.