# Need Help: Extract text after a certain character

**URL:** <https://forum.bubble.io/t/need-help-extract-text-after-a-certain-character/193319>\
**Category:** Need help\
**Created:** [February 23, 2022, 8:07pm UTC](https://forum.bubble.io/t/need-help-extract-text-after-a-certain-character/193319 "2022-02-23T20:07:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jcindy81](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jcindy81/32/37417_2.png) [@jcindy81](https://forum.bubble.io/u/jcindy81)\
**Post date:** [February 23, 2022, 8:07pm UTC](https://forum.bubble.io/t/need-help-extract-text-after-a-certain-character/193319/1 "2022-02-23T20:07:10Z")

</div>

Hello! I’m looking for a way to extract text after a certain character in a field. I have product data fields, in which users are entering information to describe size/color of an item.

For example: S/Red  
A Size small, Red shirt.

I want to capture only the color name after the /.

I haven’t had much luck with regex (though I’m dumb in it) and Bubble doesn’t have an in-built function to truncate a text after a certain character. Any ideas? I know it has to be a simple solution that I’m overlooking. Thank you!

---

<div class="post-metadata">

**Author:** ![Jici](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jici/32/30722_2.png) [@Jici](https://forum.bubble.io/u/Jici)\
**Post date:** [February 23, 2022, 8:27pm UTC](https://forum.bubble.io/t/need-help-extract-text-after-a-certain-character/193319/2 "2022-02-23T20:27:23Z")

</div>

Use :split by /: last item

---

<div class="post-metadata">

**Author:** ![jcindy81](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jcindy81/32/37417_2.png) [@jcindy81](https://forum.bubble.io/u/jcindy81)\
**Post date:** [February 24, 2022, 4:59pm UTC](https://forum.bubble.io/t/need-help-extract-text-after-a-certain-character/193319/3 "2022-02-24T16:59:56Z")

</div>

Never thought to use :last item. Worked perfectly. Thank you!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/bubble/original/3X/2/8/2847faa74692c2ffa5d939d3dc3724cdd060d247.png) [@system](https://forum.bubble.io/u/system)\
**Post date:** [May 4, 2022, 8:07pm UTC](https://forum.bubble.io/t/need-help-extract-text-after-a-certain-character/193319/4 "2022-05-04T20:07:36Z")

</div>

Closed on May 4, 2022, 8:07pm UTC

This topic was automatically closed after 70 days. New replies are no longer allowed.
