# Unbullet a Bulleted List

**URL:** <https://connect.superhuman.com/t/unbullet-a-bulleted-list/38905>\
**Category:** Ask the Community\
**Created:** [April 4, 2023, 3:49pm UTC](https://connect.superhuman.com/t/unbullet-a-bulleted-list/38905 "2023-04-04T15:49:39Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Doug\_Loud](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/doug_loud/32/28122_2.png) [@Doug\_Loud](https://connect.superhuman.com/u/Doug_Loud)\
**Post date:** [April 4, 2023, 3:49pm UTC](https://connect.superhuman.com/t/unbullet-a-bulleted-list/38905/1 "2023-04-04T15:49:39Z")

</div>

I have a list of all the states in USA and Canadian Provinces. But it is a Bulleted List. How can I easily remove the Bullets to use in another table? Does the Bullet have a symbol I can use with RegEx; I don’t see a formula entry to unbullet items.

---

<div class="post-metadata">

**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\
**Post date:** [April 4, 2023, 4:02pm UTC](https://connect.superhuman.com/t/unbullet-a-bulleted-list/38905/2 "2023-04-04T16:02:18Z")

</div>

Hi @Doug_Loud 😊

Strangely enough I tried this …

```auto
thisRow.[Column 2].Split(LineBreak()).Trim()

```

 ![Unbullet](https://global.discourse-cdn.com/coda1/original/3X/8/2/8249ad04e189b0e91144a6cd6a04d3337bc4c29c.png)

… and didn’t expect that result 😅

It returns a string though so if you need a list, you would need to re-`Split()` the string by comma (`","`)

```auto
thisRow.[Column 2].Split(LineBreak()).Trim().Split(",")

```

This seems to work too (and is probably cleaner 😇 ) :

```auto
thisRow.[Column 2].Split(LineBreak()).ForEach(
  CurrentValue.RegexReplace("-","")
)

```

 ![Unbullet 2](https://global.discourse-cdn.com/coda1/original/3X/7/0/703a8f087e7dad4e56f7ccc7c22d40cd0e47b759.png)

---

<div class="post-metadata">

**Author:** ![Doug\_Loud](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/doug_loud/32/28122_2.png) [@Doug\_Loud](https://connect.superhuman.com/u/Doug_Loud)\
**Post date:** [April 4, 2023, 4:35pm UTC](https://connect.superhuman.com/t/unbullet-a-bulleted-list/38905/3 "2023-04-04T16:35:27Z")

</div>

Thank you very much. I just found the bullet symbol out in emojis (I’m on a Mac) and got this formula to work:

thisRow.Split(“•”).Join(“”)

but I like yours better because having to use the emoji table concerns me.

---

<div class="post-metadata">

**Author:** ![Doug\_Loud](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/doug_loud/32/28122_2.png) [@Doug\_Loud](https://connect.superhuman.com/u/Doug_Loud)\
**Post date:** [April 4, 2023, 4:37pm UTC](https://connect.superhuman.com/t/unbullet-a-bulleted-list/38905/4 "2023-04-04T16:37:33Z")

</div>

And I often have strings to resplit back to Coda rows: lists of citations from a large block of text, etc.

---

<div class="post-metadata">

**Author:** ![Christiaan\_Huizer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/christiaan_huizer/32/28269_2.png) [@Christiaan\_Huizer](https://connect.superhuman.com/u/Christiaan_Huizer)\
**Post date:** [April 4, 2023, 4:40pm UTC](https://connect.superhuman.com/t/unbullet-a-bulleted-list/38905/5 "2023-04-04T16:40:20Z")

</div>

hi @Doug_Loud ,

I noticed the contribution of @Pch and I 'd like to add a different solution, this is with a button and you output flat text.

```auto
thisRow.Notes.ToText().ForEach(CurrentValue).WithName(base, 
     
  thisRow.ModifyRows(thisRow.[Column 3],base))

```

 ![image](https://global.discourse-cdn.com/coda1/original/3X/e/f/ef5f127023bbc8217c22dfc8ebf391c96dbb3460.png)

Cheers, Christiaan

---

<div class="post-metadata">

**Author:** ![Doug\_Loud](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/doug_loud/32/28122_2.png) [@Doug\_Loud](https://connect.superhuman.com/u/Doug_Loud)\
**Post date:** [April 4, 2023, 9:03pm UTC](https://connect.superhuman.com/t/unbullet-a-bulleted-list/38905/6 "2023-04-04T21:03:25Z")

</div>

Thanks, Christiaan - you always have very helpful information!

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [April 7, 2023, 9:03pm UTC](https://connect.superhuman.com/t/unbullet-a-bulleted-list/38905/7 "2023-04-07T21:03:41Z")

</div>

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