I have a text : https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/oxedx1RRB29pZ2kwVHF72/pub/x2iytEGwxQQNaBQeFRDx.png
where I would like to extract the image name x2bK2EGwxQQNaBQeFRDx.png
It can be done by a template column where I replace the folder name https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/oxedx1RRB29pZ2kwVHF72/
But I would like the text I want to replace (the folder name) to be put in another column to make it easier to substitute the folder name (as the folder name is used multiple places) with a new folder name - does anybody know if that is possible?
I can’t see this solves my problem. As I see it you suggestion will try to concatenate two strings. I want to extract a certain part of a string - the filename.
The folder I would like to store in a separate column and extract that value from my folder+filename column
Sounds like you might need some regex magic to find the first “/” from the right (the one prior to the file name) to result in the position as a number of that “/”. Then split the two values into two columns based on that information.
Trying to makes sense of this. So you obviously have the full url in one column. Do you have any other parts, like the file or folder separately, or is the full url the only thing you have to work with?
I’m just trying to understand the question, what you have, and what you want for the end result.
I think I’ve been interpreting your question as the folder is the encoded folder name in part of the path of the url (oxedx1RRB29pZ2kwVHF72). Not the full url path (https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/oxedx1RRB29pZ2kwVHF72/pub/). After rereading a few times, as I understand it, your only goal is to extract the file name (x2iytEGwxQQNaBQeFRDx.png) from the rest of the url, correct? I think the mention of ‘folder name’ was throwing me off and I thought you meant only the encoded part of the url path. When you say folder, you mean the entire url path, minus the file, correct? And again, your only goal is to isolate the file name out of the entire url?
How are you currently isolating the url path (folder name) into it’s own column?
as I understand it, your only goal is to extract the file name (x2iytEGwxQQNaBQeFRDx.png) from the rest of the url, correct?
When you say folder, you mean the entire url path, minus the file, correct? And again, your only goal is to isolate the file name out of the entire url?
I should never have put in the foldername in the description - because what I mean is the url which constitutes this: https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/oxedx1RRB29pZ2kwVHF72/pub/