I'm trying to import a .csv file and detect which records in that file have been modified since the last import.
Typical file will have 8,000 records with fields separated by commas and records separated by a paragraph symbol. My idea is to import the file so that each record, that has around 100 fields in it, goes into a field intact as a long field string. Then compare that text string with the last import to find records that have changed.
How to do this, or is there a better to isolate records that have changed?