slimronnie
New Member
Hi All,
I've got an issue that I'm really struggling to resolve and hoping that someone may be able to assist? My process downloads a CSV file and then opens it in Excel, removes some of the columns and then uses the "Save as CSV" from an extended Excel VBO. However, the downloaded CSV file has dates in the UK format (dd/mm/yyyy), but after removing a couple of columns and saving the file, the dates switch format to US format (mm/dd/yyyy), which is causing a problem further down the line in the process. If I carry out the steps manually (not in BP) on the same machine, the dates do not switch, so I'm suspecting it's VBO or Blue Prism related. I can't import the data as a collection as there's about 180,000 rows of data and will cause memory issues in BP. Is there any code I can add to the VBO to force it to keep the UK date format when saving as CSV?
Many thanks in advance.
I've got an issue that I'm really struggling to resolve and hoping that someone may be able to assist? My process downloads a CSV file and then opens it in Excel, removes some of the columns and then uses the "Save as CSV" from an extended Excel VBO. However, the downloaded CSV file has dates in the UK format (dd/mm/yyyy), but after removing a couple of columns and saving the file, the dates switch format to US format (mm/dd/yyyy), which is causing a problem further down the line in the process. If I carry out the steps manually (not in BP) on the same machine, the dates do not switch, so I'm suspecting it's VBO or Blue Prism related. I can't import the data as a collection as there's about 180,000 rows of data and will cause memory issues in BP. Is there any code I can add to the VBO to force it to keep the UK date format when saving as CSV?
Many thanks in advance.