如何在SQL中提取字符串的两个字符之间的所有数据? [英] How do I extract all data in between two characters of a string in SQL ?
本文介绍了如何在SQL中提取字符串的两个字符之间的所有数据?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,
请帮我提取一栏中两个特定字符之间的所有数据。
例如,我在列数据中有数据,例如,
aaaaa(bb(asdads)bbb)
我需要输出像,
aaaaa
提示:需要删除全部(&)字符之间的数据
任何人都可以帮助我在SQL中生成此输出。
我尝试过:
此查询无法正常工作,我希望,
SELECT SUBSTRING('' aaaaa $ bbb $ bb $ ccccc $ ddddd',
CHARINDEX(' $',' aaaaa $ bbbbb $ ccccc') +1,
CHARINDEX(' $',' aaaaa $ bbbbb $ ccccc',CHARINDEX(' $',' aaaaa $ bbbbb $ ccccc')+ 1) -
CHARINDEX(' $',' aaaaa $ bbbbb $ ccccc') - 1) as My_String
解决方案
BBB
BB
CCCCC
Hi Guys,
Please help me out to extract all the data between two particular characters in a column.
For example, I have data in a column data like,
"aaaaa( bb (asdads) bbb )"
And i need the output like,
"aaaaa"
Hint: Need to remove all the data in between "(" & ")" characters
Can anyone help me to get this produce this output in SQL.
What I have tried:
This query is not working properly as i expect,
SELECT SUBSTRING('aaaaa$bbb$bb$ccccc$ddddd',
CHARINDEX('$','aaaaa$bbbbb$ccccc')+1,
CHARINDEX('$','aaaaa$bbbbb$ccccc',CHARINDEX('$','aaaaa$bbbbb$ccccc')+1) -
CHARINDEX('$','aaaaa$bbbbb$ccccc')-1) as My_String
解决方案
bbb
bb
ccccc
这篇关于如何在SQL中提取字符串的两个字符之间的所有数据?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文