It should be quite easy.
One thing maybe will make it a little easier, get an editor like Note Tab Light that shows end of line too.
Then follow these steps:
1. Copy your text into Note Tab Light as is.
- Code: Select all
Team P W D L F A Pts
Team 1 FC 12 10 1 1 55 12 31
Team 2 FC 10 9 1 0 43 7 28
Team United FC 11 7 1 3 46 12 22
Team RANGERS FC 14 5 5 4 33 24 20
Team City 13 5 2 6 35 36 17
Team TOWN COLTS 12 4 3 5 34 20 15
Team FC 14 4 2 8 25 48 14
Team COLTS. 15 3 2 10 18 67 11
Team WEL TIGERS. 13 1 1 11 11 74 4
2. Make the Teams into a single string by connecting the separate words with an _ (there is method in my madness)
- Code: Select all
Team P W D L F A Pts
Team_1_FC 12 10 1 1 55 12 31
Team_2_FC 10 9 1 0 43 7 28
Team_United_FC 11 7 1 3 46 12 22
Team_RANGERS_FC 14 5 5 4 33 24 20
Team_City 13 5 2 6 35 36 17
Team_TOWN_COLTS 12 4 3 5 34 20 15
Team_FC 14 4 2 8 25 48 14
Team_COLTS. 15 3 2 10 18 67 11
Team_WEL_TIGERS. 13 1 1 11 11 74 4
3. With the REPLACE TEXT function replace " " (empty space) with "</td><td>"
- Code: Select all
Team</td><td>P</td><td>W</td><td>D</td><td>L</td><td>F</td><td>A</td><td>Pts
Team_1_FC</td><td>12</td><td>10</td><td>1</td><td>1</td><td>55</td><td>12</td><td>31
Team_2_FC</td><td>10</td><td>9</td><td>1</td><td>0</td><td>43</td><td>7</td><td>28
Team_United_FC</td><td>11</td><td>7</td><td>1</td><td>3</td><td>46</td><td>12</td><td>22
Team_RANGERS_FC</td><td>14</td><td>5</td><td>5</td><td>4</td><td>33</td><td>24</td><td>20
Team_City</td><td>13</td><td>5</td><td>2</td><td>6</td><td>35</td><td>36</td><td>17
Team_TOWN_COLTS</td><td>12</td><td>4</td><td>3</td><td>5</td><td>34</td><td>20</td><td>15
Team_FC</td><td>14</td><td>4</td><td>2</td><td>8</td><td>25</td><td>48</td><td>14
Team_COLTS.</td><td>15</td><td>3</td><td>2</td><td>10</td><td>18</td><td>67</td><td>11
Team_WEL_TIGERS.</td><td>13</td><td>1</td><td>1</td><td>11</td><td>11</td><td>74</td><td>4
4. With the REPLACE TEXT function replace "^P" (line feed/end of line) with "</td></tr><tr>^P"
- Code: Select all
Team</td><td>P</td><td>W</td><td>D</td><td>L</td><td>F</td><td>A</td><td>Pts</td></tr><tr>
Team_1_FC</td><td>12</td><td>10</td><td>1</td><td>1</td><td>55</td><td>12</td><td>31</td></tr><tr>
Team_2_FC</td><td>10</td><td>9</td><td>1</td><td>0</td><td>43</td><td>7</td><td>28</td></tr><tr>
Team_United_FC</td><td>11</td><td>7</td><td>1</td><td>3</td><td>46</td><td>12</td><td>22</td></tr><tr>
Team_RANGERS_FC</td><td>14</td><td>5</td><td>5</td><td>4</td><td>33</td><td>24</td><td>20</td></tr><tr>
Team_City</td><td>13</td><td>5</td><td>2</td><td>6</td><td>35</td><td>36</td><td>17</td></tr><tr>
Team_TOWN_COLTS</td><td>12</td><td>4</td><td>3</td><td>5</td><td>34</td><td>20</td><td>15</td></tr><tr>
Team_FC</td><td>14</td><td>4</td><td>2</td><td>8</td><td>25</td><td>48</td><td>14</td></tr><tr>
Team_COLTS.</td><td>15</td><td>3</td><td>2</td><td>10</td><td>18</td><td>67</td><td>11</td></tr><tr>
Team_WEL_TIGERS.</td><td>13</td><td>1</td><td>1</td><td>11</td><td>11</td><td>74</td><td>4</td></tr><tr>
5. Now delete the last <tr>
6. Add
- Code: Select all
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="content-type">
<title></title>
</head>
<body>
<table style="text-align: left; width: 75%;" border="1"
cellpadding="2" cellspacing="2">
<tbody>
<tr>
to the top
7. Add
- Code: Select all
</tbody>
</table>
<html>
to the bottom
8. Get rid if the underlines placed in Step 2. and put back the " " spaces (replace again)
- Code: Select all
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="content-type">
<title></title>
</head>
<body>
<table style="text-align: left; width: 75%;" border="1"
cellpadding="2" cellspacing="2">
<tbody>
<tr>
Team</td><td>P</td><td>W</td><td>D</td><td>L</td><td>F</td><td>A</td><td>Pts</td></tr><tr>
Team 1 FC</td><td>12</td><td>10</td><td>1</td><td>1</td><td>55</td><td>12</td><td>31</td></tr><tr>
Team 2 FC</td><td>10</td><td>9</td><td>1</td><td>0</td><td>43</td><td>7</td><td>28</td></tr><tr>
Team United FC</td><td>11</td><td>7</td><td>1</td><td>3</td><td>46</td><td>12</td><td>22</td></tr><tr>
Team RANGERS FC</td><td>14</td><td>5</td><td>5</td><td>4</td><td>33</td><td>24</td><td>20</td></tr><tr>
Team City</td><td>13</td><td>5</td><td>2</td><td>6</td><td>35</td><td>36</td><td>17</td></tr><tr>
Team TOWN COLTS</td><td>12</td><td>4</td><td>3</td><td>5</td><td>34</td><td>20</td><td>15</td></tr><tr>
Team FC</td><td>14</td><td>4</td><td>2</td><td>8</td><td>25</td><td>48</td><td>14</td></tr><tr>
Team COLTS.</td><td>15</td><td>3</td><td>2</td><td>10</td><td>18</td><td>67</td><td>11</td></tr><tr>
Team WEL TIGERS.</td><td>13</td><td>1</td><td>1</td><td>11</td><td>11</td><td>74</td><td>4</td></tr>
</tbody>
</table>
<html>
Now you have perfectly valid table in
HTML
9. Save as whatever.
html