Community

Hi,

TextPad 4.4.2

I am writing stored procedures for SQL Server 7 and need all the Tabs turned into spaces; I have messed with classes and the Tabulation settings but they do not do anything;

The format of the text looks fine in Textpad, but when I copy and paste it using the clipboard to SQL Server stored procedure editor or other editors like NoteTab Pro, the format is not correct; I notice that not all the rows that get tabbed are converted properly;

How do I fix this?

Thank You

-llyal

you can use a replace with a regular expression.

F8 or Search > Replace

and then search for '\t' which is a tab and replace with ' ' which is four spaces.

this will solve your problem.

try making this a macro to speed it up in future and have it as a handy keystroke.

cheers

Search for answers already given -- searching Tab reveals, among other entries:

http://www.textpad.com/forum/read.php?f=1&i=1535&t=1526