# Return first part of text up to the second period?

**URL:** <https://connect.superhuman.com/t/return-first-part-of-text-up-to-the-second-period/44460>\
**Category:** Ask the Community\
**Created:** [November 14, 2023, 9:21pm UTC](https://connect.superhuman.com/t/return-first-part-of-text-up-to-the-second-period/44460 "2023-11-14T21:21:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chris\_Hall](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/chris_hall/32/26258_2.png) [@Chris\_Hall](https://connect.superhuman.com/u/Chris_Hall)\
**Post date:** [November 14, 2023, 9:21pm UTC](https://connect.superhuman.com/t/return-first-part-of-text-up-to-the-second-period/44460/1 "2023-11-14T21:21:51Z")

</div>

How can I return the first portion of a text field and stop at the second period?

---

<div class="post-metadata">

**Author:** ![Piet\_Strydom](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/piet_strydom/32/19269_2.png) [@Piet\_Strydom](https://connect.superhuman.com/u/Piet_Strydom)\
**Post date:** [November 14, 2023, 9:54pm UTC](https://connect.superhuman.com/t/return-first-part-of-text-up-to-the-second-period/44460/2 "2023-11-14T21:54:08Z")

</div>

Hi Chris,

You can use Split() with a period as delimiter:  
 ![image](https://global.discourse-cdn.com/coda1/original/3X/8/9/894fb634ba2937ad3977e08d6d7cc094af39f8a1.png)

And then concatenate(), the nth(1) and nth(2) portions:

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

Regards,  
Piet

---

<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:** [February 12, 2024, 9:54pm UTC](https://connect.superhuman.com/t/return-first-part-of-text-up-to-the-second-period/44460/3 "2024-02-12T21:54:24Z")

</div>

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