<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Good and working suggestion… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Get-Collection-as-CSV-output-is-not-a-comma-seperated-values/m-p/90704#M40869</link>
    <description>Good and working suggestion by&amp;nbsp;sibi_luke, very useful if any one wants to create csv with delimiter of choice.</description>
    <pubDate>Mon, 14 May 2018 11:27:00 GMT</pubDate>
    <dc:creator>IshanMahajan</dc:creator>
    <dc:date>2018-05-14T11:27:00Z</dc:date>
    <item>
      <title>Get Collection as CSV output is not a comma seperated values??</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-Collection-as-CSV-output-is-not-a-comma-seperated-values/m-p/90700#M40865</link>
      <description>I am using collection as CSV and the output is not&amp;nbsp; comma seperated values. Is this how it works ? Any other action that can give me collection values as CSV ?</description>
      <pubDate>Sun, 18 Mar 2018 17:08:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-Collection-as-CSV-output-is-not-a-comma-seperated-values/m-p/90700#M40865</guid>
      <dc:creator>Sri_Krishna_Cha</dc:creator>
      <dc:date>2018-03-18T17:08:00Z</dc:date>
    </item>
    <item>
      <title>Hi, I am assuming that you…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-Collection-as-CSV-output-is-not-a-comma-seperated-values/m-p/90701#M40866</link>
      <description>Hi, I am assuming that you are familiar with the use of code stage
Create a code stage with 2 input parameters, CSV_File_Name_With_Path and Collection_Input and in the Code tab,&amp;nbsp;paste the below code. Let me know if this does not work. Would be better if you add this as a separate action in the collection manipulation VBO, so that you will have to add only System.Text namespace&amp;nbsp;in the 'Code Option' tab in the Initialise action.
&amp;nbsp;
&amp;nbsp;
&amp;nbsp;

&amp;nbsp;If Collection_Input.Columns.Count = 0 Then Throw new ApplicationException(""Zero columns in collection"")
&amp;nbsp;
&amp;nbsp;Dim objOututStream As StreamWriter
&amp;nbsp;objOututStream = File.CreateText(CSV_File_Name_With_Path)
&amp;nbsp;''Dim Columns As New DataTable
&amp;nbsp;Dim SB As StringBuilder = New StringBuilder()
&amp;nbsp;For intColCnt As Integer = 0 To Collection_Input.Columns.Count - 1
&amp;nbsp;&amp;nbsp;SB.Append("""""""" + Collection_Input.Columns(intColCnt).ColumnName.ToString() + """""""")
&amp;nbsp;&amp;nbsp;If intColCnt  Collection_Input.Columns.Count - 1 Then
&amp;nbsp;&amp;nbsp;&amp;nbsp;SB.Append("","")
&amp;nbsp;&amp;nbsp;End If&amp;nbsp;
&amp;nbsp;Next
&amp;nbsp;SB.Append(vbNewLine)
&amp;nbsp;For intRowCnt As Integer = 0 To Collection_Input.Rows.Count - 1
&amp;nbsp;&amp;nbsp;For intColCnt As Integer = 0 To Collection_Input.Columns.Count - 1
&amp;nbsp;&amp;nbsp;&amp;nbsp;SB.Append("""""""" + Collection_Input.Rows(intRowCnt)(intColCnt).ToString() + """""""")
&amp;nbsp;&amp;nbsp;&amp;nbsp;If intColCnt  Collection_Input.Columns.Count - 1 Then
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;SB.Append("","")
&amp;nbsp;&amp;nbsp;&amp;nbsp;End If
&amp;nbsp;&amp;nbsp;Next
&amp;nbsp;&amp;nbsp;SB.Append(vbNewLine)
&amp;nbsp;Next
&amp;nbsp;objOututStream.WriteLine(SB.ToString())
&amp;nbsp;objOututStream.Close

&amp;nbsp;</description>
      <pubDate>Fri, 23 Mar 2018 19:46:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-Collection-as-CSV-output-is-not-a-comma-seperated-values/m-p/90701#M40866</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-03-23T19:46:00Z</dc:date>
    </item>
    <item>
      <title>If you open the code stage…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-Collection-as-CSV-output-is-not-a-comma-seperated-values/m-p/90702#M40867</link>
      <description>If you open the code stage you will see a list of delimiters in the code.&amp;nbsp; They are set to True or False.&amp;nbsp; Change the setting in the code for the delimiter you need.</description>
      <pubDate>Wed, 04 Apr 2018 12:09:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-Collection-as-CSV-output-is-not-a-comma-seperated-values/m-p/90702#M40867</guid>
      <dc:creator>NevilleWatson</dc:creator>
      <dc:date>2018-04-04T12:09:00Z</dc:date>
    </item>
    <item>
      <title>What is your ultimate goal ?…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-Collection-as-CSV-output-is-not-a-comma-seperated-values/m-p/90703#M40868</link>
      <description>What is your ultimate goal ? i am hoping that you want to store the Collection values as a CSV file, if that is the case you can follow below steps.
&amp;nbsp;
1. Create a single row collection with one field.
2. Use Utility String VBO - &amp;gt; get collection as CSV action.
3. in input provide your collection, in output provide your single row collection field name, note that it is a text field not collection, use collectionName.fieldName
4. Next stage should use Utility File Management VBO - &amp;gt; Write Text file action, input your file name *.csv, in Text input parameter enter your single row collection,&amp;nbsp;use collectionName.fieldName.
&amp;nbsp;
Run the process you should be able to write the collection as CSV file, comma seperated.</description>
      <pubDate>Mon, 14 May 2018 10:42:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-Collection-as-CSV-output-is-not-a-comma-seperated-values/m-p/90703#M40868</guid>
      <dc:creator>IshanMahajan</dc:creator>
      <dc:date>2018-05-14T10:42:00Z</dc:date>
    </item>
    <item>
      <title>Good and working suggestion…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-Collection-as-CSV-output-is-not-a-comma-seperated-values/m-p/90704#M40869</link>
      <description>Good and working suggestion by&amp;nbsp;sibi_luke, very useful if any one wants to create csv with delimiter of choice.</description>
      <pubDate>Mon, 14 May 2018 11:27:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-Collection-as-CSV-output-is-not-a-comma-seperated-values/m-p/90704#M40869</guid>
      <dc:creator>IshanMahajan</dc:creator>
      <dc:date>2018-05-14T11:27:00Z</dc:date>
    </item>
  </channel>
</rss>

