Find in Files help

[wmeaneyjr]

I'm implementing the Find in Files feature on our Vault Professional Server, but one of the users came to me with an issue. He was searching for a variable the other programmer put in that designate the files as needing review, so he searched for them. He got hundreds of results, but really there were only a handful of files (10 or so) but there were multiple instances showing up, all refering to the same line of code.

Is there a way to clean this up? Is this just typical DB maintenance that needs to be done?

[lbauer]

Were the results actual duplicates -- same line in the same files in the same folder?

Or were there shared files, branched files, etc. that had the same string?

[wmeaneyjr]

These were actual duplicates. Same path and the same lines.

[lbauer]

Hmm. Let see if we can find where the duplicates start. Let's search for the string in just the file itself.

Do do this, click on the file in the file list to highlight it, then under the Tools menu, open the Find in Files dialog.

The file name should be listed in the box called "Look at these file types." Make sure the Recursive box is unchecked.

Enter your string in the Search for text box, and click OK.

What are the results?

[wmeaneyjr]

When searched in the file itself, it finds just the two instances within the file.

I went ahead and did a non-recursive search of the directory the file lives in. The collapsed version says its found four instances, citing two files.

aside from the numbers, and names of the files and directories, this is EXACTLY what my results look like


Find all "Search term" in $/directory/subdirectory, *.c;*.cpp;*.h;, Exclude *.clw;*.config;*.dca;*.dll;*.dsw;*.exe;*.hlp;*.incr;*.ncb;*.opt;*.pdb;*.plg;*.scc;*.suo;*.user;*.vbw;*.webuser
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file1_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file2_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file2_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file2_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file2_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file2_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file2_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file2_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file2_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file2_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file2_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file2_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file2_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file2_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file2_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file2_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file2_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)
[-] file2_name.c - $/directory/subdirectory/ - Ver.:2 Lines: 2
(#): instance 1
(#): {instance 2)

[lbauer]

I'd like to send you a SQL script that will give us information about the structure of your project tree. The results will help us troubleshoot this further.

Email me at support at sourcegear.com, ATTN: Linda.

Please include a link to this forum post.