CSV Query

[Manuel-Steinberg]

What's the Problem?

Working with CSV files is easy and fast, but bulk manipulations or more in depth queries can be tricky. Mostly I am using notepad++ with CsvQuery extension since it is way faster than Excel/Calc.

Solution/Idea

1. Load a CSV file.
2. Set optional read params, e.g. seperator.
3. Write SQL statements against CSV file.
4. Export to another CSV file.

Alternatives

CsvQuery

Priorities

Capability	Priority
This proposal will allow developers to set custom read param	Should
This proposal will allow end users to query a CSV with SQL	Must
This proposal will allow end users to export query result to CSV again	Must

DevToys Version

No response

Comments

No response

[Manuel-Steinberg]

Screenshot of how this looks like with notepad++ and CsvQuery extension.

[joshpinto6]

A feature like this would definitely be really great!

[Christian-Oleson]

Just as a general thought, this may be a more extensive feature to implement than some of the others since we have to write a way to query the data dynamically, since we don't have the model until we load the CSV and then have to allow folks to query on it (should use ANSI SQL).

[jamescurran]

I wonder if you could fork and adapt CsvQuery to work within DevToys.
Alternately, we could reference the SQLite nuget package and build on that (having SQLite in the DevToys ecosystem may also be useful for future tools)

[bvtvusn]

I second this!