Tabify Select Lines

Question

Post reply

Tabify Select Lines

mtillman-921105

SSCertifiable

Points: 7156
More actions
July 7, 2010 at 9:47 pm

#223623

Comments posted to this topic are about the item Tabify Select Lines
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

Open Minded SSCommitted Points: 1842 More actions · Answer 1

3% of 36 or one person answered the Garfield option.

Duncan Pryde SSCertifiable Points: 7956 More actions · Answer 2

It only "tabifies" groups of 4 spaces starting from the left, so if you have 5 spaces at the beginning of the line, you'll get a tab and a space after running this.

I think it's the same in Visual Studio.

Duncan

ziangij SSCertifiable Points: 7647 More actions · Answer 3

ziangij

SSCertifiable

Points: 7647

July 8, 2010 at 3:50 am

#1190094

SSMS question after a long time..:-) thanks

WayneS SSC Guru Points: 95405 More actions · Answer 4

Duncan Pryde (7/8/2010)
It only "tabifies" groups of 4 spaces starting from the left, so if you have 5 spaces at the beginning of the line, you'll get a tab and a space after running this.
I think it's the same in Visual Studio.
Duncan

Actually, it "tabifies" based upon the setting in Options|Text Editor|All Languages/Plain Text/Transact-SQL/XML|Tabs for the Tab Size setting.

In my case, it's set to 2. Selecting tabify on your 5 spaces gives me 2 tabs and 1 space.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Duncan Pryde SSCertifiable Points: 7956 More actions · Answer 5

WayneS (7/8/2010)
Duncan Pryde (7/8/2010)
It only "tabifies" groups of 4 spaces starting from the left, so if you have 5 spaces at the beginning of the line, you'll get a tab and a space after running this.
I think it's the same in Visual Studio.
Duncan
Actually, it "tabifies" based upon the setting in Options|Text Editor|All Languages/Plain Text/Transact-SQL/XML|Tabs for the Tab Size setting.
In my case, it's set to 2. Selecting tabify on your 5 spaces gives me 2 tabs and 1 space.

Ah, interesting. There had to be an option to configure it somewhere! I suppose I've just always been happy with the default...

Duncan

Tom Garth SSCertifiable Points: 6193 More actions · Answer 6

I think the answer is not quite correct. The action only changes the LEADING spaces on a line to tabs.

Tom Garth
Vertical Solutions[/url]

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

webrunner SSC-Dedicated Points: 31173 More actions · Answer 7

"Changes the font to look like cat scratchings" is getting 1% of the answers as of the time I posted this comment. A small but bold cadre of users who are willing to sacrifice QOTD points for humor.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

mtillman-921105 SSCertifiable Points: 7156 More actions · Answer 8

Tom Garth (7/8/2010)
I think the answer is not quite correct. The action only changes the LEADING spaces on a line to tabs.

Yes, the answer could have been more specific. But the feature's basic purpose is to change spaces to tabs.

The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

SanjayAttray SSChampion Points: 13157 More actions · Answer 9

Tom Garth (7/8/2010)
I think the answer is not quite correct. The action only changes the LEADING spaces on a line to tabs.

Tabify Selected Lines – Replaces the leading whitespace on a line that contains the selection with tabs. Doesn’t matter whether the leading whitespace is selected, as long as part of the line is selected.

SQL DBA.

UMG Developer SSChampion Points: 13482 More actions · Answer 10

Nice question, thanks! It is nice to see some of the SSMS features included in the QotD since people don't always explore and find them.

mtillman-921105 SSCertifiable Points: 7156 More actions · Answer 11

I appreciate that UMG Developer. You know exactly why I chose that question. 😎

The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

OCTom SSChampion Points: 11785 More actions · Answer 12

Open Minded (7/7/2010)
3% of 36 or one person answered the Garfield option.

The song "Cat Scratch Fever" keeps running through my mind. 😉

SQLRNNR SSC Guru Points: 281324 More actions · Answer 13

Thanks for the question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Atif-ullah Sheikh SSChampion Points: 12495 More actions · Answer 14

Nice one.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.
You can check my BLOG [font="Arial Black"]here[/font][/url][/right]