CSV Viewer/Editor - Searching CSV like Everything Search

Plug-in and third party software discussion.
Stamimail
Posts: 666
Joined: Sat Aug 31, 2013 9:05 pm

CSV Viewer/Editor - Searching CSV like Everything Search

Postby Stamimail » Sun Jan 22, 2017 10:45 am

I'm looking for a tool can search CSV files the same way like Everything Search does, Search is filtering the lines in the table.
Suppose you have a Contacts or a Library data base, and you want to find/view fast the desired info in the data base.

froggie
Posts: 94
Joined: Wed Jun 12, 2013 10:43 pm

Re: CSV Viewer/Editor - Searching CSV like Everything Search

Postby froggie » Sun Jan 22, 2017 10:30 pm

Just a single .csv file?

Try Notepad++ (even better with the Search+ plugin), any spreadsheet program (EXCEL, LibreOffice, etc), or just plain Notepad or Wordpad

salazor
Posts: 258
Joined: Tue Jun 17, 2014 10:52 am

Re: CSV Viewer/Editor - Searching CSV like Everything Search

Postby salazor » Mon Jan 23, 2017 12:10 am

You can also use CSVFileView from Nirsoft - only read... or CSVed: http://csved.sjfrancke.nl/

Stamimail
Posts: 666
Joined: Sat Aug 31, 2013 9:05 pm

Re: CSV Viewer/Editor - Searching CSV like Everything Search

Postby Stamimail » Mon Jan 23, 2017 11:46 pm

Thank you.
Just a single .csv file?

Yes. Support for more kinds of database files, is better of course.

I couldn't find the feature I was looking for but only in CSVFileView from Nirsoft (it's called there Quick Filter - Ctrl+Q).
This feature is good, and behaves like Everything, but I think CSVFileView still not enough good. Everything looks much better and has more features. the problem is that Everything designed for search files and not text of database.

The idea started from a library PC supposed to let the library users to search books from a database of books of the library.
Everything style ("Quick Filter") looks to me much better for use by many users, than Excel search dialog-box.

salazor
Posts: 258
Joined: Tue Jun 17, 2014 10:52 am

Re: CSV Viewer/Editor - Searching CSV like Everything Search

Postby salazor » Sat Jan 28, 2017 4:12 pm

And you checked CSVed is an advanced editor .csv files.

Stamimail
Posts: 666
Joined: Sat Aug 31, 2013 9:05 pm

Re: CSV Viewer/Editor - Searching CSV like Everything Search

Postby Stamimail » Sat Jan 28, 2017 11:10 pm

@salazor
I've checked CSVed but not much. It's looked indeed as advanced tool. Maybe too advanced for the goal I looked for.
I think I didn't find there "Quick Filter" feature and also I had trouble to display Unicode characters correctly.

yrwin
Posts: 8
Joined: Wed Jan 18, 2017 10:18 am

Re: CSV Viewer/Editor - Searching CSV like Everything Search

Postby yrwin » Wed Feb 08, 2017 7:51 am

This question is a bit offtopic for everything, but i recommend Logparser (https://technet.microsoft.com/en-us/scriptcenter/dd919274.aspx). It has SQL-like access too.

NotNull
Posts: 819
Joined: Wed May 24, 2017 9:22 pm

Re: CSV Viewer/Editor - Searching CSV like Everything Search

Postby NotNull » Thu May 03, 2018 3:50 pm

Saw this on the AutoHotKey forum and remembered your question.
Sources are no longer available there (due to a hack, it seems), but can be found here.

Seems to do what you want. And if not: you can finetune the AHK code to your liking .. :)

BTW: I recommend Logparser too (handy tool; not only for logs, but most structured data), but maybe not specific for this purpose.

Stamimail
Posts: 666
Joined: Sat Aug 31, 2013 9:05 pm

Re: CSV Viewer/Editor - Searching CSV like Everything Search

Postby Stamimail » Fri May 04, 2018 1:49 pm

NotNull wrote:Saw this on the AutoHotKey forum and remembered your question..
Thanks. I tested it a little
CSV Quick Filter (CSVQF) also seems it has a way to do till it will reach Everything GUI features and performance.

BTW: I recommend Logparser too (handy tool; not only for logs, but most structured data),

I can't see a GUI here.

but maybe not specific for this purpose.

Maybe it would be better to find a Spreadsheet Program with this Quick Filter (Filter-As-You-Type) feature.


Stamimail
Posts: 666
Joined: Sat Aug 31, 2013 9:05 pm

Re: CSV Viewer/Editor - Searching CSV like Everything Search

Postby Stamimail » Sat May 05, 2018 10:01 pm

Yes. Looks like the commercial version of EmEditor has a Quick Filter with a good GUI features and performance.
Note for RTL users
EmEditor Support wrote:EmEditor curently doesn’t support RTL documents.


Return to “Development, plugins and third party software”