Definitely the PHP process can be made to work, and if you’re familiar with JS, Node is maybe a little cleaner and more fluent an environment for what you want to achieve. ”string”.replace(), for instance, uses native regexp, which is clearer and more powerful than str_replace. Either way though — Both PHP and JS offer the option to run command line and grep out data and also do the cleaning/prepping and pushing to FMP or SQL in ways that leave the originals untouched.
BBEdit, is a truly excellent text editor, but for what you’re doing it’s probably better for writing up the automation than doing the automation. >> On Nov 27, 2019, at 05:42, Andrew Brown <[email protected]> wrote: > Working on a collection of aged tagged files coming from InDesign I am > cleaning up the coding with FileMaker Pro 16, running a series of lengthy > substitute calculations while cursing FMP for being grepless. This works well > for me in spite of the obvious limitations of FMP as a text editor — I > frequently copy texts out to process them in BBEdit. > > Is there any way that BBEdit could function in the same way, with immediate > and automatic search-and-replace while retaining the original file unchanged? > Perhaps something in php to run a file through str_replace and insert the > result into a specific record in a MySQL database ? > > I have been unable to persuade FMP to upload records to our remote MySQL > database and have not yet found any relevant and comprehensible advice > online. I have ODBC Manager which might or might not be what I need. > > Is there any way of feeding files from BBEdit direct into a MySQL > database? > > Thanks. > > AB > -- > This is the BBEdit Talk public discussion group. If you have a > feature request or need technical support, please email > "[email protected]" rather than posting to the group. > Follow @bbedit on Twitter: <https://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 view this discussion on the web visit > https://groups.google.com/d/msgid/bbedit/B60F4E0D-78F9-490B-B17D-DA9CF23F0CED%40c18.org. -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "[email protected]" rather than posting to the group. Follow @bbedit on Twitter: <https://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 view this discussion on the web visit https://groups.google.com/d/msgid/bbedit/1C8BB94E-4C52-4D41-B1D5-68386ECA7334%40gmail.com.
