How to match the last number in a row with uipath matches activity?

Build
#1

Hi :slight_smile: ,

I would like to match the last value from each row from a PDF file with matches activity - in a loop.

(?<=\n2019\s.*)([0-9.,-]+$)

The pattern is “quit simple”, but if i apply this pattern in UiPath (Matches activity), it doesn’t work.

ps.: 2019 in the beginning is just an example, a variable will be there

#2

Hello,
can you somehow attach here your workflow?
I have created your process in my Studio, and everything is working fine with this pattern.
This is the output I manage to create. It’s: each line and boolean indicating if Regex match was found.
reg

#3

Dear olgu,

Thank you very much in advance for your cooperation in this regard. To be honest, my main problem is that I can’t use the previously tested pattern in UiPath.

My Workflow:

  • Read PDF Text
  • Matches
  • Assign the Matches result to a variable
  • Write line (for testing purpose…)!
    5Rk9GjF%20-%20Imgur
    What do you think?
#4

Are you using inside of RegEx Builder in UiPath, “Any(0 or more)” in Quantifiers column?

auq
auq.JPG722×69 7.06 KB

#5

Please try to split the input text from PDF by the New Lines, and then for each line: check the pattern.

1 Like
#6

I used an old version of UiPath, with 2019.4.4 there is no problem with the original pattern, works as expected :smiley:. thanks for your cooperation, again. ("(?<="+item.ToString.Trim+".*)([0-9.,-]+($)?)\n").ToString

#7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.