It might be easier to put your PHP code in a cell in the Excel spreadsheet.
Define a new column with "<?php displayPrice(\"\\2\") ?>" as its value and
export it so your table contains that code from the outset.
[fletcher]
> On Dec 19, 2016, at 10:49 AM, Peter White <peterjwh...@gmail.com> wrote:
>
> Hi Chris,
>
> Sorry I'm so slow responding.
>
> This isn't working. I don't have a consistent format for part numbers, other
> than starting the part number with the first 2 or 3 letters of the product
> brand name. That's a carryover from the days I was just using a spreadsheet
> to keep track of inventory. So, part number can have a variety of characters,
> &, -, /, numbers and letters, etc. And anything from 5 to 25 characters or
> so. Many of my part numbers are derived from the manufacturer's own part
> numbers.
>
> Here's an assortment.
>
> ABU0897110101
> B&M1742QRTSN which is displayed in BBEdit as
> B&M1742QRTSN
> B&M331/2AS0201 which is displayed in BBEdit as
> B&M331/2AS0201
> PIT03
> TACA801222-13
> TOU704-005-001
>
> Here's a longer sample of the page.
>
> <tr height=19 style='height:14.0pt'>
> <td height=19 class=xl66 style='height:14.0pt'>TOUABU485</td>
> <td class=xl66>Abus lock for seat stays</td>
> <td class=xl67 align=right>60</td>
> </tr>
> <tr height=19 style='height:14.0pt'>
> <td height=19 class=xl66 style='height:14.0pt'>TOUCINQEXSB</td>
> <td class=xl66>Cinq 5 external shift box</td>
> <td class=xl67 align=right>160</td>
> </tr>
> <tr height=19 style='height:14.0pt'>
> <td height=19 class=xl66 style='height:14.0pt'>TOUMETFFLBZSL</td>
> <td class=xl66>Tout Terrain Metro Frame & Fork <span
> style='display:none'>SL
> Bronze Large</span></td>
> <td class=xl67 align=right>1666</td>
> </tr>
> <tr height=19 style='height:14.0pt'>
> <td height=19 class=xl66 style='height:14.0pt'>TOUMETFFLBZS<span
> style='display:none'>T</span></td>
> <td class=xl66>Tout Terrain Metro Frame & Fork l<span style='display:
> none'>g steel fork Bz</span></td>
> <td class=xl67 align=right>1506</td>
> </tr>
> <tr height=19 style='height:14.0pt'>
> <td height=19 class=xl66 style='height:14.0pt'>TOUMETFFXLBZ<span
> style='display:none'>ST</span></td>
> <td class=xl66>Tout Terrain Metro Frame & Fork <span
> style='display:none'>xlg
> standard fork Bronze</span></td>
> <td class=xl67 align=right>850</td>
> </tr>
> <tr height=19 style='height:14.0pt'>
> <td height=19 class=xl66 style='height:14.0pt'>VTY310M-70036</td>
> <td class=xl66>Velocity 700c Aerohead black 36h<span style='display:none'>
> MSW</span></td>
> <td class=xl67 align=right>78.99</td>
> </tr>
> <tr height=19 style='height:14.0pt'>
> <td height=19 class=xl66 style='height:14.0pt'>VTY310M-70036O<span
> style='display:none'>C</span></td>
> <td class=xl66>Velocity 700c Aerohead O/C blk 3<span style='display:none'>6h
> MSW</span></td>
> <td class=xl67 align=right>78.99</td>
> </tr>
> <tr height=19 style='height:14.0pt'>
> <td height=19 class=xl66 style='height:14.0pt'>SCH342812</td>
> <td class=xl66>Schmidt SON XS slotted Brompto<span style='display:none'>n
> 8mm
> 28h black<span style='mso-spacerun:yes'> </span></span></td>
> <td class=xl67 align=right>243</td>
> </tr>
> <tr height=19 style='height:14.0pt'>
> <td height=19 class=xl66 style='height:14.0pt'>SCH342892</td>
> <td class=xl66>Schmidt SON XS slotted Brompto<span style='display:none'>n
> 8mm
> 28h silver ano</span></td>
> <td class=xl67 align=right>243</td>
> </tr>
> <tr height=19 style='height:14.0pt'>
> <td height=19 class=xl66 style='height:14.0pt'>SCH373210</td>
> <td class=xl66>Schmidt SON28 15mm thru axle 1<span style='display:none'>50mm
> spacing 32h black ISO disc</span></td>
> <td class=xl67 align=right>436</td>
> </tr>
> <tr height=19 style='height:14.0pt'>
> <td height=19 class=xl66 style='height:14.0pt'>SCH37321010</td>
> <td class=xl66>Schmidt SON28 15mm thru axle 1<span style='display:none'>50mm
> spacing low temp grease 32h black ISO disc</span></td>
> <td class=xl67 align=right>481</td>
> </tr>
> <tr height=19 style='height:14.0pt'>
> <td height=19 class=xl66 style='height:14.0pt'>SCH383210</td>
> <td class=xl66>Schmidt SON28 15mm thru axle 1<span style='display:none'>10mm
> spacing 32h black ISO disc</span></td>
> <td class=xl67 align=right>381</td>
> </tr>
> <tr height=19 style='height:14.0pt'>
> <td height=19 class=xl66 style='height:14.0pt'>SCH383220</td>
> <td class=xl66>Schmidt SON28 15mm thru axle 1<span style='display:none'>10mm
> spacing 32h red ISO disc</span></td>
> <td class=xl67 align=right>395</td>
> </tr>
>
> Thank you so much for your assistance.
>
> Peter White
>
> On Wednesday, December 14, 2016 at 3:09:33 AM UTC-5, Christopher Stone wrote:
> On Dec 13, 2016, at 08:51, Peter White <peter...@gmail.com> 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
> "supp...@barebones.com" 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 bbedit+unsubscr...@googlegroups.com.
> To post to this group, send email to bbedit@googlegroups.com.
> Visit this group at https://groups.google.com/group/bbedit.
--
This is the BBEdit Talk public discussion group. If you have a
feature request or would like to report a problem, please email
"supp...@barebones.com" 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 bbedit+unsubscr...@googlegroups.com.
To post to this group, send email to bbedit@googlegroups.com.
Visit this group at https://groups.google.com/group/bbedit.
