CSV Buddy Changelog

What's new in CSV Buddy 3.0.0

Jul 22, 2022
  • Merge fields:
  • Add a “Merge” command in tab “2) Edit Columns” with two text boxes to set 1) the template of the new field with including existing fields enclosed by merge delimiters, for example “Full name: [FirstName] [LastName]”) and 2) the name of the new field (see documentation)
  • Configurable Merge opening and closing delimiters in the “Options” tab
  • Support for placeholder ROWNUMBER (enclosed with merge delimiters) in merge fields format section, for example “#[ROWNUMBER]”
  • When loading a file, support for merged fields in the file header allowing to create an new field using a template inserting values from of previous fields in each row (see documentation)
  • User interface – Font size and screen scaling:
  • Redesign the user interface to support font changes in the main window, full screen editor and zoom windows
  • New font settings in “Options” tab for labels (default Microsoft Sans Serif, size 11), text input (default Courier New, size 10) and list (default Microsoft Sans Serif, size 10)
  • Adjust display for HDPI screen scaling
  • User interface – Various improvements:
  • Change the order of commands in tab 2 to “Rename”, “Order”, “Select” and “Merge”
  • Add “Undo” buttons for each commands in tab 2 allowing to revert the last change
  • Track changes in list data and alert user for unsaved changes before quiting the application
  • Add a section to the status bar to show that changes need to be saved
  • Disable application’s window during loading file, loading to listview, saving to csv or exporting data
  • Stop quitting the application when user hit the Escape key
  • Display error message if trying to open a file that does not exist
  • Put more info in error message displayed if a file does not load correctly
  • In Search and replace, fix bug not allowing to replace it nothing
  • Fix a bug opening the wrong record editor

New in CSV Buddy 2.1.6 (Dec 11, 2017)

  • Fix bug when changing the Fixed with default in Export tab.

New in CSV Buddy 2.1.5 (Jul 21, 2017)

  • Fix bug when processing HTML or XML multi-line content, reversing earlier change done to support non-standard CSV files created by XL causing issue (stripping some "=") in encapsulated fields.

New in CSV Buddy 2.1.4 (Jul 20, 2017)

  • Fix bug: show the end-of-line replacement field when loading a file from the command-line (or by double-click a file in Explorer).

New in CSV Buddy 2.1.3 (Dec 24, 2016)

  • Fix bug preventing correct detection of current field delimiter when file is loaded. The delimiter is the first one detected on the first line of the loaded file, in this order: tab, semicolon (;), comma (,), colon (:), pipe (|) or tilde (~).

New in CSV Buddy 2.1.1 (Dec 21, 2016)

  • Fix bug when "Set header" is selected and "Custom header" is empty, columns with "C" field names generated are now sorted correctly.

New in CSV Buddy 2.1 (Oct 21, 2016)

  • Stop trimming (removing spaces at the beginning or end) data value read from CSV file, but still trimming field names read from CSV file.

New in CSV Buddy 2.0 (Sep 7, 2016)

  • New option “Encapsulate all values” to always enclose saved values with the encapsulator character
  • Display a “Create” button on first tab to create a new file based on the Set header data
  • Remember the last folder where a file was loaded
  • Code signature with certificate from DigiCert
  • Includes changes in the previous Beta versions

New in CSV Buddy 1.3.9.1 Beta (Sep 1, 2016)

  • Unlock the “CSV file to load” zone in first tab, allowing to type or paste a file name
  • Add a “Create” button on first tab to create a new file based on the “CSV file Header” data
  • Remember the last folder where a file was loaded and use it as default location when loading another file
  • Add items to context menu to add and edit rows with field-by-field editor
  • Fix bug when filter on a column, hitting the Cancel button now cancels the filtering
  • Fix bug default encoding in first tab is now “Detect” if no default value is saved to the ini file
  • Apply grid setting and colors to list of field in field-by-field row editor
  • Fix bug reading values in ini file for “Skip Ready Prompt” and “Skip Quit Prompt”
  • Fix visual glitch with labels close to left part of tabs, labels were overlapping left vertical line

New in CSV Buddy 1.3.9 Beta (Aug 29, 2016)

  • New Record editor dialog box with field-by-field edition
  • New “Options” tab to change setting values saved to the CSVBuddy.ini file
  • New option “Record editor” for choice of 1) “Full screen Editor” (legacy) or 2) “Field-by-field Editor” (new). Default is 2
  • New option “Encapsulate all values” to always enclose saved values with the encapsulator character
  • Help button for Options
  • Bug fix: now detect the end-of-line character(s) in fields where line-breaks have to be replaced by a replacement string (detected in this order: CRLF, LF or CR). The first end-of-lines character(s) found is used for remaining fields and records
  • Now using libreary ObjCSV v0.5.5

New in CSV Buddy 1.3.3 (Jul 29, 2016)

  • If file encoding is not specified (leave encoding at “Detect”) when loading a file, it is loaded as UTF-8 or UTF-16 if these formats are detected in file header or as ANSI for all other formats (and displayed as such in load and save encoding encoding lists); UTF-8-RAW and UTF-16-RAW formats cannot be auto-detected and must be selected in encoding list to load files in these formats
  • Add values SreenHeightCorrection and SreenWidthCorrection in CSVBuddy.ini file (enter negative values in pixels to reduce the height or width of edit row dialog box)

New in CSV Buddy 1.3.2 (Jun 8, 2016)

  • Fix bug introduced in v1.2.9.1 preventing from saving manual record edits in some circumstances
  • Automatic file encoding detection is now restricted to UTF-8 or UTF-16 encoded files (no BOM)
  • Read the new value DefaultFileEncoding= (under [global]) in CSVBuddy.ini to set the default file encoding (possible values “ANSI”, “UTF-8”, “UTF-16”, “UTF-8-RAW”, “UTF-16-RAW” or “CPnnn”)

New in CSV Buddy 1.3.1 (Jun 1, 2016)

  • Change licence to Apache 3.0

New in CSV Buddy 1.3.0 (May 25, 2016)

  • Select file encoding when loading, saving or exporting files
  • Automatic detection of loaded file encoding (this is not possible for files without
  • byte order mark (BOM))
  • Encoding supported: ANSI (default), UTF-8 (Unicode 8-bit), UTF-16 (Unicode 16-bit),
  • UTF-8-RAW (no BOM), UTF-16-RAW (no BOM) or custom codepage CPnnnn
  • Set custom codepage load and save values in CSVBuddy.ini file
  • Other changes:
  • when editing a record, zoom button to edit long strings in a larger window
  • deselect all rows after global search is cancelled
  • add status bar right section to display hint about list menu
  • add help message when right-clicking on column headers
  • when there is not enough space on screen to edit all fields in a file, support
  • editing the visible fields without loosing the content of the missing fields

New in CSV Buddy 1.2.9 Beta (May 16, 2016)

  • Select file encoding when loading, saving or exporting files
  • Automatic detection of loaded file encoding (this is not possible for files without byte order mark (BOM))
  • Encoding supported: ANSI (default), UTF-8 (Unicode 8-bit), UTF-16 (Unicode 16-bit), UTF-8-RAW (no BOM), UTF-16-RAW (no BOM) or custom codepage CPnnnn
  • Set custom codepage values in CSVBuddy.ini file
  • Other changes:
  • deselect all rows after global search is cancelled
  • add status bar right section to display hint about list menu
  • add help message when right-clicking on column headers
  • remove global search and replace (needing to be reworked)

New in CSV Buddy 1.2.3 (Sep 15, 2014)

  • fix bug when saving or exporting file with a column sort indicator

New in CSV Buddy 1.2.2 (Mar 18, 2014)

  • after a column sort, fix names errors in column headers
  • by safety, remove sorting column indicator before any action in edit columns tab

New in CSV Buddy 1.2.1 (Mar 18, 2014)

  • ini variables missing when ini file already existed
  • bug with multiple instances

New in CSV Buddy 1.2 (Mar 8, 2014)

  • search and replace by column, replacement case sensitive or not
  • confirm each replacement or replace all
  • during search or replace, select and highlight the current row when displaying the record found
  • option in ini file to display or not a grid around cells in list zone
  • options in ini file to choose background and text colors in list zone
  • up or down arrow to indicate which field is the current sort key
  • allow multiple instances of the app to run simultaneously
  • import CSV files created by XL that include equal sign before the opening field encasulator

New in CSV Buddy 1.1 (Jan 3, 2014)

  • global filtering: right-click in the list zone to retain only rows with the keyword appearing in any column
  • search by column: find the next row having the keyword in this column and open it in row edit window
  • global search: find the next row having the keyword in any column and open it in row edit window
  • in edit row window search result, highlight the field containing the searched
  • keyword
  • added stop and next buttons to edit row window when search in progress
  • added reload original file to the column menu and the list context menu
  • display the current edited record number in edit row title bar
  • add blnSkipConfirmQuit option in ini file to skip the quit confirm prompt, default
  • to false
  • use ObjCSV library v0.4 for better file system error handling

New in CSV Buddy 1.0 (Dec 4, 2013)

  • Add records to existing data (right-click in the list zone)
  • Create a new file from scratch (right-click in an empty list zone)
  • Load the file mentioned as first parameter in the command line
  • Add validation, confirm before exit and fix various small bugs

New in CSV Buddy 0.9 Beta (Nov 4, 2013)

  • Small fixes and addition of test files in the zip package.