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
Solved
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).
+9- Contributor
Best answer by caracadrian
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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+23- Contributor
- Best Answer
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.
+9- Contributor
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 😀
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.