<< back to Charsep main page

Charsep     Download     Releases     Help     Disclaimer

Charsep was developped mainly in 2004 and 2005, however I did not keep track of earlier changes in versions before 2008. The tool was convenient enough for me at this time, mainly to support files beyond 255 columns. In 2008 I started to work on a project requiring heavy Csv processing so I included some new functionalities, and tracked changes that are listed below... Moving from project to project the tool has proven to be really useful for a variety of tasks !
Development is therefore still going on - sometimes with very minor changes, sometimes with completely new features.


Release 2025.08.30  :
  1. In search-replace dialog, you can remove n left characters, remove n right characters
  2. Allow to use double-quote char as row separator
  3. In File open dialog, clicking the version number on top-right will open the releases notes page
  4. In edit structure, using the "split" function defaults separator to Space

Release 2024.09.16  :
  1. In Random Grid Generator, new features for Integer generation : beside traditional uniform distribution, you can now select a normal distribution and a log-normal distribution. You can also generate only unique values - in random order
  2. In Random Grid Generator, new features for Float generation : beside traditional uniform distribution, you can now select a normal distribution and a log-normal distribution.
  3. In Random Grid Generator, new sets of constants for text generation : Animals names, Car brands, Countries and Countries iso-codes, Industries, Materials. A new algorithm also allows to generate over 11'000 distinct random job titles
  4. The grid menu "Column details" option has been revamped, to show distinct values, but also masks occurences, and allows to quickly select values based on either mask or number of occurences.

Release 2024.06.11  :
  1. In "Open file.." dialog, a new option allows to load more than one file at a time - files are expected to be of same structure. If they have a headers row, only the headers from first file will be loaded as headers - and other files headers will be skipped.
  2. In "Save file.." dialog, a new option allows to split outcome in multiple files of same number of rows. Files get created with a sequence suffix of 3 digits. Limited to the creation of 999 files max. and a minimum of 10 rows per file.

Release 2024.05.20  :
  1. In command-line processing (and "Process" command), Clipboard content can be used as input instead of a file
  2. In command-line processing (and "Process" command), Output can be sent to Clipboard
  3. In command-line processing (and "Process" command), there is an option to not set any separator in output - columns will be concatenated.
  4. In "Process" command dialog, last selected options are kept as default.
Release 2024.03.25  :
  1. In Random Grid Generator, new options on postal address generation : international, US-only, UK-only, French-only type of postal addresses
  2. In Random Grid Generator, fix on case-style which was not available for Last Name First Name option
  3. In "Select rows where.." contextual menu, option to randomely select a fixed number of rows
  4. In "Find.." contextual menu, option to search for rows containing values from clipboard (not strict full match)
  5. In "Find.." contextual menu, option to search for rows with a column containing values from another column (not strict full match)
  6. In "Search and Replace.." contextual menu, option to shuffle values of the columns. This allows to "randomize" a file, keeping full referential integrity of the values
Release 2024.03.02  :
  1. In Random Grid Generator, when a column is selected you can update its configuration rather than only adding new columns
  2. In Random Grid Generator, there is a new option to generate "Last Name, Title First Name" type of text columns
  3. In Random Grid Generator, a new 'wizard' allows to generate columns based on the current grid profile directly (rather than profiling the grid then storing a file profile)
  4. In Random Grid Generator, both float numerics and int numerics can be generated
  5. On "Column details", the number of occurences for min and max values is displayed
  6. The "Grid Information" profiling view does not allow for column drag-move anymore
  7. Case-insensitive duplicates search is possible on all grids
  8. Profiling of columns now detect UUIDs type of columns
  9. Profiling can be now configured with number of rows to analyze (1'000,10'000,100'000,  or full set)
  10. File comparison can now check for primary keys duplicates
  11. In File comparison results, reordering of columns is now disabled
  12. On grids, you can change sort order by clicking again on same header - Ctrl-click still allows for descending order
  13. Minor defects correction : on datatype handling through contextual menu functions (find, search-replace..), on Column details dialog resizing / move of controls, on Random Grid generator list of constants
Release 2023.11.30 (Siwei edition)  :
  1. New multi-column sort engine tested - not beta anymore
  2. When running a "file compare", discrepencies information is logged
  3. When running a "file compare", the grid names used to compare are added to the windows titles for clarity
  4. Once a comparison is performed, if comparison window is closed - comparison can be re-processed through a menu on second grid window
  5. When loading a grid from clipboard, timestamp of load is suffixed to window title
  6. In Edit grid, the target grid allows for single selection only, and up/down/delete buttons allow to keep selected row
  7. In grid contextual menu, new option to display a dialog on "Column details" - showing min and max value, number of non-null values - and allowing to select rows based on this column content, or to copy column values in clipboard, or sort on this column
  8. In Structure menu, new function to copy / duplicate last selected column
  9. New transformation in "search and replace" : remove any repeating character 
  10. New transformation in "search and replace" : select position of characters to map to new value. For instance, with a map of "4213" you will obtain, for "ABCD" --> "DBAC". Use digits for the map characters positions, then A,B,C... for positions above 9.
  11. Clicking number of selected rows in status bar opens the Find rows dialog
  12. Clicking total number of rows in status bar opens the Grid info dialog
  13. In Edit grid, resolved a bug on transformation of last column (e.g. "Split" function was failing)
  14. Resolved a bug on Grid Profile validation - introduced by new multi-column sort engine
  15. Resolved a bug on "Compare with File" function when different row separators were used on the two files (Unix vs Pc)
  16. Resolved a bug on "Duplicate selected rows" function - introduced by new multi-column sort engine
Release 2023.02.04-beta :
  1. This release is a major rework of the sort engine to enable multi-columns sort, optimize performance and reduce memory consumption for indexing. However many functions have been impacted so full testing shall be done to ensure no regression, hence the "beta" mention.
  2. In any sortable grid, right-click menu allows for multi-column sort. Arrows display in table header the columns of sort and direction - label is blue if ascending, red if descending, a gradient of green for multi-columns sort.
  3. New pluggable look and feel packages installed (for Flat dark and light, Intellij style, darcula style)
  4. In profile column view, selecting values will show the total of rows in % that are covered by these values.
  5. Same feature is provided in "distinct values" dialog
  6. Grids that do not allow for multirows selection have a simplified contextual menu - no "Select all" option, no "Invert selection", etc...
  7. Edit menu disables options that require rows to be selected upfront
  8. Dialogs popping up relative to a parent frame, are now always visible on screen even if parent frame is partially off-screen
  9. Log of verbose debug messages removed from console

Release 2023.01.01 :
  1. In Profile check - new option to check e-mails.
  2. In Profile check - discovery of formats support e-mails formats.
  3. Removed invalid chars in Random grid generator generated e-mails.
  4. In Search-replace function, Obfuscate now has an option to either change to AaaaBbbb000 or EauiGthf9261 style.
  5. In Open File and Save File dialogs, support of "CSV Dialect" from Frictionless standards.
  6. Direct access to "Open from file" or "Open from clipboard" in toolbar.
  7. Direct access to "Save file" or "Save to clipboard" in toolbar.
  8. New option to set "Black Nimbus" Look & Feel (needs app restart to remove).

Release 2022.12.21 :
  1. Enhanced processing of Carriage return / Line feeds when embedded in a field surrounded by quotes.
  2. New grid menu option - when more than 1 row is selected, you can show the differences between selected rows.
  3. In Profile check - new option to check different date formats.
  4. In Profile check - discovery of formats support 4 different standard dates formats.
  5. In Grid information, when all values exist for a column, turn number of values bold and blue.

Release 2022.12.11 :
  1. When merging two files by column lookup - you can optionally include the key column.
  2. Toolbar has been refactored : open, save, info, insert/delete rows buttons have been added.
  3. "Search" feature in toolbar now includes :
    • search next : select next row that contains text
    • search previous (Alt-click) : select previous row that contains text
    • search all (Shift-click): select all rows that contain text
    • search header (Ctrl-click) : show next column for wich header contains text
  4. You can now show both column header and column index in header.
  5. In Structure file, you can "use header as first row" or "use first row as header".
  6. When clicking on version on bottom right - release notes will be displayed.
  7. Help file has been updated to new features.

Release 2022.10.20 :
  1. On Search-Replace : replace latine extended characters by their equivalent in standard Ascii.
  2. Loading of resource files (icons) was failing on newest JVMs due to modularization. This is fixed.
  3. In any grid menu - user can navigate from selected row to next selected row,
  4. Merge function allows to handle simple "lookup" to add columns from another file.
  5. Upgraded Apache commons text to v1.10.0 to remove "Text4Shell" security vulnerability.
Release 2022.02.22 22:22 :
  1. When generating a random file you can either load a Random profile [*.crn], or base it on a Control profile of an existing file [*.ccn] to quickly build "analog" files.
  2. Command-line processing : allow for Structure transformation in command line (and through Processing dialog).
  3. Ctrl-Shift-S is a new shortcut for "Open selected rows".
  4. Defect resolution when initial file load fails.
Release 2021.09.17 :
  1. Option to load only a specific number of evenly distributed rows when opening a file.
  2. In "File" menu, option to view in a new Charsep window, all rows selected.
  3. In "Edit Structure" when copying a column, option to "split" on a separator and on select one part of the column.
  4. Standard template to export JSON file fixed to match JSON specifications.
  5. Profile rules discovery wizard option to limit processing to 100'000 first rows (usually sufficient for profiling a file).
  6. Processing time logging added to file compare, profile rules discovery, profile rules checking, random grid generation.
  7. Command-line processing : allow for profile check processing in command line (and through Processing dialog).

Release 2020.08.15 :
  1. On Grid "Find" function, new feature to search for duplicate rows based on "fuzzy logic" / similarity algorithms (Jaro-Winkler, Levenshtein edit distance, Soundex). Displays an outcome grid exposing all similar rows.
  2. On "Edit Structure" function - new transformations available :
    • Soundex for unique column transformation
    • Jaro-Winkler & Levenshtein edit distance for 2-cols transformation
    • Incremental sequence for "New column" creation
  3. On "Grid profile" - discover and check patterns for digits-only or numerics -+0..9(.)0...9).
  4. On "File Merger" function, merge based on a "primary key" can now support fuzzy matching based on Jaro-Winkler similarity algorithm.
  5. Fixed/Optimized header labels change performance.
  6. In any grid menu - the option displaying the number of rows allows to display these selected rows in a separate dialog.
  7. Search-replace option allows to replace Carriage return and Linefeed characters.
  8. Save dialog allows to remove surrounding quotes or Carriage return and Linefeed characters.
Release 2020.01.01 :
  1. In Random Grid Generator :
    • Test rows now span across the dialog.
    • Option to format People name in UPPERCASE, lowercase, PrettyCase.
    • New option to build a text from 'Lorem Ipsum..'.
    • New option to build dummy postal addresses.
    • New option to build dummy IP addresses V4.
    • Double-click a column allows to rename it and change % of empty values.
  2. Grid information : column distinct values now shows the different "masks" used for selected columns. When selecting a mask - the matching values are selected - and when selecting a value, the matching mask is selected.
  3. Grid profile check : new type of check - based on "masks" ( i for integer, a for alpha...)
  4. File load performance slightly improved.
  5. Cosmetic changes on Find & Search dialogs (better resizing, additional help tips for Regex...).
Release 2019.12.09 :
  1. New status line on bottom of the main window - displaying number of rows and columns in total, number of selected rows, source from file or clipboard, and a star * whenever grid is altered.
  2. Console is now one-click-hideable.
  3. If grid is altered, a warning message will pop-up asking confirmation when closing Charsep.
  4. Control-Wheelmouse on a grid allows to change 'zoom level' / font size.
  5. In "About / Preferences", you can decide to display or not line separators and columns separators in UI (Due to Nimbus defect - needs a file reload for main grid using this Look and Feel).
  6. Grid contextual pop-up menu now shows a count of distinct values for a column (when less than 10'000 values).
  7. "Select rows" contextual dialog shows by default currently selected row number.
  8. Additional concat function provided in Structure edition : hyphen-separated values.
  9. Additional search-replace function on grid : "Fill down", to replace empty values by the last non-empty one in grid order.
  10. Additional elements increase number of potential random generated distinct company names to over 200'000.
  11. When loading a file with errors in rows - a dialog showing rows in error allows immediate access to the faulty rows.
  12. When profiling a grid - a dialog showing rows out of profile boundaries allows immediate access to the faulty rows.
  13. Comestic changes in Random Grid Generator : tabs for column type selection, slider used for percentage of empty values, icons on export buttons, label changed when selecting auto-increment int...
  14. Defects correction : when last column selected was removed - merge function was failing. A limit in number of discrepencies displayed in text box has been set on file comparison to avoid memory issues. "Transpose" function now renumbers rows correctly.
Release 2019.08.15 :
  1. The "Edit Structure" dialog has been revised - now includes various transformation options on rows (Uppercase, trim,etc..), Also allows to select first-non null value from multiple columns. Performance of transformation have increased - doubled on average.
  2. When displaying distinct values of a column, double-clicking one value will select related rows in the grid.
  3. In Structure menu - a new function allows to delete the last selected column.
  4. In Grid profile, number of distinct values displays in green if all rows have a distinct values.
  5. In Transpose grid - you can now decide if header and first col must be part of the transpose.
  6. In Compare file function - by selecting a row in the comparison results, related rows will get selected in the compared grid.
  7. The Grid Profile check now includes a "wizard" to auto-discover rules on columns.
  8. The Grid Profile check results also show the column labels when in error.
  9. In Find in grid - option to select only first occurence of duplicates, or select only unique values.
  10. Search and Replace on grid allows to left-pad or right-pad values with a character or set of characters.
  11. Search and Replace on grid allows to copy values from another column.
  12. When saving file, some additional info in log : nb of rows and cols saved or transferred to clipboard.
  13. Sorting grid or transforming data does not reset selection anymore.
  14. User Experience and Cosmetic changes : icons on buttons, layout adjustments...
Release 2019.06.23 :
  1. In Grid Information, a column now shows the number of distinct values (and values themselves if less than 10).
  2. In Search/Replace, new feature to select only n left chars or n right chars.
  3. In preferences, you can select the grid font size from Extra-small to Extra-large.
  4. Defect correction : when first file opened fails to load - no need to restart app for loading following one.

Release 2019.04.28 :
  1. New functionality to control a grid compliance with a defined grid profile (under Edit menu).
  2. In Random Grid Generator, a button allows to re-generate the sample rows.
  3. In Random Grid Generator, additional values for first, last names, companies names, allow for increased variety.
  4. The "delete selected rows" and "delete rows not selected" performance has been improved.
  5. In Column profile dialog : the text area has a scrollbar and does resize based on number of selected columns.
  6. During 'Search', cursor switches to sandglass and do not hide message until search is finished...
  7. Defects corrected for 'Search' feature.
  8. Invalid menu options are disabled when the grid is empty.

Release 2019.03.09 :
  1. In File menu - New function to "merge with file" with following capabilities :
    • "Merge with file" function to only append rows to existing grid (empty values if second file has less columns, extra values ignored if second file has more columns).
    • "Merge with file" function to only append columns to existing grid (empty values if second file has less rows, extra values ignored if second file has more rows).
    • "Merge with file" function based on a selection of comparison columns (Keys) by selecting a second file with a compatible structure, with option to either keep existing values or replace by new ones.
  2. In Compare with file, a new option allows to handle case sensitivity of comparisons.
  3. In Compare with file, primary column(s) selection is now by name - not through a list of positions.
  4. The Clipboard-load now supports, when "Double-quotes can encapsulate separator" is selected, to not only encapsulate column separator but also carriage-return / row-separator.
  5. In Structure Menu - the function to insert new columns from clipboard provides a set of options : either insertion of values in sequence or using lookup values. Column position of the insertion is also selectable (by default the latest clicked column). It also allows to select a specific columns separator and define if the clipboard contains Headers or not for the new column(s) to be inserted. Optionally you can set values only on selected rows.
  6. In Random Grid Generator, "Test rows" button allows to re-generate a new set of rows (and number of test rows increased to 12).

Release 2018.05.25 :
  1. A new feature allows to directly generate a file from Random Grid Generator - to build massive, multi-millions rows files.
  2. In Random Grid Generator, you can now create columns based on random values coming from an existing file - useful feature to handle "foreign keys" when creating multi-files data, or to provide your own dictionary of dummy data to be used.
  3. In Random Grid Generator, you can directly visualize 8 sample rows displaying the result of your Grid Columns definition.
  4. The Export function now allows to generate an XML or JSON structure, based on the grid.

Release 2017.05.18 :
  1. In Random Grid Generator, "Details" on table present information on how each column is generated.
  2. In Random Grid Generator, if a grid is already loaded, you now have an option to add columns to the existing structure rather than fully replacing the grid.
  3. In Random Grid Generator, a new list of default constants is provided : list of international Cities.
  4. In Random Grid Generator, the table behavior changed - now only allow single row selection.
  5. In Random Grid Generator, Corrected defect when reordering columns (Up and Down buttons).
  6. Enhanced export style for HTML and XLS formats (matching odd and even rows style). HTML default extension added when no extension is provided in file name.
Release 2017.04.11 :
  1. Exe version fully supports 64 bits JVM.
  2. Major performance improvement of "Open file" processing.
  3. Major performance improvement of "Change Structure" processing.
  4. In Random Grid generator, added Monetary values and Phone numbers options.
  5. In Random Grid generator, for e-mails : removed blank spaces, more variety in types of emails (suffix digits, lastname.firstname, firstname@lastname[.suffix], etc..).
  6. In Random Grid generator, for userids : removed blank spaces, more variety in types of userids.
  7. In Random Grid generator, for Pets : More variety ("... Junior", "... Senior", "Lady ...", "Son of ..").
  8. In Random Grid generator, for OS and browsers : added new browsers.

Release 2016.07.21 :
  1. In Structure menu, included an option to : Insert col. from clipboard after "Col#xx" (based on selection).
  2. In Open dialog, have an option to remove surrounding single-quotes or double-quotes for all cols when loading.
  3. In "Edit structure", possibility to concat columns with brackets surrounding values.
  4. Changed url for help -> jackapps.org.
  5. In random file generator, when selecting Text type 'Random' : allow to select string length.
  6. In search-replace, new option to replace based on 'full cell' search.

Release 2016.01.27 :
  1. In file load dialog, now an option to "Load only rows containing a specific value. Col.Num (Free number entry) contains (Value).
  2. Add access to online Help page.
  3. Capability to export Grid as an HTML file or as an XML file with modifiable template.
  4. Add '%' in occurences for distinct values and column profile.
  5. Add "URL" to random list of constants.
  6. Add Date format MM/DD/YYYY HH:MM:SS AM and other date formats in Random file generator types.
  7. Add 'Company' to random list constants... Examples : "UNI DATA INC.", "PRO COMPUTING LTD.", "INFRA GISTICS SA", etc..
  8. In 'File comparison results', the 'unique key' column is now sortable.
Release 2015.03.21 :
  1.  On GridInfo, mention if a column contains only numerics.
  2.  On GridInfo col details, if numeric, provide min, max, sum, median, mean, and standard deviation.
  3.  On GridInfo col details, include the distribution factor.
  4.  In 'select rows...' dialog, include option to 'Select evenly distribute nb of rows'.
  5.  In 'search/replace' dialog, include option to replace by sequence of numerics (1,2,3..).
  6.  Evenly distribution of rows : corrected to get exact number of selected rows...
  7.  Bug fix on the 'load dialog' to show detailed view that was raising exception with 'Windows' look&feel.
Release 2014.09.13 :
  1. Refactor menu : Edit menu is now only for rows management, Structure menu for edit structure, transpose grid, delete empty columns.
  2. In Edit Structure : when adding a new column - value can be either Empty, or a constant, or based on Clipboard content (multi-lines).
  3. In right-click menu and with button "Row selection": function to select per row number, from beginning to a row - or from a row to the end, or only even rows / odd rows...
  4. In search-replace : new option to 'obfuscate' data : replace all vowels by a, consumns by b, digits by 0.
  5. In Generate random grid, UUID : format is either dash-separated or only chars, and format can be lowercase or uppercase.
  6. Corrected a bug on sorting, when 2 cols had the same label.

Release 2012.08.25
  1. Keep recently used values in Search-Replace dialog.
  2. contextual menu on grid : find & search/replace dialogs display cols position and name (To allow usage of same name for multiple cols).
  3. In a 'Grid information' column profile detail, when more than one column is selected, add information for value  'present in col x, y, z'.
  4. Random Grid generation : rationalized usage of set of constants : Booleans (true/false), ABC (A,B,B,B,C,C,C,C,C,C,C,C,C,C,C,C,C,C,C,C), 'FirstName', 'LastName'.
  5. Random Grid generation - Random dates : quick selection of Birth dates (Between today - 18 years and today - 70 years), Recent past (Between today - 2 years and today), Near future (Between tomorrow and tomorrow + 2 years).
  6. Random Grid generation : Use either birth dates, recent past or near future, for random columns adding.
Release 2012.07.31
  1. In quick search-replace, change the 'Replace' label by an option to :
        Change to UPPER-CASE.
        Change to lower-case.
        Change to Pretty-Case.
        Change to CamelCase.
        Remove all non alpha chars.
        Remove all non alphanumeric chars.
        Remove all non numeric chars.
        Left Trim spaces.
        Right Trim spaces.
        Trim spaces.
  2. In File comparison tool :
        Last column of file was not checked.
        Num of col in case of difference was indicated taking into account the 'index' col.
        'Position' type of message was reported even if rows were at same pos.
Release 2012.05.20
  1. In 'search in grid' : the find dialog now has an option to search for 'case sensitive' or not.
  2. In 'search in grid' : provide a way to compare 2 cols. Col1 'matches value of col' (with a list of previously used values).
  3. In 'search in grid' : Keep memory of used Regex / Search-Replace values.
  4. Add a 'matches clipboard values' search to search for values matching a set of words in clipboard, cr separated.
  5. Fixed a bug on 'searching for duplicates' when getting results in a new window : same row could be added multiple times (If more than 2 occurences are duplicates).
  6. In Search-Replace on grid : provide a Regex-based replacement tool.
  7. In 'export' on grid : this dialog allows to select more than one column for export.
  8. Allow to change label of copied columns when editing structure.
  9. When saving a file - the window title is renamed with saved file name.
  10. Removal of empty cols : in header, it now says 'removed NN columns'.
  11. Added the 'tilde' separator in the open/save dialogs.
  12. In Grid info : Added a "Distribution factor" information when looking for distinct values : nb distinct values / total nb values.
  13. In Grid info : If same value on all cells (but nulls), provide the value itself.
  14. In Grid info and Info col details : Alt-C to close window.
  15. In Grid info : can provide profile/details on multiple columns when multiple columns are selected.
  16. In Edit structure : allow to update new col label by double-clicking it.
  17. User can now define the log verbosity in the 'about charsep' dialog.
  18. When replacing - in loginfo, display the col and row of the replacement (if occurs less than 10 times...).
  19. Map Ctrl-F shortcut to 'Search' and Ctrl-R shortcut to 'Replace'.
  20. New function to generate mock-up data files : Random Grid Generation.
  21. In Random Grid generation : added a button to generate quickly multiple columns.
  22. In Random Grid generation : when auto-increment is selected, no need to include min and max values (By default start with 1).
  23. In Random Grid generation : for text values, allow for constants (and show a free field).
  24. In Random Grid generation : for text values, allow for 'userid' : a letter then lastname.
  25. In Random Grid generation : for date values, provide the '2011-05-11T08:23:00.0' and '2011-05-11T00:00:00.0' formats.
  26. In Random Grid generation : for date values, allow to min and max dates.
  27. In Random Grid generation : Added a percentage definition, for empty values.
  28. In Random Grid generation : for text values, option to 'include space', 'Pretty Print/UPPERCASE/lowercase/MixTe'.
  29. In Random Grid generation : allow to save, open and edit a defined structure.
  30. In 'compare with file' - provide the count of differences. Show Comparison results in a grid.
  31. When cannot copy from the 'map' provide col name in addition to col position.
  32. In 'show distinct values' set occurences as an integer column (to allow numeric sorting).
  33. Now uses a better approach to keep last used directory (Different directory for files and for Structures).
  34. Bug correction : if grid info is re-sorted, the column details does not take into account the re-sort.
  35. Bug correction : in search, cell value was set to uppercase for all searches (including Regex search).
  36. Regression correction : the drag-drop feature to get a file name from desktop does not work anymore.
  37. Enhancements to the 'comparison' dialog :
    Select Primary Key col positions : 1 or 1,5,3 etc...
    Ask for names for 'Grid 1' and 'Grid 2'.
    'Show identical rows in report'.
    'Report row position differences'.
    'Do not report missing rows from Grid 1'
    'Do not report missing rows from Grid 2'


Release 2011.05.30
  1. In 'compare with file' - provide the count of differences. Show Comparison results in a grid.
  2. Enhancements to the 'comparison' dialog :
        Select Primary Key col positions : 1 or 1,5,3 etc...
        Ask for names for 'Grid 1' and 'Grid 2'.
        'Show identical rows in report'.
        'Report row position differences'.
        'Do not report missing rows from Grid 1'.
        'Do not report missing rows from Grid 2'.
  3. In 'show distinct values' set occurences as an integer column.
  4. Option to generate a random garbage file.
  5. Add a 'matches clipboard values' search to search for values matching a set of words in clipboard, cr separated.
  6. Bug correction : in search, cell value was set to uppercase for all searches (including Regex search).
Release 2011.04.07
  1. When searching for duplicates, if table is sorted on column, use a simpler algorithm to speed up results.
  2. By double-clicking a row in Grid Information, a new dialog provide further details (Distinct values of the column)
  3. In the context-menu on all tables, added a new 'Copy selected rows' / 'Copy selected row' function (Single option, depending on current selection - same as 'export' using tab separators, no headers.
  4. The search dialog now provides tooltip on Regex search - and fixed a bug on Regex search
  5. Improved performance of "Grid information" function
  6. In 'Grid information', added a row at bottom of list, for 'total' : Nb of non empty cells, tot nb of chars (already calculated), etc... In details, this provides the record(s) with max number of cols fulfilled.
  7. "Edit Structure" : now allows to save or load structure from a 'cmp' file.
  8. Fixed a bug on Edit Structure and Transpose function (Changed labels were invalid when using 'remove empty columns, after using those functions)
Release 2011.03.18
  1. In Load dialog, function to load only first / last columns, or a columns range 
  2. Added a function to 'skip empty rows' in Load dialog
  3. Mac usability improved - Command click instead of Control click for mutlilines selection
  4. Clarified information messages for 'Search in header' function
  5. In contextual menu, show "Row X selected (out of Y)" or "X rows selected (out of Y)"
  6. If only empty cells the 'Show distinct values' selection now displays 'Column has only empty cells' instead of 'Column has also empty cells'
  7. When opening from a file show in log details on file : size in Kb, creation datetime, last update datetime...
  8. Main window title updated with the last loaded or last saved file name "Charsep - [filename]" (if filename > xx letters include ...)
  9. Added in "search grid" a function to either select all duplicate rows or all but the first one.
  10. Added a function to compare 2 files in 'Edit' menu, 'Compare with file'..
  11. in 'show distinct values' : label now says 'x distinct values, total of y occurences'
  12. In Search-Replace function : allow to replace 'is empty' by something
  13. Added the 'search replace' function to the contextual menu on grid
  14. In 'search grid' function, added 2 types of searches : 'ends with' and 'is empty'
  15. In grid - export, added option to select cols ("All cols" "only col A", ...)
  16. If properties file cannot be created (Volume readonly) raise an error message
  17. Bug fix : when dragging file on program icon, file name was not displayed in Open dialog
  18. Bug fix : in "Removed empty columns" correct resize of window
Release 2009.09.18
  1. Added a sandhour cursor while processing long operations
  2. GridInfo dialog : "Details" column now informs on which row contains smallest and largest column, etc...
  3.  In Grid info : add 'max length on rows x, y, z (and 999 others)', 'min length on rows x, y, z (and 12 others)'
  4. Grid functions are now 'verbose' -> sending output in console, for Search, Export...
  5. Keep "History" of files recently opened
  6. On the grid, results of search options can behave differently : 'Select Results', 'Append results to selection', 'Unselect Results', 'Get results in new window'
  7. Keep memory of search content in top field + checkbox for case sensitivity
  8. Keep last choice done in Search : keep the type of search (Start with, Equals ...), Value, Type of result for next search
  9. Keep last choice done in Export : keep export type (File/Clipboard), separator, include headers, only selection
  10. A right-click allows to display the distinct values of a column
  11. Save dialog now allows to "save to clipboard"
  12. Solved a bug - Null exception on "Delete rows" if last row selected
  13. When load from clipboard is done - last row processed correctly to ensure no 'empty' row is included (even if last CRLF was included or ommitted)
Release 2009.04.27
  1. Have the command-line param set to directly open csv files with CharSep : to allow drag and drop a file on the executable icon
  2. Drastically improve performance on 'delete rows' process
  3. When searching on headers - don't change the vertical position
  4. When showing first selected row - don't move the horizontal position
  5. On contextual search : added a function to search on a column where value 'not empty'
  6. Functionality to "Delete rows not selected"
  7. Changed menu layout : put  'List Charsets' in 'Help' menu
  8. In 'About CharSep', provide detail on memory (+ do a garbage collection) + set a link to the web help
  9. In 'Edit', added a functionality to duplicate selected rows

Release 2008.09.25
  1. Search on "all cols" in a grid
  2. Allow to search for "Duplicates" in a grid - on all cols or on a single col
  3. Allow to append to current selection - in grid search
  4. Save dialog : allow to "Overwrite file" or "Append to file"
  5. In Grid info, provide source file name, separator, codepage
  6. Use Excel format to view headers as letters (..Y Z AA AB ...)
  7. Quick replace function for all rows / selected rows, all cols / 1 col
  8. "Transpose grid" function to switch cols to rows
  9. Full statistics in grid information
  10. Handle (optionnally) the double-quotes for including separator in Strings
  11. Right-click in grid provides info on selected row(s)
Release 2008.09.04
  1. Import rows from clipboard (Select separator, ...)
  2. allow "Find" on modal window
  3. fix the (-1) on selected row
  4. Include "insert new line" feature...
  5. After changing structure, provide a recap on number of columns
  6. For find - Allow Regex search in "Find in grid" tool : where column "matches regex" ...
  7. When deleting rows - inform "how many remaining rows"
  8. When deleting columns blank - inform "how many remaining cols".
Release 2008.06.25
  1. Provide function to edit grid structure
  2. Allow direct data edition
  3. Count rows fix
  4. Allow Column deletion
  5. Allow Column reordering
  6. Provide function to renumber rows
  7. Provide information on total number of rows/columns + number of selected rows
Release 2008.05.22
  1. Save "only selected rows"
  2. Provide option to save CRLF or CR between each row
  3. Allow Row deletion
  4. Swap display of "Headers" with column count
  5. Search on column name and search in columns
  6. Provide "Empty columns deletion" functionality
  7. Allow to Load first rows, Load last rows, Load from row to row
  8. 'Find' on grid
  9. Show a progress bar during file load

Release 2004.04.01
 Approximate date for first Charsep release !
 Load and Save dialogs with separator selection, character set selection...
 Grid presentation with sort capabilities, contextual menu for search, select...

<< back to Charsep main page