Version 20.2

October 6, 2020

New General Features

  • Added an ability to sort or delete duplicate elements (separated by a separator such as a semicolon) in a column of "nested" CSV documents. To do this, select the Split Columns command and select Split the selected columns into - (None) in the Split Columns dialog box.

  • The new version shows the * mark in the Advanced button of the Find/Replace (in Files) dialog boxes when any options in the Advanced dialog has been changed from the default. The Advanced button in the Find toolbar will be highlighted if any advanced options are set.

  • Added the Copy and Convert commands to a tooltip displayed when hovering over an HTML/XML character reference, universal character name, or percent-encoding active string.

  • Added the AutoFill/AutoRepeat command to the context menu displayed when you finish dragging the AutoFill/AutoRepeat handle. This command allows you to enter how many lines/columns to repeat the copy of the same value or extend the serial numbers.

  • Improved the speed of the Split Columns command.

Test results:

v20.1.0

v20.2.0

Comparison

Split a column to columns (12 million lines)

12.1 seconds

2.42 seconds

5.00 times faster

Split a column to lines (100,000 lines)

262 seconds

0.141 seconds

1,860 times faster

\* Split a column to columns: 611 MB, 12 million lines, ASCII CSV data.

Split a column to lines: 5.13 MB, 100,000 lines, ASCII CSV data.

All: Always discard Lengthy Undo information to Accelerate option on, Adjust Separator Positions Automatically option off, 16 threads, Windows 10 (64-bit), Core i9-9900K, 32GB RAM, 2TB SSD.

New Options

  • Added the Split the selected columns into - (None) radio button to the Split Columns dialog box.

  • Added the Disable slow find markers on scroll bar check box to the Optimization page of the Customize dialog box.

  • Added the File access timeout text box to the File page of the Customize dialog box.

Plug-in API New Features

Macro New Features