News
Access to Excel sheets using index number
Until now, specifying the Excel sheet to use was limited to the sheet name. As of this version the Excel Adapter now also supports access by the individual Excel worksheet index numbers. If instead of the sheet name you give an index (1-n) the Excel Adapter will attempt to address the sheet using this number.
Support for vCard (contact data) text files
vCards are electronic business cards that are typically imported and exported from the address books of email client software. As of this version, FlowHeater now provides explicit support for vCard text files in addition to the general reading and writing of similar line-based (order independent) text data files. FlowHeater also supports the image data that may possibly be embedded in a vCard.
New functions for string extraction
This version adds powerful flexibility to the String Split Heater and SubString Heater. The String Split Heater can now optionally index the substrings in reversed sequence, starting with the last substring. In the SubString Heater you are now able to extract substrings enclosed by delimiter strings. Previously it was only possible to extract a substring by specifying a fixed starting position and length within the string.
Updated Oracle, MySQL, PostgreSQL and SQLite database drivers
Improved support for Oracle, MySQL, PostgreSQL and SQLite databases thanks to updated third-party database drivers.
Space character as sheet name in Excel
It may be hard to believe, but apparently it happens. A worksheet in MS Excel can be assigned a name consisting of a single space character.
Leaving aside the questions of who makes use of this and whether it makes any sense, the FlowHeater Excel Adapter now functions properly with a sheet named with a space character.