Using Regex in UiPath Studio X

Help StudioX
1

i’m trying to capture the address from one of the websites, and the get text gives me an out put as follows

19900 Bay Street, Suite 212300, P.O. Box 485Commerce StationToronto, OntarioM9L 5G9

The actual output should look like the following

19900 Bay Street, Suite 212300, P.O. Box 485
Commerce Station
Toronto, Ontario
M9L 5G9

The observation is that, the line breaks are not appearing in the output
Any suggestions on how to generate the expected out put would be great

2

Identifying the pattern to insert the line break in the above given text , is impossible to complex I guess.

Because, how do we know we have to insert the line break after 485, addresses will vary for every cases right.

Since the Province and the postal code has fixed bytes , we can split as shown below…

image
image1032×113 5.38 KB

3

Below are few examples for different patterns

Bot output:
19900 Bay Street, Suite 212300, P.O. Box 485Commerce StationToronto, OntarioM9L 5G9

Expected output:
19900 Bay Street, Suite 212300, P.O. Box 485
Commerce Station
Toronto, Ontario
M9L 5G9

Bot output:
20 Bay StreetSuite 900Toronto, OntarioM6J 9k4

Expected output:
20 Bay Street
Suite 900
Toronto, Ontario
M6J 9k4

Bot output:

That is right Prasath, as of now I have used the send keyboard shortcuts activity to send Ctrl+C on the required address block and used write from Clipboard to solve this in Studio X