Converting to number (removing spaces)

Need help Database
1

Hi guys,

I am receiving numbers from Shopify > Integromat > Bubble. They come through with spaces, e.g. 021 123 456. But when I the bubble app tries to call / SMS in that format it doesn’t work. If the spaces are removed it does. I have tried to use :convert to number, however that command doesn’t work on removing spaces. It either spits on 21 (removing the first 0 and stopping after the space), or just doesn’t work.

I’ve also tried converting to US number, but that doesn’t work ether (I live in New Zealand, don’t know if that makes a difference).

Help would be very much appreciated! Cheers :slight_smile:

2

Have you tried using the find & replace operator? It’s not very clear in my screenshot, but the Text to find is a space character and Replace by is empty. This will result in all spaces being removed.

find_replace
find_replace699×366 13.2 KB

3

This worked a charm. Super appreciate your time posting :slight_smile:

1 Like