Are there any future plans for support of Regular Expressions in action-items?
I’ve got a situation where I’m migrating over some perl-programs which were used to collect data from an OPC server, do some text-conversions and such using regular-expressions, then store the data into a DB. I can ALMOST do everything I need to using a combination of MySQL calls and native action-item functions, but not quite.
I briefly looked into the .net plugin integration, but quickly got lost as I have no experience with .net.
If I spend a LOT of time going through a bunch of PLC-logic & HMI logic, I can change them all to use a common format when sending text-strings to the OPC server, but at this point, thats an enormous job. The old program used Regular Expressions to clean-up the “unknowns” from the various systems (spacing differences, hyphens in some places, colons in others, etc) and store a couple of clean strings in a couple places in the database.
/STATION (\d*)[ -](.$)/i
This regular expression took a string with the text "STATION " in the beginning and stripped out any number of digits followed by any number of spaces or hyphens, and stripped out the remaining text until the end of the string. The digits and the string are the station number & text of the alarm on the machine.
The problem is that the incoming string can take so many forms. Regular Expressions can handle the variability. So far, I can’t find anything to do it in FactorySQL.