计算字符串中每个单词的字符数 [英] Count Characters in each word in string

问题描述

Hiii，



ms sql可能会在字符串中单独计算每个单词中的字符。如果是的话，请给我解决方案。紧急。



例如字符串是我爱代码项目

我想要这样的东西。 1,4,4,7



先谢谢..

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..

推荐答案

是的，有可能在我看来，因为 SQL Server 提供了非常强大的功能字符串函数 [ ^ ]。但是，为什么要将数据库引擎用于此类任务？我会使用更合适的编程语言。

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.

你可以创建一个函数并像这样调用它：

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,''))

你好，



查看这个代码项目文章： [ ^ ]



JAFC

Hello,

Check this codeproject article: [^]

JAFC

这篇关于计算字符串中每个单词的字符数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！