Regex help 02/14/23

[lynnsong986]

Hello, the pattern works in regex101, but not UiPath. can someone please help? need to capture the amount 117.69

thanks in advance

[supermanPunch (Arpan)]

Hi @lynnsong986 ,

Could you provide us with the text and the regex expression used to check it from our end as well ?

Also, Try by adding a \n after \r? and Check if it works.

[fernando_zuluaga]

Hey

you can easily pass the pattern you’ve created in regex101 like this
Regex.Match(yourStringVar, “yourPatternHere”).Value

Regards!

[lynnsong986]

For HSE_MTR 50 BARBARA AVE EL Monthly Serv Chg (based on the 30 days) . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 117.69
Billing Period of 30 days . S. S. . B. i. lli n. . . c. h. a. r. g e. . . . . . . . . . . . . . . . … … … … … … … . . . . . . . . . . . . . . . . . . . . . . g (based on the 30 days) $ 0.25
S
Nov 06, 2022 to Dec 06, 2022 C B. R. . C. l. as. . . B. C. . h. a. r. g. e. . …s . . . … . . . … . … . . … . . . … … . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 6.20
. . .

in this the number of lines may change…I need to capture the 117.69, not the 0.25, nor the 6.2…thanks!

[supermanPunch (Arpan)]

@lynnsong986 ,

Check with the below Regex Expression :

(?<=EL Monthly Serv Chg.*\$).*

Test it with different data and let us know if it doesn’t work for any of the data.

[lynnsong986]

Thank you so much, works perfectly!