Adding area code to phone number

Hi guys Newbie here I was wondering if anyone could give me a solution as to how I can add the UK area code on a field with the format 7xxxxxxxxx so it looks like +44 7xxxxxxxxx.

IF StartsWith([Phone], "7") THEN ReplaceFirst([Phone], "07", "+44")
ELSE [Phone]
ENDIF

I was using this but it does not seem to work

Workflow

Accepted answers

Please try the below.

IF Left(tostring([Field1]), 1) = "7"
THEN "+44 " + ToString([Field1])
ELSE [Field1]
ENDIF

Many thanks

Shanker V

In the IF condition, we are checking whether the first digit is 7
If yes, then adding +44 as per your requirement
Else then displaying the same phone number

Hope it helps!!!

Many thanks

Shanker V

All comments

Please try the below.

IF Left(tostring([Field1]), 1) = "7"
THEN "+44 " + ToString([Field1])
ELSE [Field1]
ENDIF

Many thanks

Shanker V

In the IF condition, we are checking whether the first digit is 7
If yes, then adding +44 as per your requirement
Else then displaying the same phone number

Hope it helps!!!

Many thanks

Shanker V

Thanks Shankar worked like a charm

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703