Separating Street Name and Number From Property Address Column and Pasting Them In 2 New Columns

[Dorani]

Hi guys,

I have an Excel file that contains records of homeowners in a city. One of the columns is “Property Address” which contains the full address of the owner. I want to separate the street address and the house number and insert them in 2 separate columns called “House Number” and “Street Name” using Regex (Matches Activity). I tried but the new value inserted shows System.Text.RegularExpressions.MatchCollection instead of copied values. I am not a coder, so please explain step by step without coding jargon. Thank you so much!

[Palaniyappan (Forum Leader)]

Hi

Welcome to UiPath community
The queries sounds more generic
So I would recommend to have a view on this thread on how to work with Regex so that u can manipulate as per your need

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…

Hope this helps

Cheers @Dorani

[Srini84 (Srinivas Kadamati)]

@Dorani

Welcome to the forums

Can you share a sample Input and expected output?

Thanks,
Srini