CSVQuickViewer

• Bug fixes
• Improvement to Column Filter

Full Changelog: https://github.com/RNoeldner/CSVQuickViewer/compare/V1.7.9.602...V1.7.11.611

Added the ability to generate clusters that have roughly the same number of records.
Added UI to choose clustering options

Bugfix to previous version in regards to Building filters.
Removal of artifacts

Full Changelog: https://github.com/RNoeldner/CSVQuickViewer/compare/V1.7.9.600...V1.7.9.601

• Converted .NET7 to .NET8
• Rebuilding the filter UI for Contents
• Rebuilding the filter UI for columns to be shown

The new Filter UI will not show in the menu any more but instead has its own form.
On top you have the custom filter, on the bottom it shows values or clusters of values.

The suggested filter values regard already currently filtered rows excluding filters for the column showing and counting.
You can apply a filter on one column, then opening the next column filter will count and show only filtered rows.
Entering text in the custom filter will highlight matching clusters.

When building clusters, they will be combined in case they do not result in many rows.
e.G. Jan 2010 (1 item) Feb 2010 (1 item) Mar 2020 (5 item) --> Jan 20010 - Mar 2020 (7 item)

Full Changelog: https://github.com/RNoeldner/CSVQuickViewer/compare/V1.7.8.595...V1.7.9.600

• Fixed issue with changings values filter, not reflecting in filter
• Addressing issue there is no delimited file in archive
• Added Added XML Reader
• Simplify CsvWriter handing placeholders, escapes and quoting
• Better UI information when setting up Quoting

Full Changelog: https://github.com/RNoeldner/CSVQuickViewer/compare/V1.7.8.589...V1.7.8.595

• When opening Zip, you are able to choose from the contained files for display
• Fixed bug in SetRowHeight
• Added more error handling in UI
• Added Counter for Unique Display, now you see how many rows have this one key.
• Fixed errors in Hierarchy display with empty titles showing error message. now falling back to ID if the display fields doe not result in text

Full Changelog: https://github.com/RNoeldner/CSVQuickViewer/compare/V1.7.5.582...V1.7.8.589

• Improved column sizing, the new method should be faster,

Full Changelog: https://github.com/RNoeldner/CSVQuickViewer/compare/V1.7.5.581...V1.7.5.582

• Fixed an issue with entering Passwords in case there is no Key File

Full Changelog: https://github.com/RNoeldner/CSVQuickViewer/compare/V1.7.5.580...V1.7.5.581

• Added support for PGP encrypted files, the information will be streamed through Bouncy Castle library.

A path to the PGP key information can be setup for reading or writing, the key information is kept until the application is closed.
When reading the Passphrase for the Key needs to be entered, a correct passphrase is kept until the application is closed.

Full Changelog: https://github.com/RNoeldner/CSVQuickViewer/compare/V1.7.4.579...V1.7.5.580

• Resolving issue with incorrect delimiter been detected during inspection.
  With issues in row counting for CR LF there where many "empty" rows, in addition the detection had a wrong comparison. Good candidates for delimiters where disregarded and often the default , was used.

• Tried to fix issue with the application becoming unresponsive. It should be better now, but it is not quite fixed the problem is hard to reproduce

• Fixed an issue when loading a new file after another file was shown, the column types where not disregarded

Full Changelog: https://github.com/RNoeldner/CSVQuickViewer/compare/V1.7.4.578...V1.7.4.579

• Removed some code that was not need.

Some new methods that where supposed improved performance by using Spans did not have an effect, these where removed again to keep the code simple. In addition worked on some suggestions by static code analysis.

• Improved performance of detection of settings and columns:

Up to 64 MByte of the file is read into memory, when the inspection for codes page, delimiter, quote etc. is started. In case the memory can not be allocated it works the same way as before.
This feature is disabled larger files (>128 MByte) the a risk is too high that important information in cut off.
The effect is hardly noticeable if the file is very small. If the file is a medium size 10k - 64 Mbyte or files is cost intensive to open like gzip or zip files, performance is improved noticeable.

• Fixed an issue with using CsvFileReader with a stream, disposing the reader closed the stream, which is not intendent.

• Last minute fix: Detection seeming to freeze the application, it did try new field delimiters over and over.
  Needed to re-release as I binaries where not updated at source forge,

Full Changelog: https://github.com/RNoeldner/CSVQuickViewer/compare/V1.7.4.575...V1.7.4.578b

• Removed some code that was not need.

Some new methods that where supposed improved performance by using Spans did not have an effect, these where removed again to keep the code simple. In addition worked on some suggestions by static code analysis.

• Improved performance of detection of settings and columns:

Up to 64 MByte of the file is read into memory, when the inspection for codes page, delimiter, quote etc. is started. In case the memory can not be allocated it works the same way as before.
This feature is disabled larger files (>128 MByte) the a risk is too high that important information in cut off.
The effect is hardly noticeable if the file is very small. If the file is a medium size 10k - 64 Mbyte or files is cost intensive to open like gzip or zip files, performance is improved noticeable.

• Fixed an issue with using CsvFileReader with a stream, disposing the reader closed the stream, which is not intendent.

• Last minute fix: Detection seeming to freeze the application, it did try new field delimiters over and over.

Full Changelog: https://github.com/RNoeldner/CSVQuickViewer/compare/V1.7.4.575...V1.7.4.578

• Checked an optimized often used routines to increase performance.
• Rewritten Text Parsing using Spans, performance gain is minimal though. 5% when converting a lot of columns.
• Filter for Guid and Numeric values now support contains, begins and ends
• Better checks for header row detection, along with explanation why a text is not regarded as header,

If more then 3 columns in the the read header row full fill any of these condition it is assume its data and not a header
* Columns looks like a GUI, Number or Date,
* Column is very long
* Columns contains many special characters
* Duplicate columns
* Empty columns

• Modified threshold for code cage detection, the used library often detects a code page that is incorrect.

Full Changelog: https://github.com/RNoeldner/CSVQuickViewer/compare/V1.7.3.573...V1.7.4.575

• Fixed an issue with rows that was loaded after the initial batch this new rows replaced the already loaded data instead of appending it
• Stricter inspection of escap prefix. It does hurt to set an escape prefix if there is actually none, now if sequences are found that would not be needed to escape an delimiter or quote it indicating that the escape is not intended

Full Changelog: https://github.com/RNoeldner/CSVQuickViewer/compare/v1.7.3.572...V1.7.3.573

• When Inspection is disabled the configured values are used. allowing to set new general defaults
• Libraries now use char instead of string for delimiter, quote and escape: Inspection of files could be slightly faster

Change log: https://github.com/RNoeldner/CSVQuickViewer/compare/1.7.2.570..v1.7.3.572

• Fixed issues with parsing numeric fields containing grouping characters.
• Fixed some issue with converting DateTime To String with uncommon separators
• Refactoring the inspection of file formats
• Changing framework for libraries from netstandard2.1 to .net7
• Added NULL value handling as suggested after switching frameworks
• Using latest version of Nuget Package SharpZipLib
• Smaller changes in the UI as some text is too long

Change log: https://github.com/RNoeldner/CSVQuickViewer/compare/V1.7.2.567..1.7.2.570

• Added proper detection of Escape Sequences, the existing routine only made assumed escape char of \ is actually used or not
• Added options to configure detection of Escape Sequences
• Redesign of quote control as Escape has been taken out, as the Escape is not only used for quoting
• Modified UI tests to make them work with new MS Test version, Tests are passing in JetBrains Unit Test Sessions, but not in Visual Studio

Full changelog: https://github.com/RNoeldner/CSVQuickViewer/compare/v1.7.1.565..V1.7.2.567

• Improved Text Qualifier detection: It does determine if double quoting or escaped quoting is used to see if context sensitive quoting is likely. If the exact determination of text quoting does not give a good result there is a less accurate method of counting "delimiter followed by quotes"
• As headers are turned on or off column names are reset and data is re-parsed
• Re-added Checkbox for context sensitive quoting, it was lost in last release.
• Column UI rewritten making application less bloated.

After upgrade of MS Test a lot of Unit Tests failed because of STS and MTU issues. This is mostly addressed in addition timeouts have been added to most unit tests this way the tests runs should not get stuck,

Full changelog: https://github.com/RNoeldner/CSVQuickViewer/compare/V1.7.0.564...v1.7.1.565

• Added option to edit a long text in separate window; this edit windows will pretty print Json and XML and render HTML
• The external edit window / button is triggered by long text in this column; how long they need to be is configurable.
• During detection of header now has full delimited parsing, delimiter in quoted columns do not mess up detection any more,
• Fixed some cases with Font Size not being passed on dues to handled not being created in time.
• Improved quick filter for records with errors / warnings
• Rewritten Search Functionality, its still slow but using less memory

Full changelog: https://github.com/RNoeldner/CSVQuickViewer/compare/V1.6.29.560...V1.7.0.564

• Added support for setting configuration for write: Allowing you to change the quoting the delimiter or the encoding before writing, before the stetting's of the source file where used.
• Added ToolTip and better explanations
• .NET 7 version was not showing the logs and the source code correctly. The .NET 5 version of FastColoredTextBox was not working well under .NET 7. Using the version for .NET 4.72 did fix the display
• Refactoring of code to make application be faster (using In keyword where appropriate) and to show correctly in VS designer
• Removing some internally used properties that are not needed

Full changelog: https://github.com/RNoeldner/CSVQuickViewer/compare/V1.6.28.556...V1.6.29.560