如何在TSQL中提取两个特殊字符之间的字符串 [英] How to extract strings between two special characters in TSQL

问题描述

如何编写 TSQL 脚本从Email_Monday_Miami_June"中取出Monday_Miami"

How to write TSQL script to get "Monday_Miami" out of "Email_Monday_Miami_June"

本质上，我想提取第 1 个和第 3 个_"之间的所有内容

Essentially, I want to extract everything between 1st and 3rd "_"

感谢一百万

推荐答案

DECLARE @c varchar(100)
SET     @c = 'Email_Monday_Miami_June' 

SELECT SUBSTRING(
    @c, 
    CHARINDEX('_', @c) + 1, 
    LEN(@c) - CHARINDEX('_', @c) - CHARINDEX('_', REVERSE(@c))
)

返回

Monday_Miami

这篇关于如何在TSQL中提取两个特殊字符之间的字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！