i'm confused... although bbedit can easily help you accomplish what you're
trying to accomplish why do you need different exports? if you just create
one export that has:
part number|description|price_wholesale|price_retail
all of the required info would already by there... you would then only have
to have you php code pick and choose which fields to use/display.
$lines = file("my_fmpDB_export.tab");
foreach ( $lines as $the_line ) {
$this_one = explode("\t",$the_line);
$this_part_number = $the_line[0];
$this_description = $the_line[1];
$this_price_wholesale = $the_line[2];
$this_price_retail = $the_line[3];
// generate/display some dynamic php here
}
wouldn't that address all of your needs? one exported .tab file parsed on
the fly by your php?
it sounds to me like you're describing a php thing and not a bbedit thing.
what am i missing?
On Monday, December 12, 2016 at 9:18:01 AM UTC-8, Peter White 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.
>
> Thank you,
>
> Peter White
> Hillsborough, NH
> USA
>
--
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.
