How should I apply a sequence if text/string conversions?

[Malcolm_Lewis]

I need to clean/normalize urls that are copy/pasted by users from popular websites like IMDb, Yelp, and Amazon.

Below are the cleanups I am aware of.

In Bubble, I did this with a series of regexs that fed into each other in sequence.

In Glide, do I just chain together several text manipulation columns in my Glide table? I’d like to do this as efficiently as possible.

Required cleaning:

• 1. • Strip away any chars including and after "/ref="
• 2. • Strip away any chars that exist before "“https:” (it happens)
• 3. • Strip away all URL params so any chars including and after “?”
• 4. • Lowercase what’s left
• 5. • Trim leading/trailing chars from what’s left

[david]

It sounds like you want the Get Part of URL column.

Then use Transform JSON to assemble the cleaned parts: