Phone number validation using set analysis

[#1]

Can some one tell me the set analysis expression for phone number validation?

[#2]

Sample Inline table

Table:

Load * inline

[

ID,Email, PNo.

1,michael.marchetti@comnos.com,2925678974

2,tim.steinlein@comnos.com,(201)297-8976

3,michael.marchetti@comnos.de,20897

4,tim.steinlein@comnos.de,(732)307

5,michael.marchetti@unvalid@comnos.de,(732)897-7362

6,zain.com,12345

7,zain@hotmail.com,732306-

];

I should get the answer for valid phone numbers as 3 showing in bar chart

[Nicole-Smith]

I think something like this would work:

count({<[PNo.]={'=WildMatch(KeepChar([PNo.],''0123456789''),''??????????'')'}>}[PNo.])

I've also attached an example file.