# Separate numbers

**URL:** <https://forum.bubble.io/t/separate-numbers/162914>\
**Category:** Need help\
**Created:** [August 3, 2021, 12:21pm UTC](https://forum.bubble.io/t/separate-numbers/162914 "2021-08-03T12:21:08Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![rafael.cunha](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/rafael.cunha/32/111233_2.png) [@rafael.cunha](https://forum.bubble.io/u/rafael.cunha)\
**Post date:** [August 3, 2021, 12:21pm UTC](https://forum.bubble.io/t/separate-numbers/162914/1 "2021-08-03T12:21:08Z")

</div>

Hi, I am trying to create a number separator that goes into the database and exposes the data differently.

Here is an exempel:

Data Phone number: 0701234567  
Displayed in the frontend: 070 123 45 67

To be more specific, we added spaces on the 3rd 6 and 8 character. Is that possible?

---

<div class="post-metadata">

**Author:** ![Kayami](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/kayami/32/111689_2.png) [@Kayami](https://forum.bubble.io/u/Kayami)\
**Post date:** [August 3, 2021, 1:13pm UTC](https://forum.bubble.io/t/separate-numbers/162914/2 "2021-08-03T13:13:14Z")

</div>

Is that a US phone number?  
If so, just store the data as a text field without any extra formatting, so like `0701234567`

Then when you want to display the phone number you can use `:formatted as` → `US Phone`

Check out this image from another thread

![Screenshot 2020-06-13 15.19.14](https://us1.discourse-cdn.com/bubble/original/3X/b/6/b60b1443ef245e77932ea54db5765b702be19501.png)

---

<div class="post-metadata">

**Author:** ![rafael.cunha](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/rafael.cunha/32/111233_2.png) [@rafael.cunha](https://forum.bubble.io/u/rafael.cunha)\
**Post date:** [August 3, 2021, 2:40pm UTC](https://forum.bubble.io/t/separate-numbers/162914/3 "2021-08-03T14:40:32Z")

</div>

Hi Kayami, unfortunatly its not an US phone number. Its a Swedish one, is there any other way to fix the issue?

---

<div class="post-metadata">

**Author:** ![Efe](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/efe/32/257452_2.png) [@Efe](https://forum.bubble.io/u/Efe)\
**Post date:** [August 3, 2021, 3:35pm UTC](https://forum.bubble.io/t/separate-numbers/162914/4 "2021-08-03T15:35:39Z")

</div>

Hello @rafael.cunha!

You can do it with “:truncated to” operator. It’s a bit of a hassle to do, but it works the way you want it to.

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/f/f/ff35409a3560a98478e3c3a102a099db4a66d319.png)

You can take a look at the [sample](https://bubble.io/page?name=index&id=forumexamplesapp&tab=tabs-1) I prepared.

Best!

---

<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:** [October 12, 2021, 12:21pm UTC](https://forum.bubble.io/t/separate-numbers/162914/5 "2021-10-12T12:21:50Z")

</div>

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