regular expression to return specified colums values

i have this body of html text, bellow in snipt code, i need by using regular expression in .net to get this values of :
1.applicant name
2.badge number
3.network account
4.departement name
5.cost center
6. extention
7.bleeb
8.email

regares
<style>
body{FONT-FAMILY: Times New Roman,sans-serif;FONT-SIZE: 0.8em;}
</style>
<table cellSpacing=0 cellPadding=4 width=90% border=0>
<tr>
<td>Dear Helpdesk Agent,
<br>
<br>Please escalate the FAX user request below to FAX administrator in your site.
<br>
<br>User Details:
</td>
 
</tr>
</table>
<table cellSpacing=0 cellPadding=4 width=70% border=1 bordercolor=#ffefd5>
<tr>
<td>
 
<table width=100% cellSpacing=4 cellPadding=2 border=0>
<tr>
<td width=50% bgcolor='#f8f8ff'>Applicant name
</td>
<td width=50%>Medical Education
</td>
 
</tr>
<tr>
<td width=50% bgcolor='#f8f8ff'>Badge No. or Department Network Account
</td>
<td width=50%>mededu1@ngha.med.sa
</td>
 
</tr>
<tr>
<td width=50% bgcolor='#f8f8ff'>Network Account
</td>
<td width=50%>NGHA
</td>
 
</tr>
<tr>
<td width=50% bgcolor='#f8f8ff'>Department Name
</td>
<td width=50%>Postgraduate Education 
& Academic Affairs
</td>
 
</tr>
<tr>
<td width=50% bgcolor='#f8f8ff'>Cost Centre Code
</td>
<td width=50%>9667
</td>
 
</tr>
<tr>
<td width=50% bgcolor='#f8f8ff'>Extesnsion
</td>
<td width=50%>13364
</td>
 
</tr>
<tr>
<td width=50% bgcolor='#f8f8ff'>Bleep
</td>
<td width=50%>3364
</td>
 
</tr>
<tr>
<td width=50% bgcolor='#f8f8ff'>Email
</td>
<td width=50%>jebrens@ngha.med.sa
</td>
 
</tr>
</table>

Open in new window

baghlafAsked:
Who is Participating?
 
mankowitzConnect With a Mentor Commented:
In your example, where would applicant name go? For that one, you have

<tr>
<td width=50% bgcolor='#f8f8ff'>Applicant name
</td>
<td width=50%>Medical Education
</td>

While the rest of them are formatted differently.

In any event, you would want something like this (in VB)

Dim pattern As String = "<td width=50% bgcolor='#f8f8ff'>Bleep\n</td>\n<td width=50%>(\d+)\n</td>"
dim bleep as string = Regex.Match( HTMLstring, pattern ).Groups(0).ToString() )

and repeat for each item you want.




0
 
baghlafAuthor Commented:
i need for exampel, for applicant name to return in my example ""Medical Eduction'" and for Bleep i return 3364, and so on for other values,

regards.
0
 
baghlafAuthor Commented:
okay,
i have solved the problem which is:
<td width=50%>(?<Name>.*?)\<

this pattern go okay for my issue..

regards.
0
 
mankowitzCommented:
ok, but I did provide a solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.