I am looking for a code where I can combine multiple csv files that reside in a folder into a single data frame. It should combine all files within that folder.
The main issue here is that the actual table within these files can start at any line. They can be in line 10 or in line 100 of those files. It is basically a system generated report that creates multiple files, but it always has a summary in the top which is not part of the table. Since the summary can be small or big, the table ends up starting anywhere within those files.
They do have their headers in common though (Total Count, Event Time, Associated Client Count, Authenticated Client Count). And they are always preceded of the words "AP Total Client Count" on the line above before the table starts.
Would really appreciate some help to fix this.