Jon Egerton

Tips tricks and general musings
posts - 2 , comments - 0 , trackbacks - 0

Finding the last instance of a string using Replace - the generalized way!

I was looking for a method to easily find the last instance of a search string within a longer string.

I found a few instances of ways to do this that involve functions that loop through until no-more instances of the search string are found and some mention of using the SQL-Server 2005+ Reverse function for single character searches.

What wasn't mentioned is that the method of using the Reverse function can be extended/generalized to search for SubStrings of varying lengths.

See my article for more: http://blog.jonegerton.com/articles/finding-the-last-instance-of-a-string-using-replace.aspx

Print | posted on Monday, July 25, 2011 5:17 AM |

Feedback

No comments posted yet.
Post A Comment
Title:
Name:
Email:
Comment:
Verification:
 
 

Powered by: