# Carriage return as array delimiter

**URL:** <https://community.tulip.co/t/carriage-return-as-array-delimiter/1029>\
**Category:** Support, Troubleshooting, & Help\
**Created:** [November 5, 2020, 5:36pm UTC](https://community.tulip.co/t/carriage-return-as-array-delimiter/1029 "2020-11-05T17:36:53Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jeff](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/jeff/32/3379_2.png) [@Jeff](https://community.tulip.co/u/Jeff)\
**Post date:** [November 5, 2020, 5:36pm UTC](https://community.tulip.co/t/carriage-return-as-array-delimiter/1029/1 "2020-11-05T17:36:53Z")

</div>

Is there a way to store an array in a table field with the delimiter designated as a carriage return?

---

<div class="post-metadata">

**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\
**Post date:** [November 5, 2020, 5:51pm UTC](https://community.tulip.co/t/carriage-return-as-array-delimiter/1029/2 "2020-11-05T17:51:38Z")

</div>

hello @Jeff, just to confirm I’m understanding correctly - are you trying to replace the comma’s in this example with with `'\n'`??

 ![Screen Shot 3](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/e591535c4a0fa9a4781345a05648869d81b7a21e.jpeg)

you cannot store Arrays in Table fields, you need to first convert the Array into Text by using the function `TOTEXT()`.

if you could share a little more on what you’re trying to build hopefully we can be more helpful!!

---

<div class="post-metadata">

**Author:** ![Jeff](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/jeff/32/3379_2.png) [@Jeff](https://community.tulip.co/u/Jeff)\
**Post date:** [November 5, 2020, 6:34pm UTC](https://community.tulip.co/t/carriage-return-as-array-delimiter/1029/3 "2020-11-05T18:34:45Z")

</div>

Yes, that would be correct.

---

<div class="post-metadata">

**Author:** ![Jeff](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/jeff/32/3379_2.png) [@Jeff](https://community.tulip.co/u/Jeff)\
**Post date:** [November 5, 2020, 6:37pm UTC](https://community.tulip.co/t/carriage-return-as-array-delimiter/1029/4 "2020-11-05T18:37:37Z")

</div>

I am currently using the “join to string” under the array trigger and I store it in a table field. It requires a delimiter. I could try using Manipulate Data - store- function TOText()

---

<div class="post-metadata">

**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\
**Post date:** [November 5, 2020, 8:33pm UTC](https://community.tulip.co/t/carriage-return-as-array-delimiter/1029/5 "2020-11-05T20:33:52Z")

</div>

hey @Jeff, yes the `TOTEXT()` function will also work!! you can then use logic similar to this to separate it out again if you need it in an app as an Array:

app trigger:

 ![Screen Shot 6](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/1a64ba29a54e93fc9033f1c7d7ab38ac4d1f54a8.jpeg)

table:

 ![Screen Shot 8](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/9599bb03584d33c17d8978c77c032386974da6b3.jpeg)

result:

 ![Screen Shot 7](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/e492c2214923b83f0b650def8dd8c55fa177a268.jpeg)

let me know if you’re able to build what you’re trying to accomplish!!

---

<div class="post-metadata">

**Author:** ![Jeff](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/jeff/32/3379_2.png) [@Jeff](https://community.tulip.co/u/Jeff)\
**Post date:** [November 5, 2020, 8:49pm UTC](https://community.tulip.co/t/carriage-return-as-array-delimiter/1029/6 "2020-11-05T20:49:32Z")

</div>

That is what I am trying to accomplish, thank you. I will give the expression a try.  
I am curious though if there is also a way to set the delimiter as a carriage return? This would simplify the trigger and I should be able to just display the text in record field. I think…

---

<div class="post-metadata">

**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\
**Post date:** [November 5, 2020, 9:31pm UTC](https://community.tulip.co/t/carriage-return-as-array-delimiter/1029/7 "2020-11-05T21:31:56Z")

</div>

great to hear @Jeff, let me know if you’re able to build what you’re attempting to accomplish!!

currently, the delimiter cannot be customized. although you bring up a great point about avoiding the extra actions to process the data. the engineering team is aware of the need to add Array support for Tables, I’ll keep you posted with updates.

in the meantime, let me know if that solution works!!

gio

---

<div class="post-metadata">

**Author:** ![FahdERM](https://avatars.discourse-cdn.com/v4/letter/f/ce7236/32.png) [@FahdERM](https://community.tulip.co/u/FahdERM)\
**Post date:** [July 26, 2022, 1:21pm UTC](https://community.tulip.co/t/carriage-return-as-array-delimiter/1029/8 "2022-07-26T13:21:52Z")

</div>

Hey guys,  
@gio, is there a method to delete the " " when saving the array in the table because i am going to use this data after loading the record in a loop and create different records in another table using this array.  
I mean that first, i am going to save an array with different element in a table column for example : [“123”,“568”,“623”,“467”].  
After that i will load this record and store [“123”,“568”,“623”,“467”] in an array as you have done below.  
And finally, using the length of the array and a loop create different records in an other table : records IDs will be : “123”, “568”, “623” and “467”. But in this case, Tulip will create records using the " " or what i want to do is to delete this delimiter and just create records using these IDs : 123, 568, 623 and 467.  
thank you for your help,
