Country code in phone number

AppSheet AppSheet Q&A
,
1

Can i change the number “0” to “+” for country code in phone number?
i appreciate any help

2

Hi @alex_gibson011186

You may want to use SUBSTITUTE():

Also, just in case, please have a look on this post:

[Phone County Code "+" vs. "00"  When I enter ...](https://community.appsheet.com/t/phone-county-code-vs-00-when-i-enter/5550/9) Questions

Thanks @LeventK. Since i am dealing with international dialing (and “+”), looks like I may have to explore the Text col type and Action approach you use. I guess I could add a feature request for Phone col types to handle international dialing better? This workaround is fine, but would think Appsheet should handle the use case automatically for the user?

2 Likes
3

Hi @Aurelien

The formula works, I’ve managed to change “0” to “+”, the problem is that everything with the number “0” changes, how do I change just the first number? Can you help me?

SUBSTITUTE([phone],“0”,“+”)

what formula should i add?

1 Like
4

Hi @alex_gibson011186

Never tried specifically this.

What about this:

CONCATENATE(
   SUBSTITUTE(LEFT([phone],1),“0”,"+"),
   MID([Phone],2,LEN([Phone])-1)
)

For reference:

EDIT: correction to expression
EDIT2: correction:
MID([Phone],2,LEN([Phone]-1)) ==> MID([Phone],2,LEN([Phone])-1)

2 Likes
5

3X_1_8_186b0737eb3e51dbabd37034787a18f34b653b3a.png
3X_1_8_186b0737eb3e51dbabd37034787a18f34b653b3a.png799×922 58.1 KB

6

This is a misplaced parenthesis.
I corrected the expression above.

Aurelien:

EDIT2: correction:> MID([Phone],2,LEN([Phone]-1)) ==> MID([Phone],2,LEN([Phone])-1)

@alex_gibson011186 If you had checked at the documentation referenced provided, you would have noticed it

2 Likes
7

sorry I didn’t see it, thank you very much, now I can breathe easy

2 Likes