I want to enter the policy number to a portal.
I have an excel with column “Policy number” First I need to find the length of the policy number if the policy number is <=8 I need to insert zero based on length of policy number for example if the policy number(PN) is 1234567(7 digits) ,I need to add two zeros before the digits like 001234567, if PN is 12345678(8digits) then the output after adding zero should be 012345678(which is 9 digits) then I need to pass the 9 digits policy number to the portal for the further process.
In same way if the policy number contains >8 and <=10 digits policy number then i need convert into 11 digits number by padding or adding zero before the digits
for example if the policy number is 123456789(9digits) then output should be(00123456789) after adding zeros which will become 11digits,
if the policy number is 1234567890(10 digits) then output policy number should be 01234567890(11 digits) after converting the digits less than 9 to 9 digits and greater than 8 digits and less than 11 digits to 11 digits I need to pass the Policy number in to a portal further process.