# Convert arraylist to string

**URL:** <https://forum.uipath.com/t/convert-arraylist-to-string/25925>\
**Category:** Help\
**Tags:** system, activities\
**Created:** [March 16, 2018, 7:14pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925 "2018-03-16T19:14:06Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![sambana\_karunakar](https://avatars.discourse-cdn.com/v4/letter/s/e9c0ed/32.png) [@sambana\_karunakar](https://forum.uipath.com/u/sambana_karunakar)\
**Post date:** [March 16, 2018, 7:14pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/1 "2018-03-16T19:14:06Z")

</div>

Cna some pelase help me on How to print Values in Array variable as string.  
As I created an Array varaible and it is storing the values as a list and I wanted to print those values.

---

<div class="post-metadata">

**Author:** ![MAHESH1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/mahesh1/32/266732_2.png) [@MAHESH1](https://forum.uipath.com/u/MAHESH1)\
**Post date:** [March 16, 2018, 7:21pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/2 "2018-03-16T19:21:23Z")

</div>

@sambana_karunakar

**string.join(“,”,ArrayVariable)**  
This will prient all the elements of your array seperated by comma

Regards,  
Mahesh

---

<div class="post-metadata">

**Author:** ![sambana\_karunakar](https://avatars.discourse-cdn.com/v4/letter/s/e9c0ed/32.png) [@sambana\_karunakar](https://forum.uipath.com/u/sambana_karunakar)\
**Post date:** [March 16, 2018, 7:23pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/3 "2018-03-16T19:23:16Z")

</div>

@MAHESH1 I need like one by one list not in same line, how to do that

---

<div class="post-metadata">

**Author:** ![MAHESH1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/mahesh1/32/266732_2.png) [@MAHESH1](https://forum.uipath.com/u/MAHESH1)\
**Post date:** [March 16, 2018, 7:24pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/4 "2018-03-16T19:24:53Z")

</div>

@sambana_karunakar

**string.Join(Environment.NewLine,Array\_Variable)**

Regards,  
Mahesh

---

<div class="post-metadata">

**Author:** ![sambana\_karunakar](https://avatars.discourse-cdn.com/v4/letter/s/e9c0ed/32.png) [@sambana\_karunakar](https://forum.uipath.com/u/sambana_karunakar)\
**Post date:** [March 16, 2018, 7:39pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/5 "2018-03-16T19:39:19Z")

</div>

@MAHESH1 Sorry some thing is missed not getting expcted results. let me tell you,  
I have an CSV file and in with 2ncloumn has many and only few row are has data remaining are empty. and I need the non empty cell vaules to store in a Array varaible and I wanted to print the those stored values in a mail body. this is my requirement

 ![image](https://global.discourse-cdn.com/uipath/original/2X/9/93a04fe5619f7c227538b97684940de992581655.png) ![image](https://global.discourse-cdn.com/uipath/original/2X/f/f1785f19336e7a485f1fa6b46583585a270e3df2.png) please check and help me at print all values in one mail as of now gettiing each values in each mails let say if there are five cells has data it is sending five mails. i need five values to print in one mail. if put the outlook activity outside of the for each loop it is sending only one mail with printing last cell value.(like fifth value out of five).

---

<div class="post-metadata">

**Author:** ![MAHESH1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/mahesh1/32/266732_2.png) [@MAHESH1](https://forum.uipath.com/u/MAHESH1)\
**Post date:** [March 16, 2018, 7:52pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/6 "2018-03-16T19:52:04Z")

</div>

@sambana_karunakar  
What is the datatype of **list** you are using

Regards,  
Mahesh

---

<div class="post-metadata">

**Author:** ![sambana\_karunakar](https://avatars.discourse-cdn.com/v4/letter/s/e9c0ed/32.png) [@sambana\_karunakar](https://forum.uipath.com/u/sambana_karunakar)\
**Post date:** [March 16, 2018, 7:56pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/7 "2018-03-16T19:56:45Z")

</div>

list is string

---

<div class="post-metadata">

**Author:** ![MAHESH1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/mahesh1/32/266732_2.png) [@MAHESH1](https://forum.uipath.com/u/MAHESH1)\
**Post date:** [March 16, 2018, 7:57pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/8 "2018-03-16T19:57:35Z")

</div>

@sambana_karunakar

Create a Variable of ListOf Strings **List\_Names**  
Use **Add to Collections** Activity  
Add row(“Column-1”).ToString to collections i.e List\_Names

At last outside for each  
strA=string.Join(Environment.NewLine,List\_Names)

Regards,  
Mahesh

---

<div class="post-metadata">

**Author:** ![MAHESH1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/mahesh1/32/266732_2.png) [@MAHESH1](https://forum.uipath.com/u/MAHESH1)\
**Post date:** [March 16, 2018, 7:58pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/9 "2018-03-16T19:58:23Z")

</div>

@sambana_karunakar  
If its a string then definitely it will contain only the last value.

Regards,  
Mahesh

---

<div class="post-metadata">

**Author:** ![arivu96](https://avatars.discourse-cdn.com/v4/letter/a/ebca7d/32.png) [@arivu96](https://forum.uipath.com/u/arivu96)\
**Post date:** [March 16, 2018, 8:00pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/10 "2018-03-16T20:00:58Z")

</div>

Hi @sambana_karunakar,

First get the column value for. The datatable to array.(use linq to get the column value to array)  
@MAHESH1 try linq query to get all the value

Then use  
string.Join(Environment.NewLine,Array\_Variable)

If you use for each Loop each time you will get mail with single value

Regards,  
Arivu

---

<div class="post-metadata">

**Author:** ![MAHESH1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/mahesh1/32/266732_2.png) [@MAHESH1](https://forum.uipath.com/u/MAHESH1)\
**Post date:** [March 16, 2018, 8:05pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/11 "2018-03-16T20:05:12Z")

</div>

@sambana_karunakar  
Let us take you are having a datatable **dta**  
**No need to use foreach row**  
**List A-List of Strings** -Use in Assign Activity

ListA=(From p in dta.Select()  
where not string.IsEmpty(Convert.ToString(p.Item(“Column-1”)))  
Select Convert.ToString(p.Item(“Column-1”))).ToList()

string a=string.join(Environment.NewLine,ListA)

Regards,  
Mahesh

---

<div class="post-metadata">

**Author:** ![arivu96](https://avatars.discourse-cdn.com/v4/letter/a/ebca7d/32.png) [@arivu96](https://forum.uipath.com/u/arivu96)\
**Post date:** [March 16, 2018, 8:08pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/12 "2018-03-16T20:08:45Z")

</div>

Good work @MAHESH1,

@sambana_karunakar use this code

> [@MAHESH1](#):
>
> No need to use foreach row
> 
> List A-List of Strings-Use in Assign Activity
> 
> ListA=(From p in dta.Select()
> 
> where not string.IsEmpty(Convert.ToString(p.Item(“Column-1”))
> 
> Select Convert.ToString(p.Item(“Column-1”))).ToList()
> 
> string a=string.join(Environment.NewLine,ListA)

Small change

`string a=string.join(Environment.NewLine,ListA.ToArray())`

Pass this string value to mail and send it

Regards,  
Arivu

---

<div class="post-metadata">

**Author:** ![MAHESH1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/mahesh1/32/266732_2.png) [@MAHESH1](https://forum.uipath.com/u/MAHESH1)\
**Post date:** [March 16, 2018, 8:09pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/13 "2018-03-16T20:09:44Z")

</div>

@arivu96  
I think even if its list also it will join.

Regards,  
Mahesh

---

<div class="post-metadata">

**Author:** ![arivu96](https://avatars.discourse-cdn.com/v4/letter/a/ebca7d/32.png) [@arivu96](https://forum.uipath.com/u/arivu96)\
**Post date:** [March 16, 2018, 8:10pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/14 "2018-03-16T20:10:35Z")

</div>

Yes correct. I did’t noticed. 🙂

---

<div class="post-metadata">

**Author:** ![MAHESH1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/mahesh1/32/266732_2.png) [@MAHESH1](https://forum.uipath.com/u/MAHESH1)\
**Post date:** [March 16, 2018, 8:11pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/15 "2018-03-16T20:11:59Z")

</div>

@arivu96

No problem 😀

Regards,  
Mahesh

---

<div class="post-metadata">

**Author:** ![sambana\_karunakar](https://avatars.discourse-cdn.com/v4/letter/s/e9c0ed/32.png) [@sambana\_karunakar](https://forum.uipath.com/u/sambana_karunakar)\
**Post date:** [March 16, 2018, 8:12pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/16 "2018-03-16T20:12:28Z")

</div>

Hey I am getting error inthis can you correct it again

(From p in dt.Select()  
where not string.IsEmpty(Convert.ToString(p.Item(“Column-1”))  
Select Convert.ToString(p.Item(“Column-1”))).ToList()

---

<div class="post-metadata">

**Author:** ![MAHESH1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/mahesh1/32/266732_2.png) [@MAHESH1](https://forum.uipath.com/u/MAHESH1)\
**Post date:** [March 16, 2018, 8:13pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/17 "2018-03-16T20:13:51Z")

</div>

@sambana_karunakar  
Replace **dt** with your datatable variable

Regards,  
Mahesh

---

<div class="post-metadata">

**Author:** ![sambana\_karunakar](https://avatars.discourse-cdn.com/v4/letter/s/e9c0ed/32.png) [@sambana\_karunakar](https://forum.uipath.com/u/sambana_karunakar)\
**Post date:** [March 16, 2018, 8:14pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/18 "2018-03-16T20:14:56Z")

</div>

dt is my data varaible

---

<div class="post-metadata">

**Author:** ![MAHESH1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/mahesh1/32/266732_2.png) [@MAHESH1](https://forum.uipath.com/u/MAHESH1)\
**Post date:** [March 16, 2018, 8:15pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/19 "2018-03-16T20:15:40Z")

</div>

@sambana_karunakar  
Can you share the screen shot of error  
Regards  
Mahesh

---

<div class="post-metadata">

**Author:** ![sambana\_karunakar](https://avatars.discourse-cdn.com/v4/letter/s/e9c0ed/32.png) [@sambana\_karunakar](https://forum.uipath.com/u/sambana_karunakar)\
**Post date:** [March 16, 2018, 8:22pm UTC](https://forum.uipath.com/t/convert-arraylist-to-string/25925/20 "2018-03-16T20:22:08Z")

</div>

![image](https://global.discourse-cdn.com/uipath/original/2X/f/f6d3c96a2761e79a34a59d1b14586698c1ce2028.png)please chcek

[Next page](https://forum.uipath.com/t/convert-arraylist-to-string/25925.md?page=2)
