The popular "pivot table" function in Excel is available in "EMEDITOR" ~ v21.4.0 is officially released

EMURASOFT has officially released the latest version of the text editor "EMEDITOR" on December 23 (Japan time).The highlight of this time is the popular "pivot table" in "Microsoft Excel".It is surprising that the relatively advanced function, which is positioned as "if this is used," is compatible with the display and editing of CSV data, but it is "EMEDITOR", which is just a text editor.is.

"Pivot table" is a function used for data analysis such as cross aggregation.For example, when there is data from visitors as follows

会社員男自営業男公務員女公務員男学生女学生男会社役員女公務員男自営業男学生女

The following new tables can be created by taking the occupation (column) in the occupation (column), and the gender on the vertical axis (row), and the number (number of cases) of each appears.

会社員会社役員公務員学生自営業総計女1124男12126総計1133210

It is possible to take the sum of rows and columns, and you will see at a glance what kind of attributes you have.In addition to the number of cases, it is also possible to aggregate the total, average, maximum and minimum.

In the case of "EMEDITOR", the "pivot table" related commands can be used from the [Edit] -[CSV] menu or the right -click menu of the CSV header.It can also be used from the newly established buttons on the [Sorting] toolbar.The Sorting toolbar has been integrated into the CSV/Sorting toolbar, and has been separated from this version.If it is not displayed, it is a good idea to execute the [Reset all] commands in the [Customize Toolbar] dialog.

In addition, an automatic update function was introduced in "EMEDITOR Free".In response to the user's request, the balloon display that promotes upgrade can also be disabled.As a result, the setting screen has been expanded.

The "EMEDITOR FREE", which can be used for free, seems to have steadily extended users since the significant enhancement was enhanced before.

"EMEDITOR" V21.2, which opened many of the Professional version of the version to the free version, is released

"Emeditor Professional" is a classic text editor on the Windows platform.The feature is that the functions can be expanded by the plug -in, and the functions for handling CSV data are very substantial.Although it is a paid software of 5,280 yen per year, it can be used as a free version of "EMEDITOR Free" with a limited function.

The corresponding OS is Windows 7/8.1/10/11 and Windows Server 2008 R2 or later, including the 64 -bit version, and can be downloaded from the company's official website and window library.If it is Windows 10 or later, it is easy to use the store version that can be obtained from the Microsoft Store.