Adding area code to phone number

[Dev11]

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

[ShankerV · Accepted solution]

Hi @Dev11 

Please try the below.

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

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Dev11 

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

[Dev11]

Thanks Shankar worked like a charm