Re^2: Comparing strings from different files

Hi McA The records are the same it's just the Record labels that are slightly different:

FILE1:
99INSSCH|248| 99POLCOM|3||CAP01|66|3301R7435459||||| 99INSFAC2|MSRA01_
+1||||||"LNI10708"|
FILE2:
E99INSSCH|248| E99POLCOM|3||CAP01|66|3301R7435459||||| E99INSFAC2|MSRA
+01_1||||||"LNI10708"|
[download]

Where it begins 99(label) or E99(label) that is a new record.

I need to compare the records (not the labels) but I'm not sure how.

Hope this clears things up a wee bit

Comment on Re^2: Comparing strings from different files Download Code

Replies are listed 'Best First'.
Re^3: Comparing strings from different files by hippo (Archbishop) on Oct 08, 2013 at 10:23 UTC
Open file1 and read it in one record at a time Each record should be split into the label and the rest Make the label the hash key and the rest the hash value Close file1 and open file2 and read it in one record at a time Each record should be split into the label and the rest You now have two rows to compare (the current record from file2 and the one stored in the hash keyed on the label from file1), so do that for whatever "compare" means in your task Close file2	[reply]

Replies are listed 'Best First'.

Re^3: Comparing strings from different files
by hippo (Archbishop) on Oct 08, 2013 at 10:23 UTC

Open file1 and read it in one record at a time
Each record should be split into the label and the rest
Make the label the hash key and the rest the hash value
Close file1 and open file2 and read it in one record at a time
Each record should be split into the label and the rest
You now have two rows to compare (the current record from file2 and the one stored in the hash keyed on the label from file1), so do that for whatever "compare" means in your task
Close file2

[reply]