Please enable JavaScript to use regex101
/
^
r
e
g
e
x
[
\
-
_
]
?
1
0
1
$
/
i
Reg
ular
Ex
pressions
101
Upgrade to Pro
Enterprise
Regular Expression
/
(?<!<saw:columnHeading>).<saw:displayFormat>(.*?)<\/saw:displayFormat>.(?!<\/saw:columnHeading>)
/
sg
Input 1
1
New
<saw:column columnID="c83" xsi:type="saw:regularColumn"> <saw:displayFormat> <saw:formatSpec visibility="hidden" suppress="default" interaction="default" wrapText="true"/> </saw:displayFormat> <saw:columnHeading> <saw:displayFormat> <saw:formatSpec interaction="default"/> </saw:displayFormat> </saw:columnHeading> <saw:columnFormula> <sawx:expr xsi:type="sawx:sqlExpression">max("Supply Fact"."Count")</sawx:expr></saw:columnFormula> </saw:column>
Extraction
<saw:column columnID="c83" xsi:type="saw:regularColumn"> <saw:displayFormat> <saw:formatSpec visibility="hidden" suppress="default" interaction="default" wrapText="true"/> </saw:displayFormat> <saw:columnHeading> <saw:displayFormat> <saw:formatSpec interaction="default"/> </saw:displayFormat> </saw:columnHeading> <saw:columnFormula> <sawx:expr xsi:type="sawx:sqlExpression">max("Supply Fact"."Count")</sawx:expr></saw:columnFormula> </saw:column>