Remove white spaces from string and convert into title case

Question

Here is the example which i want in output...

I have this input = "Automatic email sent"

But I want this output = "AutomaticEmailSent"

Thanks In Advance!

what did you try so far? moreover you want to accomplish this in c# or sql? — Paolo, Oct 17 '14 at 12:48

score 1 · Answer 1 · answered Oct 17 '14 at 12:49

1

Use TextInfo.ToTitleCase

// Defines the string with mixed casing. 
string myString = "Automatic email sent";

// Creates a TextInfo based on the "en-US" culture.
TextInfo myTI = new CultureInfo("en-US",false).TextInfo;

// Changes a string to titlecase, then replace the spaces with empty
string outputString = myTI.ToTitleCase(myString).Replace(" ", "");

answered Oct 17 '14 at 12:49

Waqas Raja

10,802
4
33
38

1

Question updated as an `sql` tag, `c#` is not relevant anymore. – Soner Gönül Oct 17 '14 at 12:50

score 1 · Answer 2 · edited May 23 '17 at 12:33

1

Stealing a function from this answer which takes an text input and make it proper case (otherwise known as title case):

create function ProperCase(@Text as varchar(8000))
returns varchar(8000)
as
begin
   declare @Reset bit;
   declare @Ret varchar(8000);
   declare @i int;
   declare @c char(1);

   select @Reset = 1, @i=1, @Ret = '';

   while (@i <= len(@Text))
    select @c= substring(@Text,@i,1),
               @Ret = @Ret + case when @Reset=1 then UPPER(@c) else LOWER(@c) end,
               @Reset = case when @c like '[a-zA-Z]' then 0 else 1 end,
               @i = @i +1
   return @Ret
end

Then you can combine this function with REPLACE:

SELECT REPLACE(dbo.ProperCase(column), ' ', '')
FROM MyTable

edited May 23 '17 at 12:33

Community

1
1

answered Oct 17 '14 at 12:55

DavidG

113,891
12
217
223

Thank you so much! – Himanshu Namdeo Aug 17 '16 at 06:55
Don't forget to upvote answers you find useful and if one of them solves your issue, Mark it as the answer. – DavidG Aug 17 '16 at 07:50

score 0 · Answer 3 · answered Oct 17 '14 at 13:19

SQL Server

declare @value varchar(64) =  rtrim(' ' +  'Automatic email sent')
;with t(n) as (
    select n = charindex(' ', @value, 0)
    union all 
    select n = charindex(' ', @value, n + 1)
    from t
    where n > 0
)
select @value = stuff(@value, n + 1, 1, upper(substring(@value, n + 1, 1))) from t where n > 0
select replace(@value, ' ', '')

Remove white spaces from string and convert into title case

3 Answers3