# How to extract text before or after certain characters?

**URL:** <https://connect.superhuman.com/t/how-to-extract-text-before-or-after-certain-characters/34609>\
**Category:** Ask the Community\
**Created:** [October 17, 2022, 5:28am UTC](https://connect.superhuman.com/t/how-to-extract-text-before-or-after-certain-characters/34609 "2022-10-17T05:28:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![yscias](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/yscias/32/29458_2.png) [@yscias](https://connect.superhuman.com/u/yscias)\
**Post date:** [October 17, 2022, 5:28am UTC](https://connect.superhuman.com/t/how-to-extract-text-before-or-after-certain-characters/34609/1 "2022-10-17T05:28:46Z")

</div>

Hi, Im wondering if there is a way or formula to extract text before or after certain characters? So for example like I’ve got a list of product names:

iPhone 14 (32GB)  
iPhone 14 (64GB)  
iPad Air (64GB)  
AirPods Pro  
AirPods Pro 2

How do I extract the first part of the string of text that comes before " " or “(” ? Any ideas?

---

<div class="post-metadata">

**Author:** ![Quentin\_Morel](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/quentin_morel/32/31407_2.png) [@Quentin\_Morel](https://connect.superhuman.com/u/Quentin_Morel)\
**Post date:** [October 17, 2022, 6:05am UTC](https://connect.superhuman.com/t/how-to-extract-text-before-or-after-certain-characters/34609/2 "2022-10-17T06:05:17Z")

</div>

> [@yscias](#):
>
> iPhone 14 (32GB)  
> iPhone 14 (64GB)  
> iPad Air (64GB)  
> AirPods Pro  
> AirPods Pro 2

Hi @yscias

in your case you can :

- split around the character " ("
- take the first part of this split, which is your iphone model

 ![image](https://global.discourse-cdn.com/coda1/original/3X/d/2/d27e9465715b8ad031206787266e47d498c66cef.png)

Please let me know if I misunderstood your point !

Have a nice Day

Quentin

---

<div class="post-metadata">

**Author:** ![yscias](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/yscias/32/29458_2.png) [@yscias](https://connect.superhuman.com/u/yscias)\
**Post date:** [October 17, 2022, 8:40am UTC](https://connect.superhuman.com/t/how-to-extract-text-before-or-after-certain-characters/34609/3 "2022-10-17T08:40:15Z")

</div>

Thanks a lot, this is great! I didnt know split can be used with other characters!

Follow up question, is there an easy way to remove the “)” at the end, rather than doing another split?

---

<div class="post-metadata">

**Author:** ![Quentin\_Morel](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/quentin_morel/32/31407_2.png) [@Quentin\_Morel](https://connect.superhuman.com/u/Quentin_Morel)\
**Post date:** [October 17, 2022, 9:07am UTC](https://connect.superhuman.com/t/how-to-extract-text-before-or-after-certain-characters/34609/4 "2022-10-17T09:07:39Z")

</div>

You can use a combination of split and join in chain to remove the caracter you dont want 🙂

```auto
thisRow.Name.Split("(").Join("").Split(")").Join("")

```

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

---

<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:** [October 20, 2022, 9:08am UTC](https://connect.superhuman.com/t/how-to-extract-text-before-or-after-certain-characters/34609/5 "2022-10-20T09:08:27Z")

</div>

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