Get PO Box Address Regex

[Destiny_Malone]

Regex:

((P\sO\sBox\s\d{3}\n)(.*?(?<=,\s[A-Z]{2}\s\d{5}[-]\d{4})))

PDF string:

blah blah
P O Box 111
Apples, CD 87956-8888
blah blah

Blah blah

[Destiny_Malone]

Ui Path Matches returns Null and Regexr returns what is needed.

[Anil_G (Anil Gorthi)]

@Destiny_Malone

Please try this

cheers

[Steven_McKeering]

Welcome @Destiny_Malone to the UiPath Community Forums

Take a look here at this Regex Pattern:
^P\s?O\s+Box\s+.*

It will also handle when there are no spaces between ‘P’ and ‘O’

.NET Regex Tester - Regex Storm

Hopefully this helps you

Cheers

Steve

[Yoichi]

Hi,

@Destiny_Malone

Ui Path Matches returns Null and Regexr returns what is needed.

Probably it’s linebreak matter. Can you try to add \r? to your pattern as the following?

((P\sO\sBox\s\d{3}\r?\n)(.*?(?<=,\s[A-Z]{2}\s\d{5}[-]\d{4})))

Regards,

[Parvathy (PS Parvathy)]

Hi @Destiny_Malone

Try the following regex expression:

(?<=[A-Z\s])\d+\n(.*)

Hope it helps!!
Regards,

[Destiny_Malone]

This was the solution, thank you!