|
| | | 
StrataFrame User
 
Group: StrataFrame Users
Last Login: 07/09/2008 2:20:16 PM
Posts: 436, Visits: 944 |
| Lets say I have a text file full of names of stored procedures and I'd like to do a 'Find In Files' type search using this text file. How would I do this?
Is there any software out there that would do this?
Searching this way would save me from entering each stored procedure name one at a time in the IDE.
Thanks |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: 10/21/2008 9:20:58 AM
Posts: 2,685, Visits: 1,887 |
| If your list gets really big (say >10,000 sprocs or so), you'll want to go with a tool that is designed for searching within text. However, if it's small, you won't notice any lag if you use the methods on the System.IO.File class such as ReadAllLines() which will return a string array of all of the lines in the file, and if you're file is formatted right, each of the entries in the array will be a sproc name. Then, you can just do an Array.Contains() or even put them in a System.Collections.Generic.List<string> and use the Find() methods to search case-insensitively.
www.bungie.net |
| |
| | |
StrataFrame User
Group: StrataFrame Users
Last Login: 07/09/2008 2:20:16 PM
Posts: 436, Visits: 944 |
| | Thanks! Do you know of a tool designed for this type of thing? |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: 10/21/2008 9:20:58 AM
Posts: 2,685, Visits: 1,887 |
| | |
|
|