how to use Space or Tab :b Matches either space or tab characters.
-
hi,
from this link https://docs.microsoft.com/en-us/sql/ssms/scripting/search-text-with-regular-expressions?view=sql-server-ver16
i found :b matches either space or tab charcters , pls tell me how to use. i used but it was not working.
-
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
- rajemessage 14195 wrote:
hi,
from this link https://docs.microsoft.com/en-us/sql/ssms/scripting/search-text-with-regular-expressions?view=sql-server-ver16
i found :b matches either space or tab charcters , pls tell me how to use. i used but it was not working.
We have no idea what "I used" means nor what you're trying to actually do. Please post a code example and explain what you expect it to do.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
The documentation you've link is for the Find (and Replace) tool, is that what you are using? I admit,
:bdoes not work for me for tabs or spaces either, but[ \t]does.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
The key here is to realize the misnomer. What you find in SSMS is NOT a full version of RegEx. I'm not sure it even qualifies as a valid subset.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
The problem here is that the regex search and replace for SSMS was changed to use Visual Studio regex search and replace https://docs.microsoft.com/en-us/visualstudio/ide/using-regular-expressions-in-visual-studio?view=vs-2022 but the documentation was never updated to reflect that change.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA - Jeff Moden wrote:
The key here is to realize the misnomer. What you find in SSMS is NOT a full version of RegEx. I'm not sure it even qualifies as a valid subset.
Regex is the name of a broad class of formal languages. There is no one single regex language, so trying to define one regex language in terms of another is just as pointless as trying to define English in terms of Malayalam.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA - drew.allen wrote:Jeff Moden wrote:
The key here is to realize the misnomer. What you find in SSMS is NOT a full version of RegEx. I'm not sure it even qualifies as a valid subset.
Regex is the name of a broad class of formal languages. There is no one single regex language, so trying to define one regex language in terms of another is just as pointless as trying to define English in terms of Malayalam.
Drew
You've just made my point, Drew. 😀 Even if you go to the MS documentation about what they use, SSMS uses only a subset of even that. Just because someone says "RegEx", it doesn't mean anything about what a particular use contains.
It's like saying that one knows "SQL"... which "flavor". 😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
like [ \t] is used for spaces and tabs, is there anything for finding carriage return in TSQL
ex
where Result =
'Uwon'
-
\r is carriage return. \n is line feed. So typically in Windows you're searching for \r\n
- rajemessage 14195 wrote:
like [ \t] is used for spaces and tabs, is there anything for finding carriage return in TSQL
ex
where Result =
'Uwon'
For T-SQL, Yes... search for CHAR(10) for the newline character and CHAR(13) for carriage return. It would be good to get to know more about such "control characters" using the following links...
https://learn.microsoft.com/en-us/sql/t-sql/functions/char-transact-sql
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply