So I saved an Excel file as a tab-separated text file. Then I wanted to add some html. The first column was all numbers followed by a tab and the second column.
I opened the text file in Dreamweaver and put the following in the “Find” box: \n([0-9]+)\t
That says “Look for a line break followed by a subexpression containing at least one numeric character followed by a tab”
I put the following in the Replace box: \n<div class=”col1″>$1</div><div class=”col2″>\t
That says “Replace it with a line break followed by a div tag followed by the subexpression (i.e, the number) followed by a closing div followed by an opening div for col2 followed by a tab”
Then the check the “Use regular expression” checkbox and hit “Replace All”
Quirky behavior noted: I couldn’t do one-at-a-time replacements. It only worked when I did Replace All. So make sure you have a back up handy.
