Remove a digit from a Phone Number

How To
1

Hello!

I’m trying to remove one digit from this field data: phone number.

for exemple:

The number is +5582988888888

I want the number +558288888888

So, how can I remove this 9 from there?

image

2

If the character is always in the same position in the string, then you can use the substring() function to get the first half of the string, and the second half of the string, and then combine them. The final formula would look something like:

substring(1.string; 0; 5)substring(1.string; 6; length(1.string))

3 Likes
3

Thanks, Khurram!

I solved doing this:

image

3 Likes