Validaty of Phone Number

[#1]

Hi

I have a members table with a column for cell phone numbers, and I need to output members with cell phone numbers that are invalid (less/more than 10 digits).

Can anyone suggest the best way of doing this?

I thought about using mapping as an indicator of which cell numbers are valid and which aren't but I am battling with creating an IF statement for how many digits the cell number is.

Would appreciate any help!

Thanks so much

[#2 · Accepted solution]

you can use the len() function to determine the size of the field

If (len(cellphone) <> 10... for example

[pokassov]

Hello!

Look at len()

[vishsaggi]

Hello Taryn,

Use

If(Len(Phone) = 10, Phone, 'InvalidPhone')

V.

[MarcoWedel]

see your thread

Validity of a phone number

regards

Marco