Removing the tail end from URLs

Hey John, try:

REGEX_REPLACE(
  {Text},
  '\\?(.*)',
  ''
)

REGEX_REPLACE(
  {Text},
  '\\?(.*)',
  ''
)

@Adam_TheTimeSavingCo Your example removes everything starting with the question mark, but John was asking about taking away everything after the last forward slash. Here’s what I came up with:

IF({URL}, REGEX_REPLACE({URL}, "[^/]*$", ""))

This focuses on the end of the string and strips away everything that’s not a forward slash.

@Justin_Barrett Thanks so much! This is definitely heading in the right direction. This works really great for most of my links.

I should have been more clear, because I have a bunch of different link formats with different amounts of /'s.

For example:

https://google.com/index/test
https://yahoo.com/example/test/e231/

It seems like really, the common denominator is that I want to keep everything to the left of the 3rd /.

Is there a way to modify the formula to approach it from that side?

I was thinking -

REGEX_REPLACE({URL}, "^https?:\/\/[^\/]+", "")

Having a complete set of test data that covers all use cases is always important. When using REGEX, a complete set of test data is absolutely essential!

REGEX_REPLACE({URL}, "^https?:\/\/[^\/]+", "")

@Bill.French Interesting, thanks for sharing!

This formula is giving me everything after the 3rd “/”. What I’m looking for is essentially the opposite, everything before (can include) the 3rd “/”.

@kuovonne appreciate the feedback! The data is confidential at this point so I’m unable to share it in bulk.

IF(
    REGEX_MATCH({URL}, "https?:\/\/[^\/]+"),
    REGEX_EXTRACT({URL}, "https?:\/\/[^\/]+")
)

You nailed it! Thanks so much @kuovonne. This is exactly what I needed :slightly_smiling_face:

It doesn’t have to be the actual data, but should represent the universe of possible patterns.