On Dec 13, 2016, at 08:51, Peter White <[email protected] 
<mailto:[email protected]>> wrote:
> Here's one row of the table after being saved by Excel as .html.


Hey Peter,

This is helpful, but it's not a big enough data sample.

For instance there is no way to tell if your part number has a consistent 
format.

And there may be other unexpected pitfalls.

Here's a quick-and-dirty pattern that works with the data you posted.

Find:

(<td.+?>)(TAX\d+EXT\w+)(</td>\n.+?</td>)(\n.*?<td.+?)\$\d+\.\d+</td>

Replace:

\1\2\3\4$<?php displayPrice("\2") ?></td>

I would want to see a much bigger data sample, before I did something for real.

--
Best Regards,
Chris

-- 
This is the BBEdit Talk public discussion group. If you have a 
feature request or would like to report a problem, please email
"[email protected]" rather than posting to the group.
Follow @bbedit on Twitter: <http://www.twitter.com/bbedit>
--- 
You received this message because you are subscribed to the Google Groups 
"BBEdit Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/bbedit.

Reply via email to