curious_sqldba (3/4/2014)
Thank you taking time in replying.
So if you copy paste the ouput in excel you will see that just first two words are together and all the other one's still have tab delimiters and they show up in different lines.
No there are no TABS left if you run that code.
The new lines are not TABS that are carriage returns (char(13)).
SELECT SomeValue AS theData ,
REPLACE(REPLACE(SomeValue, ' ', ''), CHAR(9), '') AS dataNoSpaces,
charindex(char(9), REPLACE(REPLACE(SomeValue, ' ', ''), CHAR(9), '')) AS FirstLocationOfTab,
charindex(char(13), REPLACE(REPLACE(SomeValue, ' ', ''), CHAR(9), '')) AS FirstLocationOfCarriageReturn
from #Something
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/