[QuatermassX]

I have an immense list of files captured in an Excel spreadsheet. I need to make a hyperlinked HTML file from this.

I can create a nice table, but I'm wondering if there's a search and replace routine that can help me build the links? I need to get this done quickly ...

Here's the unmodified table:

<table border="1" cellpadding="3" cellspacing="3">
<col width="162" />
<col width="174" />
<col width="161" />
<tr height="12">
<td width="162" height="12">croftfm32.1.1.tdxex</td>
<td width="174">croftfm32.1.1.tdxgs</td>
<td width="161">croftfm32.1.1.tdxsp</td>
</tr>
<tr height="12">
<td height="12">croftfm32.1.2a+b.tdxex</td>
<td>croftfm32.1.2a+b.tdxgs</td>
<td></td>
</tr>
<tr height="12">
<td height="12">croftfm32.1.3.tdxex</td>
<td>croftfm32.1.3.tdxgs</td>
<td></td>
</tr>
<tr height="12">
<td height="12">croftfm32.1.4.tdxex</td>
<td>croftfm32.1.4.tdxgs</td>
<td></td>
</tr>
<tr height="12">
<td height="12">croftfm32.1.5.tdxex</td>
<td>croftfm32.1.5.tdxgs</td>
<td></td>
</tr>
<tr height="12">
<td height="12">croftfm32.1.6.tdxex</td>
<td>croftfm32.1.6.tdxgs</td>
<td>croftfm32.1.6.tdxsp</td>
</tr>
<tr height="12">
<td height="12">croftfm32.2.1.tdxex</td>
<td>croftfm32.2.1.tdxgs</td>
<td></td>
</tr>
<tr height="12">
<td height="12">croftfm32.3.1a.tdxex</td>
<td>croftfm32.3.1a.tdxgs</td>
<td>croftfm32.3.1a.tdxsp</td>
</tr>
<tr height="12">
<td height="12">croftfm32.3.1b.tdxex</td>
<td>croftfm32.3.1b.tdxgs</td>
<td></td>
</tr>
<tr height="12">
<td height="12">croftfm32.3.1c.tdxex</td>
<td>croftfm32.3.1c.tdxgs</td>
<td></td>
</tr>
<tr height="12">
<td height="12">croftfm32.3.1d.tdxex</td>
<td>croftfm32.3.1d.tdxgs</td>
<td></td>
</tr>
<tr height="12">
<td height="12">croftfm32.3.1e.tdxex</td>
<td>croftfm32.3.1e.tdxgs</td>
<td></td>
</tr>
</table>

And here's what the first link should look like:

<a href="viewer.htm?tdxex=croftfm32.1.1.tdxex">croftf m32.1.1.tdxex</a>

Any help would be greatly appreciated - I have two hundred of these and I'd rather not cut and past filenames again and again!

Many thanks!

[redJag]

What you need is a regular expression search & replace. You can do that with TextWrangler. Just open your document with the table in TextWrangler, Search menu -> Find. Check the box that says Use Grep. In the top (search) box you'll enter the pattern you want to match. In the bottom (replace) box you enter the pattern to replace with.

You need to be a little more specific about how you want to generate the URLs, but from your example I am thinking you probably want to search for every <TD></TD> pair that has something in it, then take the extension and craft it into the url: <a href="viewer.htm?{EXTENSION}={FILENAME}.{EXTENSION }">{FILENAME}.{EXTENSION}</a>

If that's right try this:
Search for: <td.*>(.+)\.(.+)</td>
Replace with: <a href="viewer.htm?\2=\1.\2">\1.\2</a>