Extracting Cell Phone Numbers from Random Strings of variable length?

The basic data was basically of the type shown in the following picture.

Basic Data

The interesting thing about cell numbers is that almost all of them are of 10 digits, at least in India. Hence, a very simple logic was used to achieve results, as shown below:

Code Used

The logic being to first detect five consecutive numbers and then check if 10 digits that begin with the first five numbers are forming a valid mobile number.

I am not showing the results here, but it is quite obvious 10 digits representing the cell numbers were successfully extracted.

CA Vikram S. Mathur

15th July 2019 (22:10 Hours IST)

My First Blog Post

There comes a time when we all resort to coding the VBA, just to get some odd task completed, right?

Be yourself; Everyone else is already taken.

— Oscar Wilde.

This is the first post on my new blog. I’m just getting this new blog going, so stay tuned for more. Subscribe below to get notified when I post new updates.

Who is vbacoder1962?

VBCODER1962
CA Vikram Shankar Mathur (aka VBA Coder 1962)

These are just some ideas that I am sharing about what are the few things that I can think of to post on the blog:

  • Basic information about the VBA Programming environment.
  • Creating useful modules for general use.
  • Creating OOP Class modules and how to use them
  • Some examples of how you can code the worksheet itself.
  • How you can manipulate Zip files using the Visual Basic Editor (VBE) – added by @vsmathur-onms on 03-Oct-2019.

Well, that seems to be the only thing that I want to put in my very first post. Do subscribe to my posts below!!

CA Vikram Shankar Mathur (aka VBA Coder 1962)
Last Updated : 03-Dec-2019 | 04:20 Hours IST

<<== Back to Main

20170628 – #Virtual #Visiting #Card

Okay, so, as per the suggestions received, I have #Revised the #Virtual #Visiting card as follows. Hope this one meets the approval of all m friends? Please do comment, I would be highly obliged, if you do. Cheers !!

28-Jun-2017 | 12:09 Hours IST | #CAVSM