CSV or Tab Separated Data File Viewer: Depeche View for Windows 7-11.

It allows to search words as you type, or by clicking on words already present on screen, producing result lists instantly.

A typical scenario is to check address data for correctness.

In the screenshot to the right, a database of zip codes, or postal codes, taken from geonames.org was loaded with Depeche View Pro. The database provides country code, postal code, place name, state, county and community as tab separated columns.

• I press CONTROL+SHIFT+TAB in Depeche View to select a large tab size of 20, for a better display of the columns.
   
• I right click on the button to activate AutoFilter mode . This means: whenever I type a word, the tool will present a list of only the text lines containing that word (a filtered view).
   

So I have to restrict my search to the third column of the database, as this is the city name. This is done by typing:

COL3 washington.

This way, I get only 358 hits. But still I get city names like Mount Washington, or Fort Washington. I want records with the whole 3rd column containting only Washington, and nothing else. Furthermore, it should be in the District Of Columbia only. Finally, I type:

COL3FULL washington COL5FULL DC

and get all zip codes from exactly that city.

As you can see, the main principle of Depeche View is simplicity. It does NOT use complicated regular expressions, but plain English search operators like AND, OR, NOT, or COL for column.

Furthermore Depeche View allows to search words by a single click on a word, either in the same window, or through a right click in a different window. This allows high speed jumping between different table contents.