Bruce,
Basically I'm clueless when it comes to this sort of thing. I could hire
someone to handle the website, but I'm really trying to learn to do it all
myself. But it may be a case of this old dog being unable to learn new
tricks. ;-).
I've been looking for a video tutorial to help me learn, but I can't find
anything on BBEdit or grep.
On Monday, December 12, 2016 at 3:55:09 PM UTC-5, Bruce Linde wrote:
>
> 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.
