March 2, 2013 at 5:02 am
I want to remove leading whitespace from a string only if the string has one leading whitespace , if two leading whitespaces then do not ltrim. Can this be done in tsql I'm using 2008
March 2, 2013 at 7:09 am
Hi)
You can use wild cards to define if there is one whitespace or more:
declare @a nvarchar(50)
set @a=' with one leading whitespace'
select @a=case when @a like ' [^ ]%' then LTRIM(@a) end
print @a
' [^ ]%' - means that the first character of string should be the whitespace
second character of string shouldn't be the whitespace
other characters are arbitrary.
March 2, 2013 at 12:55 pm
Hi,
sorry if I was not clear in my request above,
Basically what I'm looking for is-
I have string with value "HPJP00000013"
if this field value has one LEADING SPACE /WHITE SPACE i.e. " HPJP00000013" then TRIM it out BUT if there are 2 LEADING SPACES/WHOTE SPACES i.e. " HPJP00000013" then do not do any trimming.
if I use LTRIM then it trims out all LEADING SPACES/WHITE SPACES which is not what i need.
If you can please help me with this would be much obliged since I'm very new to TSQL world .
Kind Regards
Dhananjay
March 2, 2013 at 1:04 pm
Hi,
seems the code you gave is workign just tried-
//
declare @a nvarchar(50)
set @a= 'HPJP00000013'
select @a=case when @a like ' [^ ]%' then LTRIM(@a) end
print @a
//
When I put one leading space then it lTRIMS it out if I out 2 or more leading spaces then it does LTRIM it out.
Thanks so much foer the help.
thanks
DJ
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy