问题描述
我要搜索以下文本:
#S7Z OK
#Wed Feb 18 07:16:26 GMT 2015
expiration=10.0
lastModified=1424192425832
length=466472
path=/name/_master_/563/5638ad54-8079-4399-ba2b-3257b6e6c7fd.pdf
userType=
每个=后面的单词是属性的名称.对于每个属性名称，我想获取属性值.这意味着我正在寻找一个与regexp_substr一起使用的正则表达式，以获取每个已知属性的值.
The words proceeding each = are the names of properties. For each property name, I'd like to get the property value. That means I'm looking for a regular expression to use with regexp_substr to get the value of each known property.
类似这样的东西:
SELECT REGEXP_SUBSTR(
'#S7Z OK
#Wed Feb 18 07:16:26 GMT 2015
expiration=10.0
lastModified=1424192425832
length=466472
path=/name/_master_/563/5638ad54-8079-4399-ba2b-3257b6e6c7fd.pdf
userType=',
'path=.+')
FROM dual
返回:路径=/名称/主控/563/5638ad54-8079-4399-ba2b-3257b6e6c7fd.pdf
which returns:path=/name/master/563/5638ad54-8079-4399-ba2b-3257b6e6c7fd.pdf
但是我只想要一个值，即"/name/master/563/5638ad54-8079-4399-ba2b-3257b6e6c7fd.pdf".它也应该适用于到期时间，lastModified等，也就是说，我不仅要搜索url，而且要搜索任何类型的值.
But I only want the value, that is "/name/master/563/5638ad54-8079-4399-ba2b-3257b6e6c7fd.pdf ".It should also work for expiration, lastModified etc., that is, I don't just want to search for a url but any kind of value.
如何用一个正则表达式实现呢?
How can I achieve that in one regular expression?
推荐答案
SELECT REGEXP_SUBSTR(
'#S7Z OK
#Wed Feb 18 07:16:26 GMT 2015
expiration=10.0
lastModified=1424192425832
length=466472
path=/name/_master_/563/5638ad54-8079-4399-ba2b-3257b6e6c7fd.pdf
userType=',
'path=(.+)', 1, 1, null, 1)
FROM dual;
这篇关于Oracle中REGEXP_SUBSTR的正则表达式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！