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.