Solved

How to extract data from resume board.

Posted on 2006-06-21
9
500 Views
Last Modified: 2010-04-17
Hey guys,

My company has purchased access to a resume board with over 10,000 resumes.  The resumes are stored on their server in the format of "http://[Domain]/EmpResume.asp?ResumeID=x" where x = a resume ID number (somewhere between 1 and 10000).  Once you have logged in once, you can navigate to any resume you wish by just changing "x" in the url.

I need to find a way extracting the data from each resume in to a table or database.  The data appears on the web site in a structured table, so the data is always in the same place on each resume.

Since there are so many, I would need this as automated as possible.

Thanks,
Grant
0
Comment
Question by:gtporter
  • 5
  • 4
9 Comments
 
LVL 15

Expert Comment

by:bpmurray
ID: 16952466
You don't say what machine you're working on, nor how the resumes are returned. Your biggest issue is trying to parse the HTML that's returned. There are a bunch of libraries you could use, but I'd simply use a Web page that has its fields bound to the database. Using a hidden iFrame, you can loop through the resumes (set src="url"), and then pull the information from the various fields to populate the local fields, do a submit, and loop to get the next.

All this can be done using Javascript, along with whatever you use to access your DB on the backend (.Net/PHP/Java/whatever), so you can have a visual feedback of what it's doing.
0
 
LVL 15

Expert Comment

by:bpmurray
ID: 16952489
I should have said that you could of course read the HTML using an HTML library, e.g. http://www.codeproject.com/library/GomzyHTMLReader.asp, and then update the DB directly.
0
 

Author Comment

by:gtporter
ID: 16952789
I'm not looking for anything that complicated because I do not have much expierence in C++ or programming in general.  I am looking for a possible unicorn of a program.  Something that I can open a sample document (IE http://[Domain]/EmpResume.asp?ResumeID=1) and tell it what fields in the table I wish to save to specific fields in a database or excel document.  Is this a program that doesn't exist or am I just googleing the wrong things?
0
 
LVL 15

Expert Comment

by:bpmurray
ID: 16953085
OK, try importing one of the pages into Excel, and see how it looks. If the stuff loads consistently, you can process it from there, pushing the cell contents into the DB using Excel's database connectivity. This is essentally the same model as above, but using Excel as the HTML parser.

If you post a sample page (replace the specific content, of course), I can get a better idea of what might be possible.

BTW, is this on windows? The reason is that many Unixes have standard commands that make this kind of thing much easier.
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

Author Comment

by:gtporter
ID: 16953209
I am using Windows XP Pro.  I'll try the Excel idea after lunch and post on how it went (I like the concept though).

Sample code for ResumeID 1:


<noscript><meta http-equiv="refresh" content="0;url=/unsupported.asp?URL=/EmpResume.asp?ResumeID=1"></noscript>

<html>
<head>
<title>[--(First Name)--]&nbsp;[--(Last Name)--] - Engineering Resume from EngCen.com</title>
<link rel="stylesheet" type="text/css" href="include/engcen.css">
<script language="javascript">
function ReviseSearch()
{
      if(document.form1.formtype.value=="advance")
      {
            document.form1.action = "AdvResSearch.asp";
      }
      else
      {
            document.form1.action = "ResumeSearch.asp";
      }      
      document.form1.submit();
}

function saveresume(rid)
{
  document.form1.action="StoreResume.asp?ResumeID="+rid;
  document.form1.method="post";
  document.form1.submit();
 
 
}

</script>
<body>
<div align="center">
<center>

<table border="0" width="90%" border="0" cellpadding="6"  bordercolor="#111111" cellspacing="0"><tr>
<td class="text">

<center>
<p><a href=index.asp>
<img alt="Engineering Central - Engineering jobs resumes chemical manufacturing electrical civil
mechanical ENGINEERS" src="images/logo.jpg" border="0" width="231" height="84"></a></p>
</center><hr SIZE="1" color="#000000">
<p align="center"><strong><font face="Trebuchet MS" size=2>EngCen.com - Engineering Resume</font> - <font face='Trebuchet MS' size=2 color='#FF0000'>You have seen this resume before</font></strong> </p><P>

<ul style="font-size: 13px; font-family: verdana, arial">
  <li>
  <font face="Trebuchet MS" size=2>
  <a href="ResumeSearch.asp">Do a new search</a></li>
  <li>
  <a href="javascript:ReviseSearch();">Revise this search</a></li>
  <li>
  <a href="javascript:saveresume(1)">Save this resume</a></li>
  <li><a href="EmailCandidate.asp?ResumeID=1">Email this candidate</a></li>
  <li>
  <a href="javascript:window.history.back();">Back to results</a></li>
  <li>
  <a href="EmpAccountPage.asp">Your Account Page</a></li>
  <li><a href="db/reshelp.asp">Resume Database Help</a></font></li>
</ul>
  </font>
<div align="center">
  <center>



<form name="form1" action="RunResultsList.asp" method="post">
<input type="hidden" name="keywords" value="">
<input type="hidden" name="searchfor" value="">
<input type="hidden" name="country" value="">
<input type="hidden" name="areacode" value="">
<input type="hidden" name="citizenship" value="">
<input type="hidden" name="state" value="">
<input type="hidden" name="city" value="">
<input type="hidden" name="degree" value="">
<input type="hidden" name="certification" value="">
<input type="hidden" name="datemodified" value="">
<input type="hidden" name="odrfld" value="">
<input type="hidden" name="odrby" value="">
<input type="hidden" name="cPage" value="">

<input type="hidden" name="fname" value="">
<input type="hidden" name="lname" value="">
<input type="hidden" name="phone" value="">
<input type="hidden" name="email" value="">
<input type="hidden" name="daterange1" value="">
<input type="hidden" name="daterange2" value="">
<input type="hidden" name="relocation" value="">
<input type="hidden" name="expyears" value="">
<input type="hidden" name="salary" value="">
<input type="hidden" name="contract" value="">
<input type="hidden" name="formtype" value="">
 
<table border="1"  cellpadding="4" cellspacing="0" style="border-width:0; border-collapse: collapse; " bordercolor="#111111" id="table1" width="100%">
  <tr>
    <td width="50%" colspan="2" align="center" class="text">
        <font face="Trebuchet MS" size=2><b>Personal Information</b></font></td>
   
    <td width="2%" align="center" class="text">&nbsp;</td>
  </font>
    <td width="50%" colspan="2" align="center" class="text">
    <font face="Trebuchet MS" size=2>
        <b>Employment Details</b></font></td>
  </tr>
  <tr>
    <td width="25%" class="text"><b>
    <font face="Trebuchet MS" size=2>Name:</font></b></td>
    <td width="25%" class="text">
    <font face="Trebuchet MS" size=2>[--(First Name)--]&nbsp;[--(Last Name)--]</font></td>
    <td width="1%" class="text">&nbsp;</td>
    <td width="24%" class="text">
    <font face="Trebuchet MS" size=2><b>Type of Degree:</b></font></td>
    <td width="25%" class="text">
    <font face="Trebuchet MS" size=2>BS Chemical Engineering,<br>MS Environmental Engineering</font></td>
  </tr>
  <tr>
    <td width="25%" class="text"><b>
    <font face="Trebuchet MS" size=2>Email:</font></b></td>
    <td width="25%" class="text">
    <font face="Trebuchet MS" size=2>
       
            <a href="[--(Email Address)--]?subject=Resume Seen on Engineering Central (www.engcen.com)">[--(Email Address)--]</a>
     
   </font></td>
    <td width="1%" class="text">&nbsp;</td>
    <td width="24%" class="text"><b>
    <font face="Trebuchet MS" size=2>Years Experience:</font></b></td>
    <td width="25%" class="text">
    <font face="Trebuchet MS" size=2>0-2 Years</font></td>
  </tr>
  <tr>
    <td width="25%" class="text"><b>
    <font face="Trebuchet MS" size=2>Phone:</font></b></td>
    <td width="25%" class="text">
    <font face="Trebuchet MS" size=2>
    [--(Phone Number)--]
    </font></td>
    <td width="1%" class="text">&nbsp;</td>
    <td width="24%" class="text">
    <font face="Trebuchet MS" size=2><b>Target Salary:</b></font></td>
    <td width="25%" class="text">
    <font face="Trebuchet MS" size=2>$40,000-$50,000</font></td>
  </tr>
  <tr>
    <td width="25%" class="text"><b>
    <font face="Trebuchet MS" size=2>City:</font></b></td>
    <td width="25%" class="text">
    <font face="Trebuchet MS" size=2>[--(City)--]&nbsp;</font></td>
    <td width="1%" class="text">&nbsp;</td>
    <td width="24%" class="text">
    <font face="Trebuchet MS" size=2><b>Certifications Held:</b></font></td>
    <td width="25%" class="text">
    <font face="Trebuchet MS" size=2>None</font></td>
  </tr>
  <tr>
    <td width="25%" class="text"><b>
    <font face="Trebuchet MS" size=2>State:</font></b></td>
    <td width="25%" class="text">
    <font face="Trebuchet MS" size=2>[--(State)--]</font></td>
    <td width="1%" class="text">&nbsp;</td>
    <td width="24%" class="text">
    <font face="Trebuchet MS" size=2><b>Relocation:</b></font></td>
    <td width="25%" class="text">
    <font face="Trebuchet MS" size=2>Anywhere</font></td>
  </tr>
  <tr>
    <td width="25%" class="text"><b>
    <font face="Trebuchet MS" size=2>Country:</font></b></td>
    <td width="25%" class="text">
    <font face="Trebuchet MS" size=2>USA</font></td>
    <td width="1%" class="text">&nbsp;</td>
    <td width="24%" class="text">
    <font face="Trebuchet MS" size=2><b>Contract Work?</b></font></td>
    <td width="25%" class="text">
    <font face="Trebuchet MS" size=2>Yes</font></td>
  </tr>
  <tr>
    <td width="25%" class="text"><b>
    <font face="Trebuchet MS" size=2>Citizenship / Visa Status:</font></b></td>
    <td width="25%" class="text">
    <font face="Trebuchet MS" size=2>US Citizen</font></td>
    <td width="1%" class="text">&nbsp;</td>
    <td width="24%" valign="top" class="text"><b>
    <font face="Trebuchet MS" size=2>Resume Date</font></b><font size="2" face="Verdana"><b>:</b></font></td>
    <td width="25%" valign="top" class="text">
    <font face="Trebuchet MS" size=2>May 10, 2006</font></td>
  </tr>
  </table>
<div align="center">
  <center>
<table cellPadding="4" border="0"  bordercolor="#111111" width="100%" id="table2">
  <tr>
    <td width="100%">
    <p align="center"><font face="Trebuchet MS" size=2><br>
    <b>Professional Qualifications</b></font></p>
    <table border="1" cellpadding="4" cellspacing="0" style="border-width:0; border-collapse: collapse; " bordercolor="#111111" width="100%" id="table3">
      <tr>
        <td width="19%" valign="top" class="text"><b><font face="Trebuchet MS" size=2>Short
        Description:</font></b></td>
        <td width="81%" valign="top" class="text"><font face="Trebuchet MS" size=2>Environmental engineer with Masters Degree.  Willing to travel and/or relocate.</font></td>
      </tr>
      <tr>
        <td width="19%" valign="top" class="text"><b><font face="Trebuchet MS" size=2>
        Education:</font></b></td>
        <td width="81%" valign="top" class="text"><font face="Trebuchet MS" size=2><P>EDUCATION</P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><SPAN><FONT size=3>Masters of Science in Civil and Environmental Engineering, Expected: August 2006<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></FONT></SPAN></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><FONT size=3><?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" /><st1:PlaceType w:st="on"><SPAN lang=EN-GB style="FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt">University</SPAN></st1:PlaceType><SPAN lang=EN-GB style="FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt"> of <st1:PlaceName w:st="on">[--(City)--]</st1:PlaceName>, <st1:place w:st="on"><st1:City w:st="on">[--(City)--]</st1:City> <st1:State w:st="on">PA</st1:State></st1:place><o:p></o:p></SPAN></FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><SPAN lang=EN-GB style="FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt"><FONT size=3>GPA: 3.7</FONT></SPAN></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><SPAN lang=EN-GB style="FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt"></SPAN>&nbsp;</P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><SPAN lang=EN-GB style="FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt"></SPAN><FONT size=3>Bachelor of Science in Chemical Engineering, May 2002</FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><FONT size=3>Rensselaer Polytechnic Institute, Troy NY </FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><FONT size=3></FONT>&nbsp;</P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><FONT size=3>Courses taken include:</FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><FONT size=3>Environmental Processes I, II</FONT></P><FONT size=3><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><FONT size=3>Environmental Microbiology</FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><FONT size=3>Environmental Impact Assessment</FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in">Kinetics and Catalysis</FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><FONT size=3>Transport Phenomena</FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><FONT size=3>Advanced Thermodynamics</FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><FONT size=3>Introduction to Environmental Engineering</FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><FONT size=3>Organic Chemistry </FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><FONT size=3>Separation Processes </FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><FONT size=3>Experimental Chemistry </FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><FONT size=3>Chemical Engineering Laboratory I, II</FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><FONT size=3>Molecular Separations Engineering</FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><FONT size=3>Chemical Process Design</FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in"><FONT size=3></FONT>&nbsp;</P></font></td>
      </tr>
      <tr>
        <td width="19%" valign="top" class="text"><b><font face="Trebuchet MS" size=2>
        Description:</font></b></td>
        <td width="81%" valign="top" class="text"><font face="Trebuchet MS" size=2><P><FONT size=3>RELEVANT EXPERIENCE</FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in; tab-stops: 81.0pt"><SPAN><FONT size=3>Water Treatment Plant Intern, July 2005&nbsp;- Oct 2005</FONT></SPAN></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in; tab-stops: 81.0pt"><SPAN lang=EN-GB style="FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt"><FONT size=3><?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" /><st1:City w:st="on">[--(City)--]</st1:City> Water and Sewer Authority, <st1:place w:st="on"><st1:City w:st="on">[--(City)--]</st1:City>, <st1:State w:st="on">PA</st1:State></st1:place></FONT></SPAN></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in; tab-stops: 81.0pt"><SPAN lang=EN-GB style="FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt"><FONT size=3><st1:place w:st="on"><st1:State w:st="on"></st1:State></st1:place></FONT></SPAN><FONT face=Arial><FONT size=3><SPAN lang=EN-GB style="FONT-SIZE: 11pt; FONT-FAMILY: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol"><SPAN style="mso-list: Ignore">• </SPAN></SPAN><SPAN lang=EN-GB style="FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt">Develop matrix spikes for analysis with HAPSITE GC/MS to determine matrix effects in detecting various organics.</SPAN></FONT></FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in; tab-stops: 81.0pt"><FONT face=Arial><FONT size=3><SPAN lang=EN-GB style="FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt"></SPAN></FONT></FONT><FONT face=Arial><FONT size=3><SPAN lang=EN-GB style="FONT-SIZE: 11pt; FONT-FAMILY: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol"><SPAN style="mso-list: Ignore">• </SPAN></SPAN><SPAN lang=EN-GB style="FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt">Provide support in performing wet chemistry for daily analysis of water samples, including pH, turbidity, and alkalinity and hardness titrations.</SPAN></FONT></FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in; tab-stops: 81.0pt"><FONT face=Arial><FONT size=3><SPAN lang=EN-GB style="FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt"></SPAN></FONT></FONT><FONT face=Arial><FONT size=3><SPAN lang=EN-GB style="FONT-SIZE: 11pt; FONT-FAMILY: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol"><SPAN style="mso-list: Ignore">• </SPAN></SPAN><SPAN lang=EN-GB style="FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt">Assist in monthly cleaning and calibration of turbidometers.</SPAN></FONT></FONT></P><BR>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -1in; tab-stops: 81.0pt"><FONT face=Arial><FONT size=3><SPAN lang=EN-GB style="FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt"></SPAN></FONT></FONT><FONT face=Arial><FONT size=3><SPAN lang=EN-GB style="FONT-SIZE: 11pt; FONT-FAMILY: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol"><SPAN style="mso-list: Ignore">• </SPAN></SPAN><SPAN lang=EN-GB style="FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt">Experience with daily sample collection throughout water treatment plant.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></FONT></FONT></P><BR>
<P><BR><FONT size=3>Engineering Intern, June 2000 - August 2000<BR>PPG Industries, Inc., Photochromics Division, Monroeville PA <BR>• Support position in Process Development group.<BR>• Established baseline operating parameters and wrote user manual <BR>for RC1.<BR>• Researched heats of crystallization and studied thermodynamic<BR>effects on yield and purity for final and intermediate dye products <BR>using RC1 calorimeter.<BR>• Tracked division inventory using MAX ERP software.<BR>• Laboratory experience in preparing and running small-scale and <BR>scale-up reactions, running HPLC samples to track reaction <BR>progress, and preparing product samples for quality control.<BR><BR>OTHER EXPERIENCE</FONT><BR><FONT size=3>Research Specialist, Jan - Aug 2001, Summer 1999<BR>University of [--(City)--] Medical Center, [--(City)--] PA<BR>• Experience in creating, organizing, and documenting raw data sets,<BR>including the cleaning of raw data files.<BR>• Developed and maintained integrity of Access databases to track<BR>participant information and data and took responsibility for data-<BR>related problems.<BR>• Created and presented training manual to study’s interviewers.<BR>• Provided clerical, administrative, and technical assistance to<BR>principal investigators and data coordinator.<BR><BR>SKILLS</FONT></P><BR>
<P><SPAN lang=EN-GB style="FONT-WEIGHT: normal; FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt"><FONT size=3>•<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>Advanced knowledge of Windows 95/98/2000/NT/XP, DOS, Macintosh, and Unix operating systems, Microsoft Office Suite (Excel, Word, Access, PowerPoint), Microsoft Visual C++, Matlab, Maple</FONT></SPAN></P><BR>
<P><SPAN lang=EN-GB style="FONT-WEIGHT: normal; FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt"></SPAN><SPAN lang=EN-GB style="FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt"><FONT size=3>•<SPAN style="mso-spacerun: yes">&nbsp; Experience with </SPAN>HPLC, NMR, IR, GC, and AA analysis, pH meters, refractometers, RC1, PCR</FONT></SPAN></P><BR>
<P><SPAN lang=EN-GB style="FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt"></SPAN><SPAN lang=EN-GB style="FONT-SIZE: 11pt; mso-bidi-font-size: 12.0pt"><FONT size=3>•<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>Proficient in spoken and written French</FONT></SPAN></P><BR>
<P><BR><FONT size=3>ACTIVITIES<BR>• Dean's List, 5 semesters<BR>• Social and Recruitment Chair, Psi Upsilon Fraternity<BR>• Volunteer, East End Food Co-op<BR></FONT></P></font></td>
      </tr>
    </table>
    </td>
  </tr>
</table>

  </center>
</div>

  </center>
</div>


<ul style="font-size: 13px; font-family: verdana, arial">
  <li>
  <font face="Trebuchet MS" size=2>
  <a href="ResumeSearch.asp">Do a new
  search</a></li>
  <li><a href="javascript:ReviseSearch();">Revise this search</a></li>
  <li><a href="StoreResume.asp?ResumeID=1">Save this resume</a></li>
  <li><a href="EmailCandidate.asp?ResumeID=1">Email this candidate</a></li>
  <li><a href="javascript:document.form1.submit();">Back to results</a></li>
  <li><a href="EmpAccountPage.asp">Your Account Page</a></li>
  <li><a href="db/reshelp.asp">Resume Database Help</a></font></li>
</ul>
  </font>
</p>
  </font>
</table></center>


<hr size=1>
<p align="center" class="text"><font face="Trebuchet MS" size="2">Copyright © 2006, Engineering Central<br>
&nbsp;</font></p>


</body>
</html>
0
 

Author Comment

by:gtporter
ID: 16953221
... I replaced the personal iformation with [--(....)--] tags.  This information was in the source as plian text.
0
 
LVL 15

Accepted Solution

by:
bpmurray earned 500 total points
ID: 16953769
It's actually pretty straightforward ... something like this. Watch out - if some of the fields are filled with a lot of information, an extra row is inserted, so for this particular example "Name:" is on A21 instead of A22. I think a little experimentation is required :-(

Sub LoadAndProcess(Ix)
    Workbooks.Open Filename:="http://[Domain]/EmpResume.asp?ResumeID=" + Ix
    Bump = 0 ' In case it loads into two rows instead of one
   
    ' Get the name
    If Range("A21").Value = "" Then
       rangeName = "C21:C22"
    Else
       rangeName = "C21"
       Bump = 1
    End If
    For Each n In Range(rangeName)
       resumeName = resumeName + n.Value
    Next n
     
    ' Degree type
    If Bump = 1 Then
        rangeName = "F21"
    Else
        rangeName = "F21:F22"
    End If
    For Each n In Range(rangeName)
        degreeName = degreeName + n.Value
    Next n
       
    ' and so on

End Sub
0
 

Author Comment

by:gtporter
ID: 16953920
I'll give that a shot.  Thanks.  I'll post the resluts.
0
 

Author Comment

by:gtporter
ID: 16971718
Well, I got together with out VB.NET programmer and he worked out an app to extract the data... I think...

Thanks, bpmurray, for your input anyway.

Since you were the only one who responded, you get the points.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
wordsWithout 49 79
changePi Challenge 15 76
WMI, model #, retrieving information 10 91
word0 challenge 4 53
This article will show, step by step, how to integrate R code into a R Sweave document
A short article about problems I had with the new location API and permissions in Marshmallow
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now