Regular expression failing when there are double spaces in an expression.

nomatch.png

We have created a regular expression to identify a specific pattern. It works well when the expression has no double spaces, but as soon it encounter double space in the expression, it fails.

For example: Show me the stock value for material abc in Q1'2021

Here there is double space between stock and value due to which the regular expression fails. Irrespective of the location of double space in the expression, the regular expression fails to identify.