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
Solved! Go to Solution.
Hi @Dev11
Please try the below.
IF Left(tostring([Field1]), 1) = "7"
THEN "+44 " + ToString([Field1])
ELSE [Field1]
ENDIF
Many thanks
Shanker V
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
Thanks Shankar worked like a charm