in reply to Comparing strings from different files

You don't need a script. One look showed me: They are different...

Of course just kidding: You have to explain when two files are equal and when they are different. Where are the records, where are the fields? Even the field names seem to be different.

McA

  • Comment on Re: Comparing strings from different files

Replies are listed 'Best First'.
Re^2: Comparing strings from different files
by Jalcock501 (Sexton) on Oct 08, 2013 at 10:03 UTC
    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
[reply]
[d/l]
      1. Open file1 and read it in one record at a time
      2. Each record should be split into the label and the rest
      3. Make the label the hash key and the rest the hash value
      4. Close file1 and open file2 and read it in one record at a time
      5. Each record should be split into the label and the rest
      6. 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
      7. Close file2
[reply]

In Section Seekers of Perl Wisdom