5 Replies Latest reply: Sep 30, 2015 8:17 AM by Jonathan Dienst RSS

    Check validity of a phone number

      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