Single row in dt shows as three rows

[Josh_James (Josh)]

Hello,

When I go through each row in a data table after extracting an address from a website, the entire address is extracted as one row. When I look at the output panel, that one row appears as 3 rows. How do I extract each line individually? For example, if I wanted a variable just for the street, a variable for the city, a variable for the state, and a variable for the zip?

Any help would be greatly appriciated.
Thank you!

[ppr (Peter Preuss)]

@Josh_James

When I look at the output panel, that one row appears as 3 rows. How do I extract each line individually?

looks like the data column value is a string with line breaks

we can split by:

Assign Activity:
arrLines =

CurrentRow("YourAddressColName").toString.Trim.Split({Environment.NewLine}, StringSplitOptions.RemoveEmptyEntries)

[ppr (Peter Preuss)]

@Josh_James

if I wanted a variable just for the street, a variable for the city, a variable for the state, and a variable for the zip?

similar to the linebreak split we can repeat it on the line values for a split on comma

Alternates are to replace in the origin string line breaks and comma with a dedicated chararacter (e.g. |) and then split it on this character

[Josh_James (Josh)]

Hi Peter! Thanks for the reply.

Hmm, Did I do this wrong? Sort of looks the same.

[ppr (Peter Preuss)]

we cannot derrive all details from your screenshots. Also we are in doubts, why it is nested looped over the itemArray

debuging / prototyping we can do within the debugging panels e.g immediate panel

Understanding the 6 Debugging Panels of UiPath in the easiest way possible!

One of the very important topic of UiPath in Debugging is understanding the different debugging panels and when to use which panel during debugging. In this video, we will understand all the 6 debugging panels of UiPath in the easiest way possible. Video Link: Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - YouTube

also have a look here:

strText = CurrentRow(“YourAdrssColNameOrIndex”).toString.Trim

arrValues =

System.Text.RegularExpressions.Regex.Split(strText,"\r?\n|,").select(function (x) x.Trim).ToArray

[Josh_James (Josh)]

No real reason for the nesting. I was trying other ideas from different forum posts. I think we’re getting closer though!

Would this then be followed by a “for each” loop to go through each string?

Then, for the “State Zip” string, would I need to use RegEx to split that up, too? Sorry, I haven’t used RegEx very much.

[ppr (Peter Preuss)]

@Josh_James

Would this then be followed by a “for each” loop to go through each string?

we have split and it depends on what you will later do for processing

• we can loop
• we can access directly

[ppr (Peter Preuss)]

@Josh_James

I haven’t used RegEx very much.

[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…

[Josh_James (Josh)]

Oh ok great! Now that I think of it, accessing directly might be the way to go. We may run into addresses that have a “street line 2” for things like apartment numbers, so I could do an “if” statement for how many results I get in the array…

This has been a huge help, thank you so much!!

[ppr (Peter Preuss)]

@Josh_James

how many results I get in the array

have a look for the length retrieval

[Josh_James (Josh)]

That’s perfect, thank you so much!