如何区分字符串中的字符与数字 [英] How to differentiate character from number in a string
本文介绍了如何区分字符串中的字符与数字的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个来自表的值,例如DX1234
对于此值,我必须从整个值中找出字符,例如DX
第二步,我必须对字符使用数字值,例如DX
为28
第三步,我必须用数字值替换这些字符值,并将结果存储为"281234"
我需要这些过程的帮助
I have a value coming from table eg DX1234
For this value I have to find out characters out of the whole value eg DX
2nd step I have to use numberic value for character eg 28 for DX
3rd step I have to replace these character value with numeric value and stored the result as ''281234''
I need help with these process
推荐答案
尝试以下操作:
Try this:
DECLARE @Value NVarChar(255)
SET @Value = 'DX1234'
SELECT SUBSTRING(@Value, PatIndex('%[A-Za-z]%', @Value) , PatIndex('%[0-9]%', @Value)-1) AS MyStringVal
, SUBSTRING(@Value,PatIndex('%[0-9]%', @Value),LEN(@Value)) AS MyNumericVal
尝试一下...
Try this...
DECLARE @STRING NVARCHAR(10)
SET @STRING = 'DX1234'
SELECT REPLACE(@STRING,SUBSTRING(@STRING,PatIndex('%[A-Za-z]%',@STRING),
PatIndex('%[0-9]%', @STRING)-1),'28')
谢谢
Thank you
这篇关于如何区分字符串中的字符与数字的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文