Previous Topic: String FunctionsNext Topic: Name Functions


Telephone Number Functions

Finding Country Code

Function Name Example

Parameters Results

TelCountryCode(phone)

phone - full phone number

TelCountryCode('+972-8-7654321')

'972'

Finding Area Code

Function Name Example

Parameters Results

TelAreaCode(phone)

phone - full phone number

TelAreaCode('+972-8-7654321')

'8'

Finding last 7 Digits of a Phone Number

Function Name Example

Parameters Results

Tel7Digits(phone)

phone - full phone number

Tel7Digits('+972-9-7467346')

'7467346'