To resolve these problems, go to Edit → Editor Options and look under "General Options", under the "General Options" node, where there are several options related to tab stops. Unchecking "Auto indent" and "Tab to next column" will make the step size consistent. Unchecking "Insert TABs into text for TAB characters" and "Insert mixture of tab/space for optimal fill" will make TOAD use spaces instead of Tabs, which will prevent any problems where TOAD's tab stop difference is different from another program's.

The tab stop distance can also be set at the bottom of this page. Edit → Editor Options → General Options → Display Options → "Show control characters" lets you see where tabs or spaces are used.

To get rid of existing tabs, open your file and press "Replace". Check "Regular expressions". Choose to find "\t" and replace with "\s\s\s" to replace all tabs in the file with 3 spaces. Select Entire and press Replace All.

About the Author

Steve Hilker

Steve Hilker was a Product Manager for Quest Software. Steve has over 35 years technical experience spanning application development, system administration, database management and various management positions at several software companies. Steve was the founder of RevealNet, best known for its desktop knowledge bases and unique database tools such as PL/Formatter. RevealNet was acquired by Quest Software in 2001. He's had the pleasure of being the product manager for many of Quest's database tools.

Start the discussion at