Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • General
  • Hi, I am newish to FME professional and I am wondering if there is a way of extracting the filename of a hyperlink (in google sheets).

To put this into context I have a google sheet which has hyperlinks to photos. It shows the shared link but not the filename. I need to be able to extract the filename (and ideally the directory path from Google drive) so I can relink the photo to the new location. Hope this makes sense

To get the Filename and Relative Path you have to use the GoogleDriveConnector set to List.

As far as I know there is no way of reconstructing them from the share_link directly.

Thanks @caracadrian​ that worked perfectly and it also extracts the relative_path which is exactly what I needed. Now I just need to create the new hyperlinks in the excel sheet using the data extracted. Thanks again 😀

Reply


Community Stats

30,163
Posts
114,500
Replies
37,814
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.