如何获取字符串中的数值? [英] How can i get the numeric values in string?

问题描述

您好，所有专家，

我有一个格式如下的字符串:yyyyyyxx
yyyyy:是数字
xx:可以是cm，m，mm，dm，.....
例如:1234m，12342cm，123456mm
我的问题是如何从该字符串中获取数字(1234或12342，....)?

谢谢

TONY

Hi all experts,

I have one string with format like this:yyyyyyxx
yyyyy: is the numeric
xx: can be cm,m,mm,dm,.....
EX:1234m,12342cm,123456mm
My question is how i can get the numeric(1234 or 12342,....) from that string?

Thanks

TONY

推荐答案

使用此功能

Use this function

CREATE FUNCTION ExtractInteger(@String VARCHAR(2000))
RETURNS int
AS
BEGIN
DECLARE @Count INT
DECLARE @IntNumbers VARCHAR(1000)
SET @Count = 0
SET @IntNumbers = ''

WHILE @Count <= LEN(@String)
BEGIN
IF SUBSTRING(@String,@Count,1) >= '0'
AND SUBSTRING(@String,@Count,1) <= '9'
BEGIN
SET @IntNumbers = @IntNumbers + SUBSTRING(@String,@Count,1)
END
SET @Count = @Count + 1
END

RETURN Cast(@IntNumbers as int)
END
GO

然后在选择查询中调用它.

Then call that in select query.

Select col1,dbo.ExtractInteger(col1) from tbl_temp

简单的答案就像是自己动手做:
http://msdn.microsoft.com/en-us/library/cc295312％28v = expression.40％29.aspx [ ^ ]

Looks like the simple answer is do it yourself:
http://msdn.microsoft.com/en-us/library/cc295312%28v=expression.40%29.aspx[^]

这篇关于如何获取字符串中的数值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！