Re: Comparing data between data sources

If you have CSV files already, why not just use:

  % diff old.csv new.csv
[download]

for each of your corresponding files in the set?

pbeckingham - typist, perishable vertebrate.

Comment on Re: Comparing data between data sources Download Code

Replies are listed 'Best First'.
Re^2: Comparing data between data sources by FubarPA (Monk) on Aug 17, 2004 at 15:11 UTC
Well, the problem is there are some minor differences that I have to take into account. For example, the mainframe exports null information as ??? in my CSV file, so I either need to replace that with spaces first, or code for that issue. My other problem is that I'm on Windows, and I don't have a diff utility at my disposal at the moment. Good thought, though. Might come in handy for some of the other validations I have to do to other things down the line.	[reply]
Re^3: Comparing data between data sources by perlfan (Parson) on Aug 17, 2004 at 15:32 UTC
diff comes with Cygwin which can be installed in local user space. Perl also comes with this environment. A quick search of CPAN yields a multitude of "diff" modules.	[reply]