Tom,
Here goes.
Here's one row of the table after being saved by Excel as .html.
<tr height=28 style='height:21.0pt'>
<td height=28 class=xl68 style='height:21.0pt'>TAX110EXT44B</td>
<td class=xl68>TA X110 Outer 11 speed 44 teeth black</td>
<td class=xl69 align=right>$94.50</td>
</tr>
Here's how I'd like it to be.
<tr height=28 style='height:21.0pt'>
<td height=28 class=xl68 style='height:21.0pt'>TAX110EXT44B</td>
<td class=xl68>TA X110 Outer 11 speed 44 teeth black</td>
<td class=xl69 align=right>$<?php displayPrice("TAX110EXT44B") ?></td>
</tr>
"TAX110EXT44B" is the part number.
Thank you,
Peter White
On Monday, December 12, 2016 at 2:39:50 PM UTC-5, Tom Robinson wrote:
>
> Sounds like a convoluted process.
>
> Send a before and after example of the text manipulation you’re after (to
> this list), and I’m sure someone will take a look.
>
> e.g. Have:
>
> alpha<tab>beta
>
> Want:
>
> <b>alpha</b><br><i>beta</i>
>
> Cheers
>
>
> > On 2016-12-13, at 06:16, Peter White <peter...@gmail.com <javascript:>>
> wrote:
> >
> > I use a Filemaker Pro database in my business. We use all Macs with
> macOS. I need to send out a spreadsheet from time to time with wholesale
> prices to some customers, and keep my website current with retail prices. I
> export a .tab file from the database to a spreadsheet .xlsx that has
> several columns; part numbers, descriptions, wholesale and retail prices. I
> can email this spreadsheet to wholesale customers. Then, from Excel I want
> to export to .html to post on the website after converting to a .php file.
> >
> > The .php file will look up prices in another .tab file on the website.
> That file is just a table with part numbers and retail prices for
> everything I sell. I can update the prices on that file from time to time
> as needed just by creating a new one from the database.
> >
> > The .php file people will see on the web site will have three columns
> displayed on the website; Part number, description and retail price. I'm
> hoping I can use BBEdit to copy the part number from the first column into
> the .php code in the third column. That way, when I update prices in my
> database I can easily update both the wholesale price list spreadsheet, and
> the .php web pages. When I look at the code on file to be published on the
> web, I want to see only the .php code and the part number in the third
> column of the table. I should only see the retail price in that column when
> it's viewed in the web browser.
> >
> > The problem is, I'm reading the BBEdit manual about grep and my head
> starts to spin. So I'm hoping that someone here can point me to a quick and
> easy bit of code that will do the job.
>
>
--
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.
