How to split address

Help
,
1

i want to split address 5700 DOT COM CT STE 1000
Oviedo, FL 32435-3400

i want to paste this values in fields as

Addess-5700 DOT COM CT STE 1000
City-Oviedo
State-FL
ZIP-32435-3400

2

Need some more address data to make a general regex

3

Hi @T_Y_Raju

To get address u can use below regex pattern

[A-z]+\n

To get the city use the regex

\n[A-z]+

To get zipcode

(?<=FL).*

USE THESE REGEX

Hope it’s helps you

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed::relaxed:

4

@T_Y_Raju - Here you go…Below will match most of the US addresses(Assuming address 1 & address 2 will always comes in the first line, because in US sometimes address 2(Like Ste, Apt, etc) prints in 2nd line…

image
image940Ă—654 29.3 KB

Group1 = Address
Group2=City
Group3=State
Group4=Zip Code

You have to write, youregexvariable(0).groups(1).tostring to get address…

Refer this post on how to get group variables…

1 Like
5

how to build code iam not aware can you plz share the code it would be very helpful

6

can you Please help he with code, that would really help he i am new to UIpath Technology

7

hi @T_Y_Raju - As i mentioned above Refer this post about Regex… Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more…

To get to know about Regex, please spend 30 mins and go through this video

8

Hi @T_Y_Raju – Please find the starter help here…Regex_Address_Raju.zip (34.9 KB)

9

@T_Y_Raju - Did you get a chance to test the solution provided? If yes, then please mark my post as solution which will close this thread and help others looking for the solution.

10

Hi @T_Y_Raju,

Refer below link it might help you:

Thanks!