Thank this author by sharing:
By Phil Factor, 2011/09/29
This is a function that turns tab characters into spaces. This is not as easy as one might think because of the way that tab characters work. In a non-proportionally spaced text layout, text is positioned according to the number of spaces, which are regarded as being the width of a column. A tab character moves the insertion point to the next tab position. Tab positions are every eighth column.
I suspect that there is an easier way of doing it!- however this routine seems to work and it is fast enough for my purposes.
spaces or invalid characters
Get given character's position from a string
White space is stripped from rendered report. Can we keep the spaces?
Frequently, when working with strings you will need to identify, insert or remove spaces before, aft...
removing special characters
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
