Calculate length of excel cell
Application UI validation of Postal code field for customer add screen says -
"Postal code is not valid. It should be 6 digit and numeric".
Question is -
1. Do I need to create test data for 1 digit, 2 digit, 3 digit till 5 digit in excel file? I mean to say these 5 records should exist in the excel file to validate the Postal Code?
2. Suppose Excel file have test data named "Postal Code" and value is 123.
In script, How to check the length of Postal code cell in script? or Do I need to check with the same test data as in below example.
Currently I am using with same test data in excel-
if aqConvert.VarToStr(Driver.Value(6)) = "123" then
"fill all the fields of application and checkpoint to compare the application actual output with the excel file's expected output."
Please suggest.