Hey guys.
I need to get values per line from a pdf.
I’m using PDF reading activities
could someone help me on how to capture values per line in the regex? or another way that works.
I need the robot to get the numeric value from the “TEST” line
I used to get this value with the expression ‘(?<=TEST)\s+(\d+,\d)’
but the name “TEST” is not standard, so I should only be able to capture through the line.teste.txt (537 Bytes)
ppr
(Peter Preuss)
September 16, 2021, 9:04pm
2
With testw and not test
With an Placeholder give a try on
Refering on Groups
With wildcarding TEST for TESTE:
1 Like
thank you very much, fantastic !!
just a question, I can only get the value of “TEST” Only with this logic of lines?
(^.?)(?:[\s] )([\d,.]+$)
he ended up selecting all the values, would be able to just capture the values of “TESTE”?
For example
only this value 7,9
ppr
(Peter Preuss)
September 16, 2021, 9:21pm
4
please use </> button for patterns, so we can see all
Always refer also to groups when inspecting results
thanks for trying to help
Cliente Informações Montante (MWh)
DYSNEAY POPOJ Consumo 1.438,082
Perdas (3,0%) 43,142
Período de Suprimento PROINFA 27,348
ago/21 Necessidade 1.453,876
Contratos (Take %) Montante (MWh)
ABCDETAL (150%) 1.445,964
TESTE 7,912
Total Contratos 1.453,876
ppr
(Peter Preuss)
September 16, 2021, 9:40pm
6
i am not sure if i got your questions as some other statements do have additional info within the group. Maybe you can reformulate the question that we can help to finalize your case. Thanks for support
I asked another question at the gym, with the </>
because it looks like there was a problem in this topic
would be this here
Cliente Informações Montante (MWh)
DYSNEAY POPOJ Consumo 1.438,082
Perdas (3,0%) 43,142
Período de Suprimento PROINFA 27,348
ago/21 Necessidade 1.453,876
Contratos (Take %) Montante (MWh)
ABCDETAL (150%) 1.445,964
TESTE 7,912
Total Contratos 1.453,876