Saturday, January 14, 2012

Matrex 2.2 out

Finally relaeased Matrex 2.2.

Matrex 2.2 adds 42 new functions in the standard package:

sys.date.removetime
sys.date.subtract
sys.db.update
sys.standard.minmax.max
sys.standard.minmax.min
sys.standard.minmax.nthmax
sys.standard.minmax.nthmin
sys.standard.test.iseven
sys.standard.test.isodd
sys.standard.trigonometric.acosh
sys.standard.trigonometric.asinh
sys.standard.trigonometric.atanh
sys.standard.changebase
sys.standard.closesteven
sys.standard.closestodd
sys.standard.constant
sys.standard.constantas
sys.standard.factorial2
sys.standard.gcd
sys.standard.lcm
sys.standard.logbase
sys.string.chars.charstocodes
sys.string.chars.charstostring
sys.string.chars.codestochars
sys.string.chars.codestostring
sys.string.chars.stringtochars
sys.string.chars.stringtocodes
sys.string.regex.find
sys.string.regex.replace
sys.string.test.isboolean
sys.string.test.isdate
sys.string.test.isinteger
sys.string.test.isnumeric
sys.string.equalsignorecase
sys.string.find
sys.string.len
sys.string.repeat
sys.string.replace
sys.string.trimleft
sys.string.trimright
sys.string.uppercasefirst
sys.util.convertunit

of them, very important are:

sys.db.update

This is used to insert, update or delete data in a database.
It allows the classical database operation update row if it exists, otherwise insert a new one , very useful when you want to store data from a spreadsheet.


sys.util.convertunit

This used to convert data from a measurement unit to another.
For example convert from watt to horsepower, liter to pint...

You can find more information in the function templates list.


Internally, Matrex uses now JodaTime to handle dates. This allowed to write the sys.date.subtract function, which is used to do dates subtraction.

Matrex 2.2 needs Java 6 (jre 1.6) to run.

Here is the download link.

Thanks to Braxton for the MacOSX version.