Easy Data Transform v2.6.0
For Windows and Mac

This release adds enhancements and bug fixes to Easy Data Transform v2.5.1.

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 Pseudonym transform has been added. It allows you to pseudonymise a column of data.

Pseudonyms are padded with 0s, so they are all the same length.

Pseudonyms are assigned in a random order, determined by Random seed. This makes them harder to reverse.

To create a lookup table to reverse the pseudonymisation:

• Use Remove Cols to remove all columns apart from the original value column and the corresponding psuedonym column.
• Use Dedupe to remove the duplicate rows.
• You can then output this to a file and use it with Lookup to restore the original values.

Pseudonymising data

Recovering pseudonymised data

2. The Verify transform has an additional check Is valid ISBN. This checks if each value conforms to the ISBN-10 or ISBN-13 standard.

• Whitespace and dash characters are ignored.
• The ISBN checksum is checked.
• For ISBN-10 a checksum of 10 can be represented with upper or lower case ‘X’.
• For ISBN-13 a ‘978’ prefix is expected.
• You can mix ISBN-10 and ISBN-13 in the same column.
• It does not check that the book actually exists.
• This check only appears in Verify transforms added in v2.6.0 or later.

3. The Verify transform has an additional check Is valid IBAN. This checks if each value conforms to the IBAN standard.

• Whitespace characters are ignored.
• The IBAN checksum is checked.
• The country code and code length for that country are checked. Some small countries (such as pacific islands) may not be included.
• All letters are expected to be upper case if case sensitive is checked.
• The BBAN checksum is not checked (the algorithm for which varies from country to country).
• It does not check that the bank account actually exists.
• This check only appears in Verify transforms added in v2.6.0 or later.

4. The Verify transform has an additional check Is valid GTIN. This checks if each value conforms to the GTIN-8, GTIN-12, GTIN-13 or GTIN-14 standard.

• Whitespace characters are ignored.
• The GTIN checksum is checked.
• You can mix GTIN-8, GTIN12, GTIN-13 or GTIN-14 in the same column.
• It does not check that the product actually exists.
• This check only appears in Verify transforms added in v2.6.0 or later.

5. The Verify transform has an additional check Is valid ASIN. This checks if each value are valid Amazon Standard Identification Numbers (10 alphanumeric characters).

• Whitespace is ignored.
• All letters are expected to be upper case, if case sensitive is checked.
• The ISBN checksum is not checked.
• It does not check that the product actually exists.
• This check only appears in Verify transforms added in v2.6.0 or later.

6. The Select Columns window now has an additional option to select or unselect columns where All values are the same or All values are different.

• The dataset must have at least 2 rows.
• Matching is sensitive to whitespace.
• Check case sensitive for case sensitive matching.

Thanks to Jakub S. for the suggestion.

7. The Case transform now has an additional keep upper case option if Change case to is set to Sentence case or Title case. If keep upper case is checked, then any upper case letters will not be converted to lower case.

For example:

• If Change case to is set to Title case and keep upper case is checked, then john McKenzie PhD is converted to John McKenzie PhD.
• If Change case to is set to Title case and keep upper case is unchecked, then john McKenzie PhD is converted to John Mckenzie Phd.

Thanks to Arnaud R. for the suggestion.

8. Previously the Random transform output random values in the range Minimum to Maximum - 1 with Type set to Integer. It now outputs random values in the range Minimum to Maximum, which is more intuitive. E.g. setting Minimum to 1 and Maximum to 6 previously output values in the range 1 to 5 and now outputs values in the range 1 to 6.

.transform files read in from versions before v.2.6.0 will have 1 subtracted from the maximum, to keep the output unchanged, for backward compatibility. However v2.6.0 or later .transform files read into v2.5.1 or earlier will give a different result.