<?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 Collection to CSV - Custom Delimiters in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Collection-to-CSV-Custom-Delimiters/m-p/90492#M40692</link>
    <description>Hi All,

I am looking at ways to write a collection to a csv file using custome delimters (changes for different processes, to upload to different systems).

There is a standard object - Utility - Strings (Get collection as CSV) but this defaults using a comma as the delimiter.

It has this code -


Dim SB As New StringBuilder
WriteDataTable(SB, Input_Collection, True)
Output_CSV = SB.ToString()

Â&amp;nbsp;

The WriteDataTable function can i pass it a custom delimter by chance? If not another way to achive this without the need for excel stepping stone?

Thanks

MoD

Â&amp;nbsp;</description>
    <pubDate>Fri, 03 May 2019 15:22:00 GMT</pubDate>
    <dc:creator>MoDCore</dc:creator>
    <dc:date>2019-05-03T15:22:00Z</dc:date>
    <item>
      <title>Collection to CSV - Custom Delimiters</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Collection-to-CSV-Custom-Delimiters/m-p/90492#M40692</link>
      <description>Hi All,

I am looking at ways to write a collection to a csv file using custome delimters (changes for different processes, to upload to different systems).

There is a standard object - Utility - Strings (Get collection as CSV) but this defaults using a comma as the delimiter.

It has this code -


Dim SB As New StringBuilder
WriteDataTable(SB, Input_Collection, True)
Output_CSV = SB.ToString()

Â&amp;nbsp;

The WriteDataTable function can i pass it a custom delimter by chance? If not another way to achive this without the need for excel stepping stone?

Thanks

MoD

Â&amp;nbsp;</description>
      <pubDate>Fri, 03 May 2019 15:22:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Collection-to-CSV-Custom-Delimiters/m-p/90492#M40692</guid>
      <dc:creator>MoDCore</dc:creator>
      <dc:date>2019-05-03T15:22:00Z</dc:date>
    </item>
    <item>
      <title>No, "WriteDataTable" is inâ€¦</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Collection-to-CSV-Custom-Delimiters/m-p/90493#M40693</link>
      <description>No, "WriteDataTable" is in Global code of the VBO and it has no way to pass a separator (and has other issues actually). You better make your own that suits your needs. You can probably useÂ&amp;nbsp;WriteDataTable or solution from this threadÂ&amp;nbsp;as a start, replacing "," with ";","\t" or whateverÂ&amp;nbsp;or just fine a better ones on stackoverflow.
Or you can use some net library, but that adds dependencies, which is not good unless you really need RFC4180 compilant solution with every possible pitfall already though of.Â&amp;nbsp;</description>
      <pubDate>Sun, 05 May 2019 20:58:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Collection-to-CSV-Custom-Delimiters/m-p/90493#M40693</guid>
      <dc:creator>AndreyKudinov</dc:creator>
      <dc:date>2019-05-05T20:58:00Z</dc:date>
    </item>
    <item>
      <title>Hi aikudino,
thanks for theâ€¦</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Collection-to-CSV-Custom-Delimiters/m-p/90494#M40694</link>
      <description>Hi aikudino,
thanks for the info!
I've previously checkted the thread you have linked but couldnt figure out how to add that to the code node in BP, left a comment on that thread about it.
MoD</description>
      <pubDate>Tue, 07 May 2019 10:29:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Collection-to-CSV-Custom-Delimiters/m-p/90494#M40694</guid>
      <dc:creator>MoDCore</dc:creator>
      <dc:date>2019-05-07T10:29:00Z</dc:date>
    </item>
  </channel>
</rss>

