Country code in phone number

[alex_gibson0111]

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

[Aurelien]

Hi @alex_gibson011186

You may want to use SUBSTITUTE():

help.appsheet.com

SUBSTITUTE()

Text with replacements

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

Phone County Code "+" vs. "00" When I enter ... 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?

[alex_gibson0111]

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?

[Aurelien · Accepted solution]

Hi @alex_gibson011186

Never tried specifically this.

What about this:

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

For reference:

help.appsheet.com

MID()

Characters from text

help.appsheet.com

LEN()

Number of characters in textual value

help.appsheet.com

LEFT()

Left-most characters of text

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

[alex_gibson0111]

[Aurelien]

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

[alex_gibson0111]

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