如何从格式化字符串中获取子字符串

How to get a substring from a formatted string(如何从格式化字符串中获取子字符串)

问题描述

我想从 sql 中给定的字符串 Praveen(403162) 中获取子字符串 403162?

I would like to get a substring 403162 from the given string Praveen(403162) in sql?

推荐答案

你可以这样做:

DECLARE @searchString NVARCHAR(20) = 'Praveen(403162)'
DECLARE @startFrom INT= CHARINDEX('(',@searchstring) + 1
DECLARE @length INT = CHARINDEX(')',@searchstring) - @startFrom
SELECT SUBSTRING(@searchstring,@startFrom, @length) AS RESULT

如果您想在一行中执行此操作:

If you want to do this in one line:

DECLARE @searchString NVARCHAR(20) = 'Praveen(403162)'
SELECT SUBSTRING(@searchstring,
       CHARINDEX('(',@searchstring) + 1, 
       CHARINDEX(')',@searchstring) - CHARINDEX('(',@searchstring) - 1) AS RESULT

这篇关于如何从格式化字符串中获取子字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！