Address extraction

Hi all, i want to extract the all address from this string , regex should be generic one . can any one help to separate this ?
sometimes address may come jointly as like attached.
image

i/p :
ABC MEDICAL CENTER
PO BOX 134
WILSON, NC 27234
SIVER BANK
4235 EXECUTIVE SQ STE 140
LAY JOLLA GA 22037ABC MEDICAL CENTER
PO BOX 134
WILSON, NC 27234
ABC MEDICAL CENTER
P.O.BOX 1624
MILSON, NC 2084
ABC MEDICAL CENTER
P.O.BOX 1689
MILSON, NC 20834
ABC MEDICAL CENTER
P.O.BOX 1625
MILSON, NG 27812

Thank u :slight_smile:

As a tidy up for the second part of your question I got this using the Regex101 website :-
Two groups
1st group start with a space and has digits
2nd group ends with a space and doesn’t have digits
Replace with a newline between the two groups.

For the first part it may be possible to use lookaheads behinds based on the word BOX or .BOX as a reference. Will have a think

Thank you for your response @roy_r :slight_smile: Blindly we can not go like this some address gets from this i just pasted sample one , i tried as much as possible still i dont found the solution.

Hi @reachRPA,

Try this with different inputs,

regexAddress.xaml (8.0 KB)

let me know if any issues!

Thanks!

1 Like

sure @kadiravan_kalidoss

Hatsoff @kadiravan_kalidoss , your solution is perfect one :slight_smile: for few cases its 2 addresses appended with single address other than that no issues. Thank you so much really i wondered :)i reached out u in personal chat for that appaded issue. please check your message.

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