Looking for a regex solution:
\[[^\[\]]*\]\s*[<>|<=|>=|=|>|<]\s*'?"?\w*'?"?
This regex is designed to parse equations like:
[household_roster_relationships_topersona_nameadditionalpersono] = "1"
It works well with operators such as
'=','>','<'.
However, when dealing with operators like
'<=','>=','<>'.
The parsing stops at the first character of
'<=','>=','<>'.
A demo has been created on regex101
How can this regex be corrected to handle these situations?