Ask Your Question
0

calc: Importing csv full of URL's

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

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 close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

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 +0200 )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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 471 times

Last updated: Apr 30 '16