I need to compare two files containing same data with different format.
They have following columns
Visit time from
Visit Time to
would need to get a list of all unmatched records.
its only considered a match if all 5 fields are the same.
Attached sample of those files, where record in both files is considered a match.
Here are the differences, one of the files has the following
1- first and last name concatenated into one field.
2- has data in parenthesis after the names which should be ignored.
3- format of time is 1459-2304