how to validate phone number in a table

[#1]

i am looking for the code in phone number validation in a table..

[rwunderlich]

I think the best way is to validate it in the script using a Regular Expression. See this for an example:

Qlikview Cookbook: Regular Expression Pattern Matching http://qlikviewcookbook.com/recipes/download-info/regular-expression-pattern-matching/

-Rob

http://masterssummit.com

http://robwunderlich.com

[robert_mika]

Could you post examples?

[#4]

sorry robert..i  have no examples..because present i am learning in qlikview.. please  guide me how to write the code..i know isnum function is helpful to my code..but i don't know how to keep that function in my code..

[jagan]

Hi Venu,

Try like this

Data:

LOAD

*,

If(IsNum(PhoneNumber), 'Valid', 'Invalid') AS IsValidPhoneNumber

FROM DataSource;

Regards,

Jagan.

[#6]

thankyou  very much jagan its working..when i am enter the 11 digits numbers in the fields..the output will be comes in valid..but i want  to display invalid..

[jyothish8807]

Hi Venu,

Try like this:

If(len(PhoneNumber)='10', 'Valid', 'Invalid') AS IsValidPhoneNumber

Regards

KC

[jyothish8807]

for better validation try this:

If(len(PhoneNumber)='10' and isnum(PhoneNumber), 'Valid', 'Invalid') AS IsValidPhoneNumber

Regards

KC

[robert_mika]

If that's coming from a system(well or even manually entered I would use:

If(len(trim(PhoneNumber))='10' , 'Valid', 'Invalid') AS IsValidPhoneNumber

[jagan]

Hi,

Then check this option

Data:

LOAD

*,

If(IsNum(PhoneNumber) AND len(PhoneNumber)='10', 'Valid', 'Invalid') AS IsValidPhoneNumber

FROM DataSource;

Hope this helps you.

Regards,

Jagan.