ericwenger1 (3/5/2015)
I need to be able to see if the incoming csv file had a head row different than the previous files header row. That will tell me that I have new columns.
The easiest thing to do would be to just read the first row as one large blob and save it. When the next file comes along, read the header as a blob and do a direct comparison to what you've saved using either "=" or "<>". That will certainly tell you if there's been a change.
If you need to isolate the column names as rows, read the header row and split it.
--Jeff Moden
Change is inevitable... Change for the better is not.