I am receiving a upstream csv file with content for a downstream system and would like to determine if the previous csv processed is identical and if it is, not process the new file. There is no change date available from source system so I cannot simply compare dates unfortunately. If there are any changes between the two files I must resend everything - so there is no need for a record level compare. I would imagine the best scenario is to do a file based compare. If this is not possible, I could load the csv files into two separate strings and compare. However, I cannot find any string functions to compare other than perhaps find text position and perhaps running it twice for each string direction.
Any advice on the best solution pattern for this problem?