Searching Strings

Question

Post reply

Searching Strings

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
November 23, 2022 at 12:00 am

#4107453

Comments posted to this topic are about the item Searching Strings

Viewing 7 posts - 1 through 6 (of 6 total)

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

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 1

Heh... NOT a bad question, Steve. 😀

--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)

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 2

Steve Jones - SSC Editor

SSC Guru

Points: 736212

November 23, 2022 at 12:43 am

#4116821

Almost praise. I like it

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 3

Gosh... I hope you didn't take it the wrong way. It was meant as praise with the NOT referring to the critical symbol used in this great question.

--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)

Carlo Romagnano SSC-Insane Points: 22669 More actions · Answer 4

In the explanation, to be precise, I would change "where the first number is not a 9"

with "where the first char is not a 9"

m60freeman SSC-Addicted Points: 445 More actions · Answer 5

Great question, but I had trouble with the wording of the correct answer. I'm not sure that's a grammatically correct sentence.

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 6

The answer should be: "strips all leading '9' from the input 😉

😎

This method is useful when dealing with prefixes like leading zero.