# Carriage return line break question

**URL:** <https://community.glideapps.com/t/carriage-return-line-break-question/24564>\
**Category:** Ask for Help\
**Created:** [March 21, 2021, 9:27pm UTC](https://community.glideapps.com/t/carriage-return-line-break-question/24564 "2021-03-21T21:27:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![22c304](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/22c304/32/19733_2.png) [@22c304](https://community.glideapps.com/u/22c304)\
**Post date:** [March 21, 2021, 9:27pm UTC](https://community.glideapps.com/t/carriage-return-line-break-question/24564/1 "2021-03-21T21:27:17Z")

</div>

Utilizing glide tables only.  
How would i utilize substitute or another function or ? to remove the commas from a joined list and replace with carriage return?  
So if i have this:  
130 – 5" Gutter, 60 – 3x4 Down spout  
And I want this:  
130 – 5" Gutter  
60 – 3x4 Down spout

How do i accomplish it.  
TIA

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 21, 2021, 10:52pm UTC](https://community.glideapps.com/t/carriage-return-line-break-question/24564/2 "2021-03-21T22:52:45Z")

</div>

I think you can create a text/template column with only a carriage return character.

Then use a template column, point to the original text, change all the commas by the carriage return.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 21, 2021, 10:56pm UTC](https://community.glideapps.com/t/carriage-return-line-break-question/24564/3 "2021-03-21T22:56:08Z")

</div>

> [@How can I make available a lookup](https://community.glideapps.com/t/how-can-i-make-available-a-lookup/24557/4):
>
> @22c304, you need to get the joined list from that same relation. Just like you did with the lookup but using a joined list column.

If you’re trying to format the text from this post, you can use the carriage return as the delimiter in the join text column.

---

<div class="post-metadata">

**Author:** ![22c304](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/22c304/32/19733_2.png) [@22c304](https://community.glideapps.com/u/22c304)\
**Post date:** [March 22, 2021, 1:19am UTC](https://community.glideapps.com/t/carriage-return-line-break-question/24564/4 "2021-03-22T01:19:53Z")

</div>

Thank you, yes that worked…
