How to split numbers in a text column

Jorel

Hi everyone,

I'm trying to separate number data in a text column formatted as 8.75 5 to display 8.75 and 5 as separate pieces of data.

I'd love any feedback on the simplest way to do this.

Liz Anaya

Hey @Jorel!

It looks like there are two separate discussions for this question. I answered your questions on this post, but I'll also add to this thread.

Check out this video that walks through how to use the split filter to split text at the first blank. The video also shows how to edit records in a database table once the text has been split.

Let me know if this is helpful or if you have any additional questions. 😊

Chris Coleman

Hi, Jorel. My first thought is to use the split filter, but that will give you an array. Can you clarify what you want your end result to be?

Jorel

I’d love to be able to use both pieces of data as separate fields in bubble.

score: 8.75

rank: 5

Jorel

Thanks @lizanaya - I'll take a look at the video now.

Unfortunately, the first point you linked is giving me this error.

Jorel

@lizanaya

Your video was super helpful and exactly what I needed. Thank you so much 🙌🏾

Liz Anaya

Awesome, @Jorel ! Happy to hear that it worked! 🥳