Depeche View loads all CSV (comma or TAB separated) data files from a folder,
showing all text data within a single window.
The tool allows instant search and filtering of the data
without the need to load it in a spreadsheet application.
Example: viewing a CSV database of ZIP codes in Depeche View.
In the above example, a comma separated text was loaded, containing ZIP codes of the United States. To display the data in a more readable form, press CONTROL+SHIFT+TAB once to activate large (20 column) TAB positions:
Now everything is better readable. To search for a city name, or a zip code, just type it. For example, type "los angeles":
and instantly you land within the first lines containing the phrase.
then only the result lines are shown. If you right-click on the filter button, you may also activate "Autofilter" mode, in which the results are always filtered whenever you type a word.
Read more about Depeche View here.
If you need to preprocess CSV data, for example to convert comma separated format into a TAB separated format, then try the Swiss File Knife filter command. For example, type on the command line:
sfk filter zipcode.csv -srep "_\q,\q_\t_" -srep "_\q__" +tofile zipcode2.csvto convert zipcode.csv (comma separated with quotation marks) into a file zipcode2.csv (TAB separated, without quotation marks).