I have a below word as follows:
“Mrs Sum-130200 80 ADDRI-152823 ADDR3-152823 ADDR4-152823 NP20 9AU”
I want it to be extracted separately as below :
Mrs Surn-130200
80 ADDR1-152823
ADDR3-152823
ADDR4-152823
NP20 9AU
I have a below word as follows:
“Mrs Sum-130200 80 ADDRI-152823 ADDR3-152823 ADDR4-152823 NP20 9AU”
I want it to be extracted separately as below :
Mrs Surn-130200
80 ADDR1-152823
ADDR3-152823
ADDR4-152823
NP20 9AU
Maybe following Pattern will help:
Refering to groups:
(Mr.*?\d\b)(.*?ADDR.*?-\d+\b) (ADDR.*?-\d+\b) (ADDR.*?-\d+\b) (.*$)
[CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum