Data Scraping: separated Columns


#1

Hey :slight_smile:

my results of data scraping are displayed in a row separated by a comma in my csv file. How can I get separate columns? And my original column heading are now the first value in the csv file. How cann I get them back as Headers?

Thanks :slight_smile:


#2

Are you sure scrape Data Extract doesn’t work - this would identify as a table.

If not, then you will have to loop through each line in the datatable and use the split function based on the comma. For the headers, add the list to an array and then loop through this and use Invoke Method to update the column headers in your datatable.

Bit ugly, there may be a better solution.

RD


#3

Thanks :slight_smile: