473,386 Members | 1,835 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Extracting names and phone numbers from web links

tharden3
916 512MB
At work I have to spend all day punching in database entries in microsoft excel. I flip through pages and pages on this website, and on each page there are 50 links. In each link is a profile with contact information. I simply go to the page with the 50 links, click on each link, put the persons phone # and name and address in an excel spreadsheet, and then go on to the next contact. Is there anyway to automate this process? Any program I can use? If you can figure it out, it would make my life a whole bunch easier.
Jul 9 '08 #1
4 1836
jhardman
3,406 Expert 2GB
Most modern programming languages could handle this, the question is, with which languages are you most familiar? You will have to do the implementation.

Jared
Jul 9 '08 #2
tharden3
916 512MB
Most modern programming languages could handle this, the question is, with which languages are you most familiar? You will have to do the implementation.

Jared
The truth is, I am relatively new to programming and only know simple Python and Ruby. Is there software I can purchase? Or maybe some open-source stuff i can download? i could definitely not write anything to help me with my situation. Maybe I could in ten or twelve years, but.... that's a bit long to wait if you catch my drift.
Jul 9 '08 #3
NeoPa
32,556 Expert Mod 16PB
I have to ask why you only have the information available to you via the web.

Is it even information that you have any rights to?

I suggest, if the answer to this is "yes" that you ask your bosses to provide the information in a more easily managed way.

If not, then I'm afraid we cannot (will not) help.
Jul 14 '08 #4
Atli
5,058 Expert 4TB
That was my thought as well. Why would you have to do this via this website?

Odds are that the data you are collecting from this website is in a database somewhere, and those who take care of this database and the website should easily be able to compile this data into a file you could open in Excel.

Could you not simply ask them to do this for you?
Jul 15 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: lecichy | last post by:
Hello Heres the situation: I got a file with lines like: name:second_name:somenumber:otherinfo etc with different values between colons ( just like passwd file) What I want is to extract...
5
by: joemono | last post by:
Hello everyone! First, I appologize if this posting isn't proper "netiquette" for this group. I've been working with perl for almost 2 years now. However, my regular expression knowledge is...
4
by: Eych | last post by:
I have several functions that retrieve information from databases based on the fieldname passed in (e.g. GetValue(dbUsers, userID, "Fax")) what is the best way to not hard-code field names? ...
4
by: Brian Henry | last post by:
I have phone numbers like this in a data table 123-435-1234 1231231234 432.234.2321 they all have different formatting, what I want to do is get them all formatted like this (123) 123-1234
7
by: laredotornado | last post by:
Hi, Does anyone have a cross-browser JS function that validates a US phone number? I consider the following to be valid phone number formats: var p = "5558675309"; var p = "(312) 123-4567";...
9
by: sebzzz | last post by:
Hi, I work at this company and we are re-building our website: http://caslt.org/. The new website will be built by an external firm (I could do it myself, but since I'm just the summer student...
5
by: lim4801 | last post by:
I am currently in doing a program which is given by my tutor: Contemplate that you are working for the phone company and want to sell "special" phone numbers to companies. These phone numbers are...
11
by: brad | last post by:
Crazy question, but has anyone attempted this or seen Python code that does? For example, if a text file contained 'Guido' and or 'Robert' and or 'Susan', then we should return True, otherwise...
7
by: Propoflady | last post by:
My contacts can have as many as five or six phone numbers - is it possible to make a query that puts the name, and each phone number after it on the same line - for this reason I have two tables -...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.