Fetch Name from URL

You can use fn!split() to break the url string up into an array of sub-strings. Assuming the rules you've provided hold true the <filename> will be in the 2nd item in the resulting array:

fn!split(ri!url, "_")[2]

The problem here is the filename can contain '_' .. so it will split based on that too 

Ok, so that was one of the "rules" in the problem statement that you'd neglected to mention. Are there other "rules" that might help guide you to a solution? For example, is the length and/or format of the value of "unique_id" deterministic? Will the initial part of the URL always end ".com" ? Anything predictable/deterministic about the value of the "remaining_url" ?

Ok the rules would be : 

The url will always start with https://www.google.com/ 

The unique Id will always be 36 digits 

The unique ID will be followed by an '_',

the underscore will be followed by the file name (file name can contain underscores ) 

file name will be followed by '?' which marks the end of file name

then it will be followed by the rest of the url whose length is uncertain and can contain all kinds of characters

Try this

a!localVariables(
  local!url: "https://www.google.com/1234_xyz_pqr_abc.png?_<remaining url>",
  local!start: find("_", local!url),
  local!end: find("?", local!url),
  right(
    left(local!url, local!end - 1),
    local!end - local!start - 1
  )
)

Ok, so we can say the first part of the URL will always be 60 characters long (the length of the initial part of the URL plus the 36 characters of the unique Id).

So we can extract the url after all of this "prefix". That will leave us with the filename and the trailing part of the URL. We also know that the filename is terminated by the "?" character so we can split the remaining string at this point:

a!localVariables(
  local!fileNameStartsAtPosition: 60, /* in reality you'd make this a constant */
  local!fileNameAndRemainingUrl: fn!right(
    ri!url,
    fn!len(ri!url) - local!fileNameStartsAtPosition
  ),
  fn!split(local!fileNameAndRemainingUrl, "?")[1]
)

Thank you so much

Thank you

The key to solving these types of problems is two-fold:

1. specify the problem as completely as you can
2. break the solution into small steps  that can be assembled into the overall solution

Surely, will remember it next time. Thanks for feedback

Surely, will remember it next time. Thanks for feedback