I have a list of database in which there are 5 columns, namely - Service Area Code, Phone Numbers, Preferences, Opstype, Phone Type. And the data is as follows.
13 9907655320 0 A 2
17 9861445262 0 A 2
17 9861395056 0 A 2
13 9827772718 0 A 2
17 9861003374 0 A 2
13 9827340346 0 A 2
17 9861037312 0 A 2
17 9861144351 0 A 2
17 9861208733 0 D 2
17 9861308927 0 A 2
17 9861012494 1 A 2
17 9861251159 0 A 2
17 9861444225 0 D 2
13 9827233765 0 A 2
These are basically do not disturb numbers. I want to code for uploading this file, and delete the numbers where the alphabet “D” is there and add the numbers where alphabet “A” is there in the fourth column.
And i also want a code in which i can compare a list of numbers from this database, in which if there alphabet “A” the output of that number is “DND” but if the number is not there in the database the result of that number should be Ok.
I can help out with a website which is similar to to my functionality.
www.dndcheck.in
I had pasted few numbers in the text box and compared these numbers with the above database where all the numbers and DND.
9907655320
9861445262
9861395056
9827772718
9861003374
9827340346
9861037312
9861144351
9861208733
9861308927
9861012494
9861251159
9861444225
9827233765
The result of the numbers are as follows -
Sr No Request Number Processed Number Status Preference Opr Circle
1 9907655320 9907655320 Registered Full RG MP
2 9861445262 9861445262 Registered Full RG OR
3 9861395056 9861395056 Registered Full RG OR
4 9827772718 9827772718 Registered Full RG MP
5 9861003374 9861003374 Registered Full RG OR
6 9827340346 9827340346 Registered Full RG MP
7 9861037312 9861037312 Registered Full RG OR
8 9861144351 9861144351 Registered Full RG OR
9 9861208733 9861208733 Not Registered NA RG OR
10 9861308927 9861308927 Registered Full RG OR
11 9861012494 9861012494 Registered 1 RG OR
12 9861251159 9861251159 Registered Full RG OR
13 9861444225 9861444225 Not Registered NA RG OR
14 9827233765 9827233765 Registered Full RG MP
The numbers which are status of Not Registered these numbers and not there in the database.
Can anyone help me out…
I am not able to figure it out how will i do this…