Reading CSV with Unconventional Format

Hi Everyone!

I am having an issue where when trying to read a CSV file it gives an error where there is an issue on line 4 where there is more information than there are headers.

I assume this is due to the fact that there are 3 lines of information above the actual table of data. In the image below this would be A, B and C.

All I want is to actually get that information A,B and C. But I am struggling to get a solution for extracting those lines. I would even take the entire file as a text string if that is possible.

image

If there’s an empty line before the actual table, you can read the csv file as an text file and then loop through the lines until you reach an empty line.

Thank you so much!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.