Count Characters in each word in string

Question

0.00/5 (No votes)

See more:

Hiii,

It is possible is ms sql to count characters in each words indivisually in string. if yes then please give me solution its urgent.

e.g. string is I Love Code Project
and I want something like this. 1,4,4,7

Thanks in Advance..

Posted 28-Apr-14 22:02pm

bburhanbohra

Add a Solution

3 solutions

Solution 3

Yes, it is possible, in my opinion, since SQL Server provides quite powerful string functions[^]. However why do you want to use the database engine for such a task? I would use a more appropriate programming language.

Posted 28-Apr-14 22:16pm

CPallini

Solution 1

Hello,

Check this codeproject article: [^]

JAFC

Posted 28-Apr-14 22:10pm

José Amílcar Casimiro

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manas Bhardwaj · Accepted Answer · 2014-04-28T22:12:00

You could create a function and call it like this:

CREATE FUNCTION [dbo].[fnSplitString] 
( 
    @string NVARCHAR(MAX), 
    @delimiter CHAR(1) 
) 
RETURNS @output TABLE(splitdata NVARCHAR(MAX) 
) 
BEGIN 
    DECLARE @start INT, @end INT 
    SELECT @start = 1, @end = CHARINDEX(@delimiter, @string) 
    WHILE @start < LEN(@string) + 1 BEGIN 
        IF @end = 0  
            SET @end = LEN(@string) + 1
       
        INSERT INTO @output (splitdata)  
        VALUES(SUBSTRING(@string, @start, @end - @start)) 
        SET @start = @end + 1 
        SET @end = CHARINDEX(@delimiter, @string, @start)
        
    END 
    RETURN 
END

Select (Stuff((Select ', ' + CONVERT(varchar,  LEN(SplitData)) FROM dbo.fnSplitString('I Love Code Project','') FOR XML PATH('')),1,2,''))