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