Toad World® Forums

Key word coloring for .txt files

Hi all,

Due to microsoft’s inability to search .sql files, we save our script as .txt. The problem with this is when we open a .txt file in the Toad editor, we lose the key word color coding. Is there a way to see this for .txt fiels as well as .sql?

Thanks!
Tracy

Right-click in Editor and choose “Configure Editor Tab Styles…” and remove
“,TXT” from the Text style and add “,TXT” to the SQL style (without the
double-quotes). This will load .txt files into the SQL tab.

Due to microsoft’s inability to search .sql files, we save our script as .txt

Do you mean on Win7 when you type a word in the start menu’s edit box it’s not
searching them? If so, you can add .SQL files to the list to be searched. Type
“index” and go to the indexing options. Click Advanced and check out the File
Types tab. You can add new extensions there. It may take some time for Windows
to index all of your .SQL files.

Michael

Toad also has a Find in Files utility. Check out the Seach|“Find in Files”
window.

Just as an FYI for awareness purposes: if you have formatting turned on (and in
some instances when it’s not on) and you use Toad to view any text files
other than actual SQL/PLSQL code… recognize it could make a pretty big
mess of that text file. Imagine – just as an example – what that
might do to the data in a flat file ending in .txt

Roger S.

Michael writes:

Toad also has a Find in Files utility. Check out the Seach|“Find in Files”
window.

One of my favorite features of Toad! Before that, I used CygWin and
find|grep. Windows searching is frankly useless.

Rich – [TeamT]

Disclaimer: There’s no business like snow business. Especially this Winter.

Nice. One day perhaps I’ll look at tweaking it for max speed. I have a
standalone one here that searches much faster. It’s the same code base w/ all of
the Toad-isms ripped out. It smokes. Comparisons between the two performing the
same search. Most of my searches are sub 1 sec when searching nearly 2000 text
files.

Standalone app:

In Toad:
image002.png

Nice. One day perhaps I’ll look at tweaking it for max speed. I have a
standalone one here that searches much faster. It’s the same code base w/ all of
the Toad-isms ripped out. It smokes. Comparisons between the two performing the
same search. Most of my searches are sub 1 sec when searching nearly 2000 text
files.

Standalone app:

In Toad:
image001.png

Thank you all VERY much!!!

Beside the very good answers about Toad searching files and other tools, I think
your question is about Microsoft searching/indexing. Do you want to use activate
indexing on SQL files? So that when you use find in windows, it uses the index
to search your code? That is possible and very easy in windows 7. Go to indexing
options, use the button advanced and go to the file types. Add there the sql
extension if it is not there. Wait some time so that indexing has stopped…

It works for me. I have added all extensions that Toad used and when I type a
table name, it shows all files which refers to this table rather fast.

I must admit that I don’t like Microsoft searching, so most of times I use
the other suggestions.

It should be possible in other Windows versions too, but the one in Windows 7 is
the first I used. Before I found it a nuissance.

It is also possible to use other tools which indexes files and add the sql
extension to them. Google Desktop, Copernicus Desktop, X1.

Some of them are free, some of them are very good. I liked X1 until it was not
free anymore, Copernicus is very good. Google desktop is nice, but it came with
a lot of stuff I did not need, but maybe now it is better.

Talking about all of this, maybe it is time to use this type of software again,
instead of Microsoft indexing.

Groetjes,
Wim

2012/2/23 Tracy Kriel

Message from: Tracy K

Hi all,

Due to microsoft's inability to search .sql files, we save our script as
.txt. The problem with this is when we open a .txt file in Toad, we lose the
key word color coding. Is there a way to see this for .txt fiels as well as
.sql?

Thanks!
Tracy

_______________________________________

Historical Messages

Author: Tracy Kriel
Date: Thu Feb 23 12:17:47 PST 2012
Hi all,

Due to microsoft's inability to search .sql files, we save our script as
.txt. The problem with this is when we open a .txt file in Toad, we lose the
key word color coding. Is there a way to see this for .txt fiels as well as
.sql?

Thanks!
Tracy
__
_______________________________________

Forget about Google Desktop. While writing this email, I was reading the latest
updates on the tools I mentioned, and Google Desktop has been discontinued. It
is not a cloud application… Ah right. Copernic (without the us as I wrote
before) is very nice too and there is a free edition.

Groetjes,
Wim

2012/2/24 Wim de Lange

Beside the very good answers about Toad searching files and other tools, I
think your question is about Microsoft searching/indexing. Do you want to
use activate indexing on SQL files? So that when you use find in windows, it
uses the index to search your code? That is possible and very easy in
windows 7. Go to indexing options, use the button advanced and go to the
file types. Add there the sql extension if it is not there. Wait some time
so that indexing has stopped......

It works for me. I have added all extensions that Toad used and when I type
a table name, it shows all files which refers to this table rather fast.

I must admit that I don't like Microsoft searching, so most of times I
use the other suggestions.

It should be possible in other Windows versions too, but the one in Windows
7 is the first I used. Before I found it a nuissance. 

It is also possible to use other tools which indexes files and add the sql
extension to them. Google Desktop, Copernicus Desktop, X1. 

Some of them are free, some of them are very good. I liked X1 until it was
not free anymore, Copernicus is very good. Google desktop is nice, but it
came with a lot of stuff I did not need, but maybe now it is better.

Talking about all of this, maybe it is time to use this type of software
again, instead of Microsoft indexing.

Groetjes,
Wim

2012/2/23 Tracy Kriel

    Message from: Tracy K

Hi all,

    Due to microsoft's inability to search .sql files, we save our
    script as .txt. The problem with this is when we open a .txt file in
    Toad, we lose the key word color coding. Is there a way to see this for
    .txt fiels as well as .sql?

    Thanks!
    Tracy

    _______________________________________

    Historical Messages

Author: Tracy Kriel
Date: Thu Feb 23 12:17:47 PST 2012
Hi all,

    Due to microsoft's inability to search .sql files, we save our
    script as .txt. The problem with this is when we open a .txt file in
    Toad, we lose the key word color coding. Is there a way to see this for
    .txt fiels as well as .sql?

    Thanks!
    Tracy
    __
    _______________________________________

Just as an FYI for awareness purposes: if you have formatting turned on

I must have been pretty exhausted, reviewing what I wrote yesterday makes it
clear I didn’t understand half what I read in the original question :slight_smile:

I completely missed the key component of searching in MS Windows! Doh!

Roger S.