Sounds like a convoluted process. Send a before and after example of the text manipulation you’re after (to this list), and I’m sure someone will take a look.
e.g. Have: alpha<tab>beta Want: <b>alpha</b><br><i>beta</i> Cheers > On 2016-12-13, at 06:16, 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. -- 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.
