<?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 Sounds like you are opening a in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Split-Columns-with-quot-quot-as-separator/m-p/87673#M38353</link>
    <description>Sounds like you are opening a CSV file in Excel. You could try reading the file directly with Utility - Strings.Get CSV As Collection</description>
    <pubDate>Tue, 31 Oct 2017 18:08:00 GMT</pubDate>
    <dc:creator>John__Carter</dc:creator>
    <dc:date>2017-10-31T18:08:00Z</dc:date>
    <item>
      <title>Split Columns with "," as separator</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Split-Columns-with-quot-quot-as-separator/m-p/87672#M38352</link>
      <description>Hi,

The output of my excel contains one column with all the fieldname in a single row with "," as separator like "Firstname,Lastname,Age,Profession". and this is inside one cellbox.

Kindly advise how can I split the field to separate columns using either MS Excel VBO or Collection Manipulation.

Thanks
Ahmed B</description>
      <pubDate>Mon, 30 Oct 2017 16:11:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Split-Columns-with-quot-quot-as-separator/m-p/87672#M38352</guid>
      <dc:creator>AhmedBasheer_M</dc:creator>
      <dc:date>2017-10-30T16:11:00Z</dc:date>
    </item>
    <item>
      <title>Sounds like you are opening a</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Split-Columns-with-quot-quot-as-separator/m-p/87673#M38353</link>
      <description>Sounds like you are opening a CSV file in Excel. You could try reading the file directly with Utility - Strings.Get CSV As Collection</description>
      <pubDate>Tue, 31 Oct 2017 18:08:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Split-Columns-with-quot-quot-as-separator/m-p/87673#M38353</guid>
      <dc:creator>John__Carter</dc:creator>
      <dc:date>2017-10-31T18:08:00Z</dc:date>
    </item>
  </channel>
</rss>

