cancel
Showing results for 
Search instead for 
Did you mean: 

Utility - Strings Get CSV as Collection adds reduntant Columns when schema is specified

mikolaj_mackowi
Level 3
Hi I noticed a bug in Blue Prism Utility - Strings, action Get CSV As Collection. When you provide a schema and you select that first row is not a header row, action will produce in the output collection additional, empty columns named Column X where X is N...N+(N-1) and N is number of rows in provided schema. Please take a look at the code stage and fix it. Utility file I'm using was attached to BP 5.0.30
2 REPLIES 2

KristianGunnars
Level 2
I have also noticed this. The VBO correctly splits the newlines into seperate rows, but there are additional empty columns amounting to the total amout of commas in the input text, as if there were no newlines. I wonder if the behavior changes if you use Newline+Carriage returns as newlines, instead of only newlines.

Graeme__Tacon
Level 6
Looks like this has been corrected in v6.1.0: Redundant columns are no longer added in the output when using the ParseCSV action which improves performance.