Regex in between lines

[Asanka]

Hey,

Can someone help me with a regex to get the text in between “PaymentHistory” and “/PaymentHistory”

I need all text in between that. Fully understand I could use xml to do it but would prefer RegEx. Reason is getting the text in xml format is a bunch more steps. Let me know!

“-PaymentHistory”

“ln literal=“y” No complaints/ln”

"ln literal=“y"Nothing./ln”

“/PaymentHistory”

Had to add in “” to make the text appear “” is actually meant to be < and >

[ghazanfar (Ghazanfar Ali)]

Hi Asanka,

Use below regex

str_Result = System.Text.RegularExpressions.Regex.Match(str_input.tostring,“(?<=PaymentHistory).*(?=/PaymentHistory))”)

Hope it will work. Let me know in case of issue

[Asanka]

@ghazanfar

(?<=PaymentHistory).*(?=/PaymentHistory))

Tried it in the regex tester and no luck! I think it has to do with the data being on different lines

[ghazanfar (Ghazanfar Ali)]

you input string is on same line?

[ppr (Peter Preuss)]

@Asanka
have a look here:

as .* not matching line breaks

we just include \n and \r - last for beeing prepared for the windows world

Pattern:
(?<=<PaymentHistory>)(.|\r|\n)*?(?=</PaymentHistory>)

[Asanka]

@ppr

(?<=)(.|\r|\n)*?(?=)

not working for me:

[ppr (Peter Preuss)]

@Asanka
done with https://regex101.com/

Also working in regexstorm .NET Regex Tester - Regex Storm

in your case just enable the multiline flag. However as it should run within uipath, do quick test there

[Asanka]

@ppr

(?<=)(.|\r|\n)*?(?=)

BOOM! It worked. Thanks so much!