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