Import Excel Hyperlink to Filemaker

[anteas1998]

Hi

I have an excel sheet with a column containing hyperlinks. 
How can I import it into Filemaker 16  that it creates a field where the links are shown url as http://....??

 

Regards

[comment]

This has come up before:
https://fmforums.com/topic/73310-import-hyperlink-from-excel/

 

I don't know of anything that could be done within Filemaker alone in order to make this happen. You need to take some action in Excel before importing; either export to another format, or run a VBA script to extract the URLs to another column.

 

[OlgerDiekstra]

This article might help: https://howtouseexcel.net/how-to-extract-a-url-from-a-hyperlink-on-excel