This release adds improvements to v1.37.1 on Windows and Mac. The download link is at the bottom of the page.
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.
You can uninstall old releases after you have successfully installed this version.
Windows and Mac
1. The Split Col transform now has an additional Lengths option. You can use this to split a column by character position. Set Lengths as a comma separated list of the number of characters in each new column. Put a - (minus) prefix in front of a value to ignore it. Use * as the last item to mean ‘the rest of the value’. Only 1 * can be used. For example:
- 3,5,4 will create 3 columns with characters 1-3, 4-8 and 8-11
- -3,5,-4,* will create 2 columns with characters 4-8 and 12 onward
- -*,3 will create 1 column with the last 3 characters
- 2,-*,2 will create 2 columns with the first 2 and last 2 characters
Thanks to @GLS for the suggestion.
2. You can now filter columns in the Characters tab of the Right pane. This is similar to filtering in the Date tab, but you can only filter on column (case insensitive). Thanks to @JJWD for the suggestion.
3. There are now navigation buttons for the Characters pane.
4. The Split Col transform now shows a message in the Warnings tab if:
- one or more values is truncated because the column is split into more than Max. values values
- one or more values is padded because the column is split into less than Min. values values
- Max. values is less than Min. Values
5. Reading from an Excel sheet with no data previously returned an error for the input. Reading from an Excel sheet with no data now shows an empty dataset for the input, but no error. Thanks to David C. for reporting this.
6. When we added new fuzzy comparison operators to the If transform in v1.36.0, we introduced a backward compatibility issue.
- Any .transform files created before v1.36.0 with an If clause set to Is not empty is read in to v1.36.0 to v1.37.1 as 80% fuzzy match to empty.
- Any .transform files created before v1.36.0 with an If clause set to Is empty is read in to v1.36.0 to v1.37.1 or later as 90% fuzzy match to empty.
.transform files created before v1.36.0 are now read in correctly to v1.38.0.
If you have any .transform files that meet all the following criteria:
- .transform file created before v1.36.0; and
- contains an If transform with an Is empty or Is not empty comparison; and
- was run in v1.36.0 to v1.37.1
Then the result might be incorrect and you should re-run the .transform again with this v1.38.0 release. Thanks to @Patrick for reporting this.
7. The following ‘How do I?’ pages have been added:
For Windows:
- Set output file from input file name
- Trigger an update when an input file changes
- Run jobs on a schedule
For Mac:
Windows Download
Mac Download