Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add configuration option for converting CSV column number indices to letter indices for validation #110

Closed
lulzash opened this issue Dec 17, 2022 · 2 comments
Labels
enhancement New feature or request

Comments

@lulzash
Copy link
Contributor

lulzash commented Dec 17, 2022

Request the addition of a configuration option to allow for the conversion of CSV column number indices to letter indices for validation purposes. Currently, when validating CSV files, it is necessary to manually convert column number indices to letter indices in order to accurately identify and reference specific columns. This can be time-consuming and error-prone, especially when working with large CSV files.

Adding a configuration option to automatically convert column number indices to letter indices would greatly improve the efficiency and accuracy of CSV validation processes. It would also make it easier for users to understand and reference specific columns within a CSV file.

Currently, it is not possible to convert CSV column numbers to letters using the current configuration options. This can be inconvenient when working with large CSV files, as it is difficult to read and understand the data when the columns are represented by numbers.

I propose adding a new configuration option that allows users to specify whether or not to convert column numbers to letters.

I envision this configuration option being a boolean flag, with a default value of "false". When set to "true", the column numbers in the CSV file would be automatically converted to letters.

@shystruk
Copy link
Owner

@lulzash please share some examples and a CSV file

@shystruk shystruk added the enhancement New feature or request label Jan 18, 2023
@lulzash
Copy link
Contributor Author

lulzash commented Jan 19, 2023

@shystruk Sure, I can provide some examples using the same CSV file in the demo folder to help illustrate the need for this feature.

For example, consider a CSV file with the following columns: "A", "B", "C", "D", "E".

CSV-Viewer-and-Editor

which throws validations

CSV-File-Validator-Demo

For first validation, If a user needs to reference column "D" in their validation process, they would currently need to manually convert the column number (4) to the letter "D". However, if the proposed configuration option was set to "true", the user would not need to manually convert the column number and could simply reference "D" directly.

When configuration is enable these same validation will look like

after validation

I would like to add that while it may be easy for a user to manually convert column numbers to letters for small CSV files, it becomes increasingly difficult and time-consuming as the number of columns increases. For example, in a large CSV file with hundreds of columns, manually converting column numbers to letters could be a tedious and error-prone process. This is where the proposed configuration option would greatly improve the efficiency and accuracy of CSV validation processes.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants