Hey and hello! Welcome back or welcome new!
Today really quickly we'll look at something that is very helpful in my day-to-day stuff, that is, stripping all spaces and any new line characters from a string.
You can use the below:
REPLACE(REPLACE(REPLACE(REPLACE(YourString, CHAR(9), ''), CHAR(10), ''), CHAR(13), ''), ' ', '');
This strips Tab spaces ( represented by CHAR(9) ), Line Feed spaces ( represented by CHAR(10) ), Carriage Returns ( represented by CHAR(13) ) and plain old spaces (represented by ' ').
Please see here for CHAR types.
DISCLAIMER: As stated, I’m not an expert so please, PLEASE (by all means!) feel free to
politely correct or comment as you see fit. Your feedback is always
welcomed. :-)
No comments:
Post a Comment