# How to replace all spaces with dashes and make all characters lowercase

**URL:** <https://community.glideapps.com/t/how-to-replace-all-spaces-with-dashes-and-make-all-characters-lowercase/57279>\
**Category:** Ask for Help\
**Created:** [January 30, 2023, 10:18pm UTC](https://community.glideapps.com/t/how-to-replace-all-spaces-with-dashes-and-make-all-characters-lowercase/57279 "2023-01-30T22:18:45Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Peter1](https://avatars.discourse-cdn.com/v4/letter/p/a587f6/32.png) [@Peter1](https://community.glideapps.com/u/Peter1)\
**Post date:** [January 30, 2023, 10:18pm UTC](https://community.glideapps.com/t/how-to-replace-all-spaces-with-dashes-and-make-all-characters-lowercase/57279/1 "2023-01-30T22:18:45Z")

</div>

Hi, I’m new to Glide. I hope this is a straight forward request. How would I replace all spaces with dashes and make all characters lowercase.

For example, I have a column that is currently displaying the following:

2018-Audi-A4 allroad

I need to convert that text to:

2018-audi-a4-allroad

Any help is greatly appreciated! Thanks in advance!

---

<div class="post-metadata">

**Author:** ![glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glide/32/53398_2.png) [@glide](https://community.glideapps.com/u/glide)\
**Post date:** [January 30, 2023, 10:18pm UTC](https://community.glideapps.com/t/how-to-replace-all-spaces-with-dashes-and-make-all-characters-lowercase/57279/2 "2023-01-30T22:18:52Z")

</div>

_This is an experimental reply from a bot. Please like it if it’s correct._

You can use the Lowercase Text and Split Text Column computed columns to achieve this. The Lowercase Text column will convert all characters to lowercase, and the Split Text Column will split the text by spaces and replace them with dashes. For more information, please refer to the following links: Lowercase Text: [Glide • Lowercase Text column](https://www.glideapps.com/plugins/lowercase) and Split Text Column: [Glide Docs • Split Text Column](https://www.glideapps.com/docs/reference/computed-columns/split-text-column).

---

<div class="post-metadata">

**Author:** ![Peter1](https://avatars.discourse-cdn.com/v4/letter/p/a587f6/32.png) [@Peter1](https://community.glideapps.com/u/Peter1)\
**Post date:** [January 30, 2023, 10:27pm UTC](https://community.glideapps.com/t/how-to-replace-all-spaces-with-dashes-and-make-all-characters-lowercase/57279/3 "2023-01-30T22:27:39Z")

</div>

The Lowercase Text computed column works great! But the Split Text Column doesn’t seem to achieve my desired outcome. It seems to split the text string into an array. I’d like the output to remain a single string, but look like this:

2018-audi-a4-allroad

instead of:

2018-audi-a4 allroad

which it currently looks like after using the Lowercase Text column.

Unless I’m using the Split Text column incorrectly?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 30, 2023, 10:41pm UTC](https://community.glideapps.com/t/how-to-replace-all-spaces-with-dashes-and-make-all-characters-lowercase/57279/4 "2023-01-30T22:41:00Z")

</div>

You can use a template column. Point the value to the column that contains the text. Then set up a replacement that replaces space with dash.

---

<div class="post-metadata">

**Author:** ![Peter1](https://avatars.discourse-cdn.com/v4/letter/p/a587f6/32.png) [@Peter1](https://community.glideapps.com/u/Peter1)\
**Post date:** [January 31, 2023, 2:28am UTC](https://community.glideapps.com/t/how-to-replace-all-spaces-with-dashes-and-make-all-characters-lowercase/57279/5 "2023-01-31T02:28:19Z")

</div>

That worked @Jeff_Hager, thanks for your help

---

<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:** [February 1, 2023, 2:28am UTC](https://community.glideapps.com/t/how-to-replace-all-spaces-with-dashes-and-make-all-characters-lowercase/57279/6 "2023-02-01T02:28:48Z")

</div>

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