Tried to google answer,but couldn’t find it.
So I have a problem with .csv files. I’m downloading reports in .csv format from a system. Problem is that these .csv files include declaration row for Excel (first row is “sep=;”), this makes it so that the UiPath Read CSV activity gives an error: Read CSV : The CSV file format for FILEPATH\FILE.csv is invalid
When I remove the first row manually Read CSV activity works. I can ofcourse remove the rows by opening the csv files on notepad and deleting the first row, but I was wondering if there is a more elegant way. So my question is that is there a easier way to either ignore the declaration on .csv file or delete the first row?
And before anyone asks no it’s not possible to get the .csv files without the Excel separator declaration from the system.