Posting HTML

[giacomo]

Why the huge gaps between my tables when I post HTML?
<table border = 1>
<tr><th colspan =3 align = center >tblEvent</th></tr>
<tr><th>eventID</th><th>EventName</th></tr>
<tr><td>1</td><td>Some Race</td></tr>
<tr><td>2</td><td>Some Other Race</tr>
<tr><td>3</td><td>Yet Another Race</td></tr>
</table>
<table border = 1>
<tr><th colspan =3 align = center >tblName</th></tr>
<tr><th>RacerID</th><th>Name</th></tr>
<tr><td>1</td><td>John</td></tr>
<tr><td>2</td><td>Paul</tr>
<tr><td>3</td><td>George</td></tr>
<tr><td>4</td><td>Ringo</td></tr>
</table>
<table border = 1>
<tr><th colspan =3 align = center >tblRacerEventJoin</th></tr>
<tr><th>EventID</th><th>RacerID</th><th>Placement</th></tr>
<tr><td>1</td><td>1</td><td>3</td></tr>
<tr><td>1</td><td>2</td><td>1</td></tr>
<tr><td>1</td><td>3</td><td>2</td></tr>
<tr><td>2</td><td>1</td><td>1</td></tr>
<tr><td>2</td><td>3</td><td>2</td></tr>
<tr><td>2</td><td>4</td><td>3</td></tr>
<tr><td>3</td><td>2</td><td>1</td></tr>
<tr><td>3</td><td>3</td><td>2</td></tr>
<tr><td>3</td><td>4</td><td>3</td></tr>
<tr><td>4</td><td>1</td><td>3</td></tr>
<tr><td>4</td><td>2</td><td>2</td></tr>
<tr><td>4</td><td>4</td><td>1</td></tr>
</table>

<table border = 1>
<tr><th colspan =3 align = center >tblEvent</th></tr>
<tr><th>eventID</th><th>EventName</th></tr> 
<tr><td>1</td><td>Some Race</td></tr>
<tr><td>2</td><td>Some Other Race</tr>
<tr><td>3</td><td>Yet Another Race</td></tr> 
</table>
<table border = 1>
<tr><th colspan =3 align = center >tblName</th></tr>
<tr><th>RacerID</th><th>Name</th></tr>
<tr><td>1</td><td>John</td></tr> 
<tr><td>2</td><td>Paul</tr>
<tr><td>3</td><td>George</td></tr>
<tr><td>4</td><td>Ringo</td></tr>
</table> 
<table border = 1>
<tr><th colspan =3 align = center >tblRacerEventJoin</th></tr>
<tr><th>EventID</th><th>RacerID</th><th>Placement</th></tr>
<tr><td>1</td><td>1</td><td>3</td></tr> 
<tr><td>1</td><td>2</td><td>1</td></tr>
<tr><td>1</td><td>3</td><td>2</td></tr>
<tr><td>2</td><td>1</td><td>1</td></tr> 
<tr><td>2</td><td>3</td><td>2</td></tr>
<tr><td>2</td><td>4</td><td>3</td></tr>
<tr><td>3</td><td>2</td><td>1</td></tr> 
<tr><td>3</td><td>3</td><td>2</td></tr>
<tr><td>3</td><td>4</td><td>3</td></tr>
<tr><td>4</td><td>1</td><td>3</td></tr> 
<tr><td>4</td><td>2</td><td>2</td></tr>
<tr><td>4</td><td>4</td><td>1</td></tr>
</table>

Giacomo

 

[Norie]

giacomo

It's because the HTML code is all on different lines.

<table border = 1><tr><th colspan =3 align = center >tblEvent</th></tr><tr><th>eventID</th><th>EventName</th></tr><tr><td>1</td><td>Some Race</td></tr><tr><td>2</td><td>Some Other Race</tr><tr><td>3</td><td>Yet Another Race</td></tr></table><table border = 1><tr><th colspan =3 align = center >tblName</th></tr><tr><th>RacerID</th><th>Name</th></tr><tr><td>1</td><td>John</td></tr><tr><td>2</td><td>Paul</tr><tr><td>3</td><td>George</td></tr><tr><td>4</td><td>Ringo</td></tr></table><table border = 1><tr><th colspan =3 align = center >tblRacerEventJoin</th></tr><tr><th>EventID</th><th>RacerID</th><th>Placement</th></tr><tr><td>1</td><td>1</td><td>3</td></tr><tr><td>1</td><td>2</td><td>1</td></tr><tr><td>1</td><td>3</td><td>2</td></tr><tr><td>2</td><td>1</td><td>1</td></tr><tr><td>2</td><td>3</td><td>2</td></tr><tr><td>2</td><td>4</td><td>3</td></tr><tr><td>3</td><td>2</td><td>1</td></tr><tr><td>3</td><td>3</td><td>2</td></tr><tr><td>3</td><td>4</td><td>3</td></tr><tr><td>4</td><td>1</td><td>3</td></tr><tr><td>4</td><td>2</td><td>2</td></tr><tr><td>4</td><td>4</td><td>1</td></tr></table>

 

[giacomo]

Norie,

Can you post the html you used?? Cause I'm still not getting it

G

 

[giacomo]

oh, nevermind I got it now... it's kinda ugly when you do it that way though...

 

[Norie]

giacomo

I just removed the line breaks from your HTML.

At one time I actually had code that did that automatically but I lost it when I had to totally reboot my computer some time ago.

 

[giacomo]

I just removed the line breaks from your HTML.

yep, that's what I ended up doing... at first I thought you meant just the line breaks between the < /table > and < table > statements. But then I realized I had to take them all out.

Thanks for your help, I went back and cleaned up the post that this all refers to and gave you your props: http://www.mrexcel.com/board2/viewtopic.php?t=226454&start=10

G

 

[Von Pookie]

At one time I actually had code that did that automatically but I lost it when I had to totally reboot my computer some time ago.

There used to be a site up that would strip out the breaks, but it's dead. I managed to bring it up with the webarchive and snagged the (open source) code for it.

I have never really advertised this, but I currently have the code up--and running--here:
http://vonpookie.t35.com/excel/newlines.php

It's not pretty, but it should work.

 

[Norie]

Kristy

I think I've come across that before.

The code I had was, I think, totally run from Excel, or was it Access.

Like I said it was some time ago I wrote/used it, and then I lost it.