regex – Can anyone help me to write the regular expression to match a number if the next line begins with a word?
In Power Automate Desktop, I want to match 2,021
which is present at the second last word on the third line with the respect of Demand
which the first word of the fourth line.
Input:
Days of
Service
Electric 0156887974 02/24/23 60,170 01/24/23 58,149 1 2,021 31
Demand 0156887974 02/24/23 9.62 01/24/23 10.39 1 9.62 31
MESSAGE from KUA
I have tried this ex:
(?<=Days of+\r\nService+\r\nElectric ……………………………………..)……
from first word of this line but this line have multiple dynamic values and characters of these dynamic values have also increase or decrease and result fail the expression. So now I notice that if I search backward from the value “Demand” ,its not affected by other dynamic values. This value is 4 digit characters with comma(,).
Read more here: Source link