Hello,
I have a database of contacts (2000+) which are entered in column format as under:
<table style="border-collapse: collapse; width: 360pt;" border="0" cellpadding="0" cellspacing="0" width="479"><col style="width: 244pt;" width="325"> <col style="width: 116pt;" width="154"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; width: 244pt;" width="325" height="20">Address</td> <td style="width: 116pt;" width="154">Main Road</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">City</td> <td>Chennai</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Company Name</td> <td>New India Industries</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Contact Person</td> <td>Mr. Ramesh</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">E-Mail</td> <td class="xl67">ramesh482@gmail.com</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Telephone</td> <td align="right">583205923</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">
</td> <td>
</td> </tr> <tr style="height: 30pt;" height="40"> <td class="xl66" style="height: 30pt; width: 244pt;" width="325" height="40">Address</td> <td>M G Road</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">City</td> <td>Hyderabad</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Company Name</td> <td>Senthil Enterprise</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Fax</td> <td>Mr. Senthil</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Products</td> <td>Chemicals</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; width: 244pt;" width="325" height="20">Address</td> <td>Kalka Cross Roads</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">City</td> <td>Delhi</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Company Name</td> <td>Jagtar Enterprises</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Contact Person</td> <td>Mr. Singh</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">MFG / Service</td> <td>Automobile Products</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Telephone</td> <td align="right">79104923</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">
</td> <td>
</td> </tr> <tr style="height: 30pt;" height="40"> <td class="xl66" style="height: 30pt; width: 244pt;" width="325" height="40">Address</td> <td>Rogerie Complex - 2</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">City</td> <td>Mumbai</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Company Name</td> <td>Alang Enterprises</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Contact Person</td> <td>Ms. Debby</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">E-Mail</td> <td class="xl67">alantent@gmail.com</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Fax</td> <td align="right">202935929</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Products</td> <td>Wood Products</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Telephone</td> <td align="right">59291502</td> </tr> </tbody></table>
The problem with above data is that the contents of each contact details are not uniform as some doesn't have email, some doesn't have product details. Each contact is separated by a blank line
What I am looking at is to have these 2000 odd contact details in proper row format as under
Contact Person, Company Name, Address, City, Telephone, Fax, Email, Prodcuts.
For records which doesn't have data, it can show as blank.
Request for a solution to such a problem
Regards
Paresh
I have a database of contacts (2000+) which are entered in column format as under:
<table style="border-collapse: collapse; width: 360pt;" border="0" cellpadding="0" cellspacing="0" width="479"><col style="width: 244pt;" width="325"> <col style="width: 116pt;" width="154"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; width: 244pt;" width="325" height="20">Address</td> <td style="width: 116pt;" width="154">Main Road</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">City</td> <td>Chennai</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Company Name</td> <td>New India Industries</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Contact Person</td> <td>Mr. Ramesh</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">E-Mail</td> <td class="xl67">ramesh482@gmail.com</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Telephone</td> <td align="right">583205923</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">
</td> <td>
</td> </tr> <tr style="height: 30pt;" height="40"> <td class="xl66" style="height: 30pt; width: 244pt;" width="325" height="40">Address</td> <td>M G Road</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">City</td> <td>Hyderabad</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Company Name</td> <td>Senthil Enterprise</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Fax</td> <td>Mr. Senthil</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Products</td> <td>Chemicals</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; width: 244pt;" width="325" height="20">Address</td> <td>Kalka Cross Roads</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">City</td> <td>Delhi</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Company Name</td> <td>Jagtar Enterprises</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Contact Person</td> <td>Mr. Singh</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">MFG / Service</td> <td>Automobile Products</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Telephone</td> <td align="right">79104923</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">
</td> <td>
</td> </tr> <tr style="height: 30pt;" height="40"> <td class="xl66" style="height: 30pt; width: 244pt;" width="325" height="40">Address</td> <td>Rogerie Complex - 2</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">City</td> <td>Mumbai</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Company Name</td> <td>Alang Enterprises</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Contact Person</td> <td>Ms. Debby</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">E-Mail</td> <td class="xl67">alantent@gmail.com</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Fax</td> <td align="right">202935929</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Products</td> <td>Wood Products</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 244pt;" width="325" height="20">Telephone</td> <td align="right">59291502</td> </tr> </tbody></table>
The problem with above data is that the contents of each contact details are not uniform as some doesn't have email, some doesn't have product details. Each contact is separated by a blank line
What I am looking at is to have these 2000 odd contact details in proper row format as under
Contact Person, Company Name, Address, City, Telephone, Fax, Email, Prodcuts.
For records which doesn't have data, it can show as blank.
Request for a solution to such a problem
Regards
Paresh