Finding text in CSV files?

Help & Support
1

New user just evaluating.
I have some CSV files and text find is not returning results that I know exist.

There is no listing for "CSV" in the file types drop-down?
How do we add one?
How would we search multiple file types at once?

Happy New Year

2

Tools --> Find Panel

Name matching: *.csv

Containing text:

This works for me...

3

To expand a little on what blueroly said, there are multiple ways to perform searches in Opus. For a quick search to find specific files or file types, I prefer to use the Find as you Type filter along with Flat view.

However for what you're asking, I'd use the Utility Panel Find filter as blueroly mentioned. Below is a screen grab showing how I set it up to search for my last name (Zeman) in all files ending in .CSV, .TXT, or .LOG

f459b0fc62a086e8c98fcc0e09e179b154a666b3.jpg905×820 149 KB

4

version 9.5.6
Screenshot attached.

Thank you for the prompt and helpful responses. I still don't get it.

The flat layout may be where I will end up. But this is Day One so I am just looking at basic functionality without too much configuration...

I'm navigating to the folder then selecting Find from the File Men8u. Seems straightforward...

Salut.

89f036c12c7d172ffdad4c4f9f6d4eb0dd38d9a4.jpg1399×796 162 KB

5

Change your "Type" from text document to [Files Only] and it should work.

CSV files are text files, so I can understand why it confused you. And I really don't have an answer as to why the text files type doesn't work unless Opus is actually searching for standard text files (thereby ignoring CSV files), but that's only a guess on my part.

6

That Type drop-down lists the Windows file types. "Text Document" is a type defined by Windows (unless it has been overwritten by a 3rd party text editor) which typically only matches *.txt.

That's just how file-types work on Windows. If you view a directory with .csv files in them in Opus or Explorer then you'll see the Type column does not say "Text Document" for them. (Unless something has assigned the .csv extension to that type, which would be unusual.)

If you want to match by extension, rather than file-type, then use a wildcard as John suggests.

7

The solution for me is to select [Files Only] in the TYPE drop down.

Great user-to-user support (except nobody had the answer !!)

Thanks to all

8

Is that a subtle joke or did you miss John's post above explicitly saying to do that? :slight_smile:

"Change your "Type" from text document to [Files Only] and it should work."

9

Alas, nothing subtle about me. I genuinely missed it. Thank you for pointing it out.

Excuses and hand-waving on demand. There is a lot to absorb (and at the same time getting used to win7).
All them years of XP are dying hard this month.
Windows makes too much fuss over file extensions. I'd like a giant switch that says they are just part of the file name !

Suppose I wanted to search within a few file type?, but not all (eg *.php, *.html, *.phtml, *.xml) I guess I will find that under the advanced tab.

I've not yet found a good workflow or output configuration for text search. Here is my ideal scenario:

  1. Specify a set of files, could be a number of types
  2. Specify a string (regexp or not)
  3. Search results are shown and can be clicked/manipulated as the search continues (search can be cancelled, ie no long pause of fruitlessly continuing thru thousands of file).
  4. Results panes show the file name, the line where found (with sought expression highlighted)
  5. Clicking on a result line show the file n the viewer pane (or can be configured to open in some editor/viewr).

I may be asking too much, maybe I have to use wingrep or an IDE for that kind of functionality... ?

Thank you

10

You'll find how to do that up above in this same thread.

To answer your other thoughts Opus gives you different ways to look at your search results, I personally prefer to see them in a Lister.