Easy Data Transform 1.4.0
- Easy Data Transform 1 1 0 Percent
- Easy Data Transform 1 1 0 3
- Easy Data Transform 1 1 0 1
- Easy Data Transform 1 1 0 2
Easy Data Transform now interprets files with extension.txt as fixed column width format files. In fixed width format, data is arranged in columns, but instead of those columns being delimited by a certain character (as they are in CSV) every column is a fixed length. Easy Data Transform 1.7.0 File size: 49 MB Easy Data Transform is suitable for a wide range of data transformation tasks, including: Transform Your Data Into Information Merge, split, clean, dedupe, reformat and more without coding Features: Joining multiple data tables Changing CSV file delimiters and encodings Filtering and analysing log files. Download Easy Data Transform, data transformation software for Windows and Mac. Easy Data Transform: Home. Download; Buy; Download Easy Data Transform for Windows or Mac It only takes a few seconds to download and a few clicks to install. Download a fully functional free trial. (7 non-consecutive days of use) No commitments.
Transform your Excel and CSV files without programming with Easy Data Transform.
Features:
- Clean, re-format, merge, dedupe, filter and analyze table and list data on your Mac.
- Transform your data interactively, step by step using 36 built-in transforms.
- Transforms thousands of rows in the blink of an eye.
- No need to upload your sensitive data to a third party server.
What’s New:
Version 1.4.0:
- You can now apply the same transform template file to hundreds or thousands of files using batch processing.
- The Enable output checkbox for output items has been replaced by the Write mode drop-down list with options Disabled, Overwrite, Append and New.
- You can now specify the minimum and maximum number of rows to create uing the Split Col transform.
- You can now change the tool bar icon size in the Preferences window.
- Significant speed-ups to the Spread transform.
- In the Split Col transform you can now specify the minimum and maximum number of columns to add.
- The Mac version of the documentation now uses Mac screenshots.
- Other minor improvements.
Compatibility: OS X 10.10 or later, 64-bit processor
Homepagehttps://www.easydatatransform.com/
Homepagehttps://www.easydatatransform.com/
Screenshots
This release adds bug fixes and improvements to v1.8.2. The download links are 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. Easy Data Transform now interprets files with extension .txt as fixed column width format files. In fixed width format, data is arranged in columns, but instead of those columns being delimited by a certain character (as they are in CSV) every column is a fixed length.
EDT will take an educated guess at the column widths if Columns is set to Automatic. But you can set the column widths manually if Columns is set to Manual.
Setting Columns to Manual or clicking the adjacent ‘…’ button will display the Fixed Column Widths window.
Change the column widths in the table. Select columns in the table or preview. Click Merge to merge 2 or more selected columns. Click Split to split a selected column into 2. For more details see the Windows or Mac documentation.
2. When you import JSON or XML files you can now choose whether to import any arrays/repeat values as Long (more rows) or Wide (more columns).
For example this JSON data: Bookmacster 2 9 15 x 9.
Input as Long (more rows) is:
Input as Wide (more columns) is: Adguard 2 4 3 (718) nightly 13.
3. If you are outputting to an Excel file you can choose to set Write mode to:
- Overwrite / File to clear the file before adding the named sheet (the old behaviour); or
- Overwrite / Sheet to clear only the named sheet before adding the named sheet
Easy Data Transform 1 1 0 Percent
This means you can now write multiple sheets to the same Excel file, as long as you set all the outputs to Overwrite / Sheet.
4. From v1.8.2 Easy Data Transform warns you if you were trying to output a dataset too large for an Excel XLSX format file (1,048,576 rows x 16,384 columns). It now also warns you if you were trying to output a dataset too large for an Excel XLS format file (65,536 rows x 256 columns).
5. The Rename Cols and Split Rows transforms did not correctly encode non-latin characters in some option values. Which meant that non-latin characters would be incorrect when the .transform file was re-opened. This is now fixed. Thanks to Torgrim S. for reporting this.
6. Some transforms did not correctly decode the % character in some option values. Which meant the % character would be incorrect when the .transform file was re-opened. This is now fixed. Thanks to David C. for reporting this.
7. Other minor bug fixes.
Mac only
Easy Data Transform 1 1 0 3
Easy Data Transform 1 1 0 1
8. In macOS 10.15 (Catalina), saving a file over an existing file with the same name can cause a crash. This appears to be a macOS bug and we hope Apple will fix it soon. As a workaround you should either:
Easy Data Transform 1 1 0 2
- Uncheck use native file windows in the Preferences window; or
- Change the file name (even changing the name to something else and back may work!); or
- Delete the old file with that name first
MacOS 10.14 and earlier are not affected.