如何区分字符串中的字符与数字 [英] 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屋！