Calc: Importing csv full of URL's

[Diagon]

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

[PYS]

HI

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

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

Regards

[Diagon]

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.

[PYS]

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.