# Converting an array to a csv in script

**URL:** <https://forum.inductiveautomation.com/t/converting-an-array-to-a-csv-in-script/40851>\
**Category:** Ignition\
**Created:** [November 20, 2020, 6:59pm UTC](https://forum.inductiveautomation.com/t/converting-an-array-to-a-csv-in-script/40851 "2020-11-20T18:59:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![retinder.labana](https://avatars.discourse-cdn.com/v4/letter/r/54ee81/32.png) [@retinder.labana](https://forum.inductiveautomation.com/u/retinder.labana)\
**Post date:** [November 20, 2020, 6:59pm UTC](https://forum.inductiveautomation.com/t/converting-an-array-to-a-csv-in-script/40851/1 "2020-11-20T18:59:45Z")

</div>

so when I read the selected rows from a drop down it gives it to me in this format  
: [u’Admin’, u’role101’, u’fgf’, u’uio’, u’oooo’, u’ghggggg’]

But QueryString likes data in the following format  
‘Admin’,‘role101’,‘fgf’,‘uio’,‘oooo’,‘ghggggg’

Right not I am doing alot of for loops and replace funtions to get to that format.

Is it possible to convert it from arraywrapper to the way QueryString wants it’s input in a much cleaner way?

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [November 20, 2020, 7:07pm UTC](https://forum.inductiveautomation.com/t/converting-an-array-to-a-csv-in-script/40851/2 "2020-11-20T19:07:51Z")

</div>

> [@retinder.labana](#):
>
> so when I read the selected rows from a drop down it gives it to me in this format  
> : [u’Admin’, u’role101’, u’fgf’, u’uio’, u’oooo’, u’ghggggg’]

This is just a toString representation of a list object containing string members.

If you want to join those into a string that contains quoted and comma-separated values you can use something like this:

```auto
l = ['foo', 'bar', 'baz']
quoted = map(lambda x: "'%s'" % x, l)
joined = ",".join(quoted)

print joined # prints 'foo','bar','baz'

```

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [November 20, 2020, 7:41pm UTC](https://forum.inductiveautomation.com/t/converting-an-array-to-a-csv-in-script/40851/3 "2020-11-20T19:41:48Z")

</div>

Or if you want a one-liner:

```python
l = ['foo', 'bar', 'baz']
joined = ",".join("'%s'" % item for item in l)

```