As an aside to the BBEdit advice, that is the perfect situation for a database driven website, which is really the way that you ought to go.
In the past I used to use ColdFusion, which talks directly to Filemaker Pro Databases, but there are many other options. You could export your data to a MySQL or Postgres Database and use that directly on your website for example. Or, if that's too much, then you can just have the PHP file read your CSV directly and display the data on screen. That means you wouldn't have to go through a convoluted export / conversion / display route every time your data changes. You just export your .tab or .csv file directly from Filemaker and have the PHP script read both files and output what you need. David > On 12 Dec 2016, at 17:16, Peter White <peterjwh...@gmail.com> 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 > "supp...@barebones.com" 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 bbedit+unsubscr...@googlegroups.com > <mailto:bbedit+unsubscr...@googlegroups.com>. > To post to this group, send email to bbedit@googlegroups.com > <mailto:bbedit@googlegroups.com>. > 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 "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.
