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

**URL:** <https://community.glideapps.com/t/how-should-i-apply-a-sequence-if-text-string-conversions/34094>\
**Category:** Ask for Help\
**Created:** [November 5, 2021, 9:18pm UTC](https://community.glideapps.com/t/how-should-i-apply-a-sequence-if-text-string-conversions/34094 "2021-11-05T21:18:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Malcolm\_Lewis](https://avatars.discourse-cdn.com/v4/letter/m/5f9b8f/32.png) [@Malcolm\_Lewis](https://community.glideapps.com/u/Malcolm_Lewis)\
**Post date:** [November 5, 2021, 9:18pm UTC](https://community.glideapps.com/t/how-should-i-apply-a-sequence-if-text-string-conversions/34094/1 "2021-11-05T21:18:01Z")

</div>

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="**

- 
  1. 
    - Strip away any chars that exist **before**" **“https:”** (it happens)

- 
  1. 
    - Strip away all URL params so any chars **including and after** “ **?** ”

- 
  1. 
    - **Lowercase** what’s left

- 
  1. 
    - **Trim** leading/trailing chars from what’s left

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [November 5, 2021, 9:26pm UTC](https://community.glideapps.com/t/how-should-i-apply-a-sequence-if-text-string-conversions/34094/2 "2021-11-05T21:26:46Z")

</div>

It sounds like you want the [Get Part of URL](https://www.glideapps.com/plugins/url-parts) column.

Then use `Transform JSON` to assemble the cleaned parts:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/f/4f66d0787ee7889d6bab7b82aace95022b9d26f9.png)

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [November 7, 2021, 2:17pm UTC](https://community.glideapps.com/t/how-should-i-apply-a-sequence-if-text-string-conversions/34094/4 "2021-11-07T14:17:02Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.