You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

compare two files using sqr reports

4 replies [Last post]
Guest's picture
Guest

hi all,
i have two csv files with some data.my requirement is differenciate two files.that means compare data in two files and find out in which positions data is different.i should show positions also
could anybody explain it?

CompShack's picture
User offline. Last seen 5 years 41 weeks ago. Offline
Joined: 12/09/2007
Posts: 167
Import your CSV files into tables and compare data

Your title mentioned SQR, is that what you want to use to accomplish the comparison? I would recommend using Application Engine instead. It will make your life a lot easier. You can create filelayout for your CSV files, read data in that way and populate some temp tables. When all done, you can then write a combination of SQL and peoplecode to pull and compare different data. You can read more about file layouts in the PeopleCode API Reference peoplebook under the File Class chapter.

Another way of doing this, is using Oracle External Tables feature to load the data in and perform your comparison. Using oracle's external table feature will save you from creating actual tables in the database to store your data.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

oddsnends's picture
User offline. Last seen 10 years 38 weeks ago. Offline
Joined: 03/28/2008
Posts: 16
How a compare tool?

Not sure what your file layouts are - same number of comma delimited fields? I simply use a compare tool that shows both files side by side and highlights the differences.

It's called Beyond Compare 2. Free trial version avail online. Worth the license though.

CompShack's picture
User offline. Last seen 5 years 41 weeks ago. Offline
Joined: 12/09/2007
Posts: 167
UltraCompare

If you want to go that route, I have used UltraCompare. It is a powerful compare/merge application and not that expensive either.

UltraCompare is developed by the same company that is behind UltraEdit, IMO, the best text editor out there.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

vivek6686's picture
User offline. Last seen 9 years 35 weeks ago. Offline
Joined: 09/27/2010
Posts: 8
Re: compare two folders using sqr reports

hi all,
i just want to compare two folders not files using an sqr,
is it possible to call beyond compare or exam diff tools via sqr,
if so pls let me know.

thanks,
vivek.s