This release adds enhancements and bug fixes to Easy Data Transform v2.6.0.
You will require a v2 license to use this release after the free trial has expired. You can buy a new license key here or, if you have a v1 license key, you can buy a discounted upgrade here. See also our upgrade FAQ.
We recommend that you back-up important .transform files before installing any new release.
Please let us know of any problems or issues you encounter with the release.
The download links are at the bottom of the page.
System requirements
Windows: 64 bit Windows 11/10/8/7 (Intel processor) or 64 bit Windows 11 (ARM processor).
Mac: macOS 15.x to 10.13 (Universal Binary for ARM M series or Intel processors).
Compatibility
This version can read .transform files saved in all previous versions.
Windows and Mac
1. A new Split Name transform has been added. It allows you to split a column of people’s name into honorifics, first names, middle names, last names and suffixes.
The Split Name transform uses various heuristics (rules of thumb) to split a name into parts. It expects each value to be a single name in the order: honorific(s) -> first name(s) -> middle name(s) -> last name(s) -> suffix(es), separated by whitespace or commas. Some of the name parts can be missing, but they must be in this order.
The splitting algorithm knows about:
- common honorifics in a range of languages, such as: ‘Mr’, ‘Mrs’, ‘Miss’, ‘Ms’, ‘Herr’ and ‘Frau’.
- military, political, religious and other honorifics, such as: ‘Major General’ and ‘Rabbi’.
- ‘particules’ at the start of last names, such as: ‘de’ and ‘von’.
- common suffixes, such as: ‘MBA’, ‘PhD’ and ‘Jr’.
Uncheck any name parts you don’t expect to be present.
Honorifics it does not recognize can be added as a comma separated list in Custom honorifics.
Suffixes it does not recognize can be added as a comma separated list in Custom suffixes.
Set Num last names to according to whether you expect there to be 1 or 2 last names (e.g. 2 is typical for Spanish names).
Split Name cannot guarantee to be 100% accurate. For example it is impossible to know for sure if the ‘Lee’ In ‘John Lee Hooker’ is a first name, middle name or last name. In such situations it will make a guess.
2. The Pivot transform now supports multiple levels of pivoting. You can set any number of pivot levels.
Set Delimiter to the character(s) you want to use to separate column values.
3. The DateTime Format transform can now change the date format based on input and output locales. The ddd, dddd, MMM and MMMM formats are interpreted according to the locale selected in the transform (rather than the locale set in Preferences). For example, you can now change a month name from English to German:
4. The Num Format transform now has Locale from and Locale to options. The locale affects the decimal and group separators and the digit characters used.
5. The Random transform can now generate random Date and Text values, in addition to the existing Real and Integer options. This can be very useful for generating synthetic data.
6. Inputs, transforms and outputs now have smarter defaults. When you create a new item it will (where appropriate) set option defaults to the values last set for a item of that type. The defaults are handled separately for:
- each combination of input format and file extension
- each transform type
- each combination of output format and file extension
For example, if you set a Case transform Change case to option to Upper case, the next time you add a new Case transform the Change case to option will default to Upper case.
7. If you change the Type of an output file, and the current file extension does not match the expected extension for that file type in Preferences>Output Extensions, you will be prompted whether you want to change the extension.
8. The Is Valid ISBN check in the Verify transform now supports ISBN-13 codes starting with a 979 prefix.
9. The default sort order in the Sort and Sequence transforms has been changed from Descending to Ascending. This feels more intuitive. Existing .transform files are unaffected.
10. The Sequence transform now uses date and integer controls for inputting date and integer types. Previously it used text fields for this.
11. The locale set in Preferences is now shown at the bottom of the Main window.
12. Fixed an issue where the user interface could be slow for .transform files with hundreds of transforms. Thanks to Phillip K. for reporting this and helping us to reproduce it.
13. The Num Format transform can now handle the right single quote character, which is used as a group separator in some locales, e.g. German/Switzerland.
14. An additional file name variable {transformfname} is available. It is replaced by the file stem of the .transform file name. Thanks to @MarsKy for the suggestion.
15. The log pane now shows output files with file name variables substituted. Thanks for @msmelo and @Olaf for suggesting this.
16. The number of items and connections selected is now shown in the Status bar.
17. The names of unset Transform options are now shown in the Warnings tab.
18. The Rename Cols transform has an additional button that converts space characters to underscore characters.
19. You are now warned if you try to output to Excel with a sheet name that is invalid due to:
- length
- begins or ends in apostrophes
- reserved name
Previously it only warned on forbidden characters.
Thanks to @MarsKy for reporting this.
20. You are now warned if you input or output a dataset with duplicate column header names.
- On input the check takes place after any schema is applied and ignore empty columns has been applied.
- On output the check only takes place where write header is checked.
21. Previously you couldn’t open an output file or it’s folder when the path contained file name variables. This is now fixed.
22. Duplicate Branch could sometimes cause issues with transforms with multiple inputs, such as Lookup. This is now fixed. Thanks to @Olaf for reporting this.
23. The Operator dropdown in the Filter and If transforms was sometimes visually truncated. This is now fixed. Thanks to @MarsKy for reporting this.
Known issues
24. Duplicate Branch can cause the relative Y position of items to change. This can cause issues when the branch contains Y position dependent transforms, such as Lookup. So use Duplicate Branch with caution in these situations. We will try to fix this issue in a future release.
Windows Download
Mac Download