C#从字符串中提取数字

[薄晓然]

100%牛皮
从这个字符串中只提取100放入数据库中，请问如何做

[开着拖拉机泡妞]

参考博客

[昵称90天可改一次]

LZ传送：http://bbs.csdn.net/topics/120102476

[lzw_0736]

WITH a1 AS 
(
SELECT '100%牛皮' cstr
)
,a2 AS
(
SELECT cstr,CAST(CASE WHEN SUBSTRING(cstr,1,1) LIKE '[0-9]' THEN SUBSTRING(cstr,1,1) ELSE '' END AS VARCHAR(MAX)) cstr2,1 n FROM a1
UNION ALL
SELECT cstr,cstr2+CASE WHEN SUBSTRING(cstr,n+1,1) LIKE '[0-9]' THEN SUBSTRING(cstr,n+1,1) ELSE '' END,n+1
FROM a2
WHERE n<=LEN(cstr)
)
SELECT TOP 1 cstr2 FROM a2 ORDER BY n DESC OPTION(MAXRECURSION 0)

[骑着蜗牛去爬山]

String _str="100%牛皮"; String str=Regex.Match(_str,"\\d+").Value;

[老张一笑]

正则表达式,,

[逢床_做戏]

string _str = "100%牛皮"; string str = _str.Substring(0, 3);