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 <[email protected] <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 "[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.
