# UUID - unique value ... BUT without characters that screw up other things

**URL:** <https://community.glideapps.com/t/uuid-unique-value-but-without-characters-that-screw-up-other-things/35727>\
**Category:** Feature Requests\
**Created:** [December 9, 2021, 1:28pm UTC](https://community.glideapps.com/t/uuid-unique-value-but-without-characters-that-screw-up-other-things/35727 "2021-12-09T13:28:00Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\
**Post date:** [December 9, 2021, 1:28pm UTC](https://community.glideapps.com/t/uuid-unique-value-but-without-characters-that-screw-up-other-things/35727/1 "2021-12-09T13:28:00Z")

</div>

Hi - I am trying to create video rooms automatically using the row ID…

BUT in [daily.co](http://daily.co) (I am testing this now as my emergency video option) they do NOT ACCEPT things like full stops ‘.’ and other weird characters.

There is enough randomness already… so could Glide update the UUID generator to exclude these if possible?

Thanks! M

---

<div class="post-metadata">

**Author:** ![ShantanuIyengar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shantanuiyengar/32/35546_2.png) [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)\
**Post date:** [December 9, 2021, 1:30pm UTC](https://community.glideapps.com/t/uuid-unique-value-but-without-characters-that-screw-up-other-things/35727/2 "2021-12-09T13:30:08Z")

</div>

You could try to use replace text for the time being

---

<div class="post-metadata">

**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\
**Post date:** [December 9, 2021, 2:05pm UTC](https://community.glideapps.com/t/uuid-unique-value-but-without-characters-that-screw-up-other-things/35727/3 "2021-12-09T14:05:42Z")

</div>

ah… the plugin for replace text…

you get the row ID… good!  
you have your plug in to replace . with X… ok…  
you click… and what do you get?

a whole row of XXXXs…

but how???

Not very happy - can you just get rid of the dot, please, @Mark 😉

 ![Screenshot 2021-12-09 at 14.56.56](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/82f9bf53982a823648047b3d2176186bc9f897f2.png)

---

<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:** [December 9, 2021, 2:07pm UTC](https://community.glideapps.com/t/uuid-unique-value-but-without-characters-that-screw-up-other-things/35727/4 "2021-12-09T14:07:44Z")

</div>

Why not just use a template column instead of a plugin and replace special characters there?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 9, 2021, 2:20pm UTC](https://community.glideapps.com/t/uuid-unique-value-but-without-characters-that-screw-up-other-things/35727/5 "2021-12-09T14:20:53Z")

</div>

What Jeff said ⬆

But, just for future reference, a period is regular expression wildcard, which means “match _any_ character”.

If you want to replace a literal period, you need to escape it…

 ![Screen Shot 2021-12-09 at 10.18.05 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/8/18c0f8b176e506b8a882b542f9f35baff28fd1e4.jpeg)

---

<div class="post-metadata">

**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\
**Post date:** [December 9, 2021, 2:23pm UTC](https://community.glideapps.com/t/uuid-unique-value-but-without-characters-that-screw-up-other-things/35727/6 "2021-12-09T14:23:13Z")

</div>

How would this work…

1. I have the row ID ----- ok…
2. I make a template column… which does … nothing  
– because I need to read in the value of the row ID… then I need to replace the . with something else  
— I cannot do these two steps in a template column

There is a Glide solution (which I then make into integromat)

- row ID - ok
- split rowID with dot as separator
- single value - first - from the split  
and use that sv-value for my ‘room name’

That works 🙂

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 9, 2021, 2:25pm UTC](https://community.glideapps.com/t/uuid-unique-value-but-without-characters-that-screw-up-other-things/35727/7 "2021-12-09T14:25:54Z")

</div>

> [@Mark\_Turrell](#):
>
> 1. — I cannot do these two steps in a template column

yeah you can…

 ![Screen Shot 2021-12-09 at 10.25.12 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/b/9b44d36e76ce52310011007e9298ad48d19ba1f3.png)

---

<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:** [December 9, 2021, 2:36pm UTC](https://community.glideapps.com/t/uuid-unique-value-but-without-characters-that-screw-up-other-things/35727/8 "2021-12-09T14:36:51Z")

</div>

☝

---

<div class="post-metadata">

**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\
**Post date:** [December 9, 2021, 2:42pm UTC](https://community.glideapps.com/t/uuid-unique-value-but-without-characters-that-screw-up-other-things/35727/9 "2021-12-09T14:42:41Z")

</div>

![Tommy_cooper_just_like_that](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8e276f35a526a96a1fa459c58315191aa08bae79.gif)

---

<div class="post-metadata">

**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\
**Post date:** [December 9, 2021, 7:26pm UTC](https://community.glideapps.com/t/uuid-unique-value-but-without-characters-that-screw-up-other-things/35727/10 "2021-12-09T19:26:19Z")

</div>

I learn another trick 🙂 🙂 thanks @Darren_Murphy and @Jeff_Hager !

---

<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:** [December 9, 2021, 7:59pm UTC](https://community.glideapps.com/t/uuid-unique-value-but-without-characters-that-screw-up-other-things/35727/11 "2021-12-09T19:59:34Z")

</div>

Wow that behavior with `.` is very weird.

I did not realize we were using a Regex there ([glide-code-columns/replace-all.ts at master · glideapps/glide-code-columns · GitHub](https://github.com/glideapps/glide-code-columns/blob/master/src/columns/replace-all.ts#L21)) – we should not be.
