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 <javascript:>>
> 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.
