Automate 7 to 8 digit phone number conversion using AutoIT
Recently, as data cleansing exercise I need to convert 7 digit phone number. Well, this because there are old records that still using 7 digit instead of new 8 digit numbers. Lucky, there are freeware converter that can solve my problem.
Below are the sample how the software works.

Now, my big problem is that I have about 120,000 record to convert. As my post title suggest, yes…. i solved it using my simple automate program using AutoIT
As I learn that sharing is caring , here I share how I did it.
Run(”C:\Program Files\HR2000 Software\Telekom 8 Digit\telekom8.exe”, “”,”")
WinWaitActive(”HR2000″)
Open the converter program and wait until the window is activate.
HotKeySet(”{F1}”, “Start”) ;F1 Key
HotKeySet(”{ESC}”, “Pause”);Esc Button - Pause for a while
HotKeySet(”{F4}”, “Close”) ;CLOSE telekom8 apps and autoit instance.
Register hotkey. I did a mistake previously where I don’t have this part. My simple program running more than 24 hours and still not completed.I can’t do my work since my mouse is been taking care by those program.
(remember, i need to loop tru 120,000 records !)
$line = FileReadLine($Inputfile)
Read a source file that contain all the phone number that we want to convert.
Send($phoneNo)
MouseClick(”left”,613,333,1)
…..MouseClickDrag(”left”,360,333,410,333)
Loop through the source file, send phone number to input box and do a mouce click. The position may be differ.You will need to use AutoIt Window Info to get the exact location.
Actually I’m not sure who will benefit from this code.ermm….never mind. just share lar yer.!
Download the source code here. The files has been downloaded times.
Well, I don’t think my code is perfect but it solved my problem.So it is consider ok lah kan.
Kindly let me know and leave a comment if you have try this.

For the record, our staff (thru recommendations from IT guys) have used the software and we can truly say the software is great. Malaysians will benefit using it.
iklan malaysia´s last blog post..++BERITA BAIK! Skim pinjaman RM100,000 secara Islam. Blacklist OK++ (15 / Offering)
Hi,
I have a 7-digit no that needs to be converted to 8-digit for a friend. Can you please help me with it? No is 03-6345828.
I tried Telekom 103 but they can’t help. Googled everywhere but no help.
Thanks - it would be a great help to me.
May
Hi may, I’m soooo sorry since I already format my pc and don’t have backup for that software. I search for that software again but no luck. I will try again and will let you know if I have a good news.
hi may, i manage to get back the software.
Your 8 Digit number is …
62745828
I will upload this software later.
tq banyak-banyak =)
When the source file will uploaded?