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.
