Files with identical content, random order?

[peterl]

I need to compare CSV files that should have identical (mostly, see below) content, but the lines can be in any order. It's possible to sort the lines, but you need to use multiple key fields to do it. One of the fields needs to be ignored in order to match lines.

Is there any way to do this in BC? I know I could write a small utility to recurse through the lines in each file, but I'd like to do it in BC if possible.

Thanks.

-Pete

[Chris]

Re: Files with identical content, random order?

Your best option for comparing these files is with our Data Viewer plug-in. The Data Viewer will let you mark fields as key fields, then sort on those fields before comparison.

The Data Viewer is on our plug-ins page: http://www.scootersoftware.com/download.php?c=v2plugins

If the Data Viewer isn't an option, you can use the Sort rule for the File Viewer, but it sorts on whole lines of text. The Sort rule is at: http://www.scootersoftware.com/downl...c=kb_morerules