Ask Your Question
0

calc: Importing csv full of URL's [closed]

asked 2016-04-30 08:50:09 +0100

Diagon gravatar image

I'm importing a cvs full of: date,time,URI,etc... into calc. I'd like the URIs (which point to documents) to be imported as clickable links, but the Fields>>Column-Type drop-down on the import dialogue doesn't give that option. Otherwise, I'd like to be able to change the full imported column into hyperlinks, rather than being forced to do it one cell at a time, as with Insert >> Hyperlink.

The URI could either look like "file:///document-path" or just the path/filename.

Does anyone know how to do this? (Kind of new at this. Maybe it's easy?)

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-04 12:46:36.430251

1 Answer

Sort by » oldest newest most voted
0

answered 2016-04-30 10:02:38 +0100

pierre-yves samyn gravatar image

HI

If you can not detect as hyperlinks when importing, you can convert after:

  • EditFind & Replace
  • Search For: http.*|file:.*
  • Replace With: =HYPERLINK("&")
  • Other Options: check Regular expressions (also Current selection if necessary)
  • Replace All

Regards

edit flag offensive delete link more

Comments

Ok, that almost works. It should be: 'Search for: http:.*|file:.*' Also, the HYPERLINK needs some text to replace the link with. This works: '=HYPERLINK("&","&")'. Thanks, man.

Diagon gravatar imageDiagon ( 2016-04-30 10:52:34 +0100 )edit

Thank you for feedback...

Just for information the second parameter is optional (see Help): if the CellText parameter is not specified, the URL is displayed in the cell text and will be returned as the result.

pierre-yves samyn gravatar imagepierre-yves samyn ( 2016-04-30 11:51:30 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2016-04-30 08:50:09 +0100

Seen: 749 times

Last updated: Apr 30 '16