Sorry I’m jumping in a few weeks after Peter posted this, but I use FileMaker Pro along with BBEdit to support customers who work in publishing. I read through some of the responses and I’m wondering if it would would make sense to just create the PHP file from within FileMaker Pro? Some of the data we export from FMP to our client’s websites are html files as well as xtg files used for Quark.
One technique we use, (that is dated due to legacy FMP systems) has me construct the HTML (or XTG) page in a variable in FMP, then I loop through the paragraphs in the variable and insert them into what we call an “output” table. It’s a table that only has one text field per record. This then allows me to perform a “tab” export from that table. Doing it this way preserves my carriage returns which are needed because of how Quark reads in it’s style sheets. I’d probably build it differently today since FMP has come a long way in the past 17 years. Anyway, depending on your FMP Skills, it could make more sense to render you PHP file from within FMP instead of using GREP to rebuild data that is already available. -Eric > On Dec 12, 2016, at 12:16 PM, Peter White <[email protected]> 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 > <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] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > Visit this group at https://groups.google.com/group/bbedit > <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.
