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

    Check validity of a phone number



      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