Code complete for v1.4

Added new QUOTIENT, INT, FINDSTRINGLAST functions

Other fixes... full details will be in final 1.4 release

VarList*

Adds new functions to 1.4 PreRelease

• Renames VarList to VarPrint - Includes print of list variables

VarList functionality for a variable length list:

• VarListExists - Checks list exists
• VarListLength - Gets length of a list
• VarListGet - Get a value from a list
• VarListAdd - Add an item to a list at the end
• VarListRemove - Remove an item from a list at an index
• VarListSet - Set a value at an index in a list
• VarListInsert - Insert a value into a list at a specified index

Please note documentation and unit tests are not yet complete for version 1.4

v1.4 PreRelease Beta 3

• Adds RangeJoin
• Performance tweaks for MakeDate and MakeTime
• Adds DatePart initial version (lacks week support at present)

PreRelease 1.4 Beta 2

Second Beta of 1.4

Randoms and Variables

Initial release of random generators and variables

Details coming in full release

Roman Numerals, Student T, Chi Squared and a few other bits

• Bug: Use relative paths in test scripts
• Bug: Correction to documentation for Month
• Bug: Improved documentation for installation
• Bug: Correction to documentation for Avg

New functions:

• Added DateFromDMY and DateFromMDY functions
• New ReportError function allowing return of error messages
• Added Version function to get Engine version as a number
• Added ToRoman and FromRoman functions for conversion to and from Roman numerals (with thanks to Ken Black for the idea)
• Optional parameters in MakeDate (month, day), MakeTime (minute, second) and MakeDateTime (all) (with thanks to Sean Adams for the idea)
• Added TInv and TDist functions for computing 2 tail Student T distribution values (with thanks to Meta
• Added ChiInv and ChiDist functions for computing values from the Chi Square distribution
• Windows 7 Batch file installers

Other changes:

• New CreateRelease script
• Overhaul of the Install scripts
• Enhanced Unit Test workflow with support for Non-Happy Path tests
• Overhaul of the C++ code Please note static functions changed, but Alteryx functions unchanged
• Retire the JDFormulaAddIn file name, replace with AlteryxAbacus.dll

Correct missing file in 1.2

1.2 release was missing MathUtils.xml

Deg/Rad, NormDist/Inv, LogNormDist/Inv

First version using the Boost libraries to provide Normal and Log Normal distributions
Also a new Deg and Rad function for converting between degrees and radians.

Static Linked DLL

Changed to static linking.

Tests. Docs, More C++ based functions and Bug fixes.

• Full set of unit tests for all the functions.
• Wiki now contains a function reference for all the functions.
• Improved Install.bat to pick up all xml and dll files.

New Functions

• MathUtils: AVG, COUNT, SUM
• DateUtils: MAKETIME, MAKEDATETIME, TODATE, TODATETIME, DATEADD

Updates

• MathUtils: HEXBINX and HEXBINY moved to C++ functions

Bug Fixes:

• StringUtils: LEFTPART and RIGHTPART missing bracket.
• StringUtils: RIGHTPART return whole string if delimiter not found.
• MathUtils: MODULO deal with NULL or 0 for divisor.