How to search for Tabs from "Find" in SSMS v17.5
-
In SSMS 2012 (and possibly earlier) I could find and replace Tabs in the query window.
In SSMS v17.5, SQL can't find Tabs.
Is there some cool new mystery setting or is this just another broken piece of the search dialog?
Thanks! -
This was removed by the editor as SPAM
-
This was removed by the editor as SPAM
- d_george - Wednesday, April 11, 2018 2:05 PM
Just curious, but are you actually searching for tabs, or just trying to do a find and replace?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy) -
Find & replace.
- d_george - Friday, April 27, 2018 11:22 AM
And have you tried copying and pasting existing tabbed text into the search box ?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy) -
Does it work for you?
- d_george - Friday, April 27, 2018 11:57 AM
That doesn't answer the question. But to answer yours, I'll have to try it when I get home from work today, as my installation of SQL 2017 w/SSMS is new within the last 3 weeks, and I haven't had much chance to play with it yet.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy) -
Yes you can Find/replace TAB in SSMS17.
With a normal search, you cannot type a TAB into the search box, but you can copy a TAB and paste it into the search box.
An alternative is to use the Regular Expressions from the search optionSSMS is now using the Visual Studio regex language. Using Regular Expressions in Visual Studio,
-
I am glad to hear it works for you, that leads me to believe it is a setting.
I am unable to copy/paste a tab in the search box and find it.
If I typed the string "ThereIsATabNow AndNowIAmPostTab," or if I copy/pasted the same from notepad, I am unable to find the string, tab or subset of "w A" from the search. -
Wondering if you have any kind of setting that automatically translates TABs into spaces?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy) -
Same. That's why I asked "Is there some cool new mystery setting or is this just another broken piece of the search dialog?"
-
To see what you've actually got in the editor, turn on visible whitespace chars with 'Edit => Advanced => View Whitespace '
-
I do not have an 'Edit => Advanced => ViewWhitespace' tree in v17.5, do you?
Under Tools=>Text Editor=>PlainText=>Tabs I set indenting to None, Tab Size to 8 and Keep Tabs. I did thesame for the Transact SQL and All Languages sections.
Restarted.
No change in search behavior.
If I execute the following into text and search in Editor it does not find the tabs. If I search for tabs in the Results (which is a different Find dialog, why?) it does find the Tabs.
SELECT
CONCAT('ThereIsATabNow',CHAR(9),'AndNowIAmPostTab')
,CHARINDEX(CHAR(9),CONCAT('ThereIsATabNow',CHAR(9),'AndNowIAmPostTab'))
,'ThereIsATabNow AndNowIAmPostTab'[Copied from Results]
Possibly another editorsetting someplace I overlooked?
-
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply