Regular expression to substitute (VIV6a = 1 or VIV6b = 1) and (COUNT ("A3"; "13") = 0 or COUNT ("A3"; "14") = 0)

0

I have this syntax:

(VIV6a=1 or VIV6b=1) and (CONTAR("A3";"13")=0 or CONTAR("A3";"14")=0)

some regular expression that gets me the following:

(VIV6a=1 or VIV6b=1) and ( =0 or =0)

For c #

The idea is to be able to change the expression to replace words other than 'COUNT'

Help Please ...

    
asked by Arturo 23.05.2018 в 22:54
source

1 answer

-1

This Regular Expression should do the job:

CONTAR\(.*?\)
  • CONTAR\( Literal, escaping parentheses
  • .* Any character
  • ?\) The first occurrence of the escaped parenthesis

See demo: link

    
answered by 23.05.2018 в 23:06