match data based on matching field

I work with library cataloguing records and am trying to accomplish this amazing feat.

Trying is no problem, amazing feat is eluding me

I need to find all records with the same ISBN number (field 020)save all matching records which will result in more than 1 record with the same ISBN, then somehow magically end up with only 1 record containing all 856 fields.

We import these record to the database from various vendors, and some titles are exactly the same resulting in the same title being loaded again. Our users hate this. Why not just one title containing all the 856 fields. 856 is the field linking to a title online.

Users could then link to whatever vendor database they like, from one record

The following two records are the same (field 020 and 245) and each links to a different database. In reality more fields would be the same, but being at home I don't have the actual real matching records. I just edited the records so the 020 and 245 field matched.

I would also need to retain the file of matching records before creating the final file of 1 record with multiple 856 fields so I can use some specialized tools here to remove all those records before loading the final file. This is all based on that I will extract these titles from the database into a file as I don't want direct manipulation in the database. I could blow the damn thing up.

Crap, when inserting records from the file a space is being inserted between each field. There should only be a space between each record. My apologies.

LDR 01361cam 2200337La 45{92}0

001 ocm42328454\

003 OCoLC

005 20010526091203.0

006 m\\\\\\\\u\\\\\\\\

007 cr\cn-

008 980708s1998\\\\cou\\\\\sb\\\\000\0\eng\d

010 \\$z 98029457

040 \\$aN{dollar}T$cN{dollar}T$dOCL

020 \\$a0585001448 (electronic bk.)

020 \\$z1555662277

043 \\$an-us---

050 14$aQH104.5.H53$bG55 1998eb

082 04$a508.78$221

049 \\$aM7@A

100 1\$aGilfillan, Merrill,$d1945-

245 10$aPrehistoric astronomy in the Southwest$h[computer file] /$cJ. McKim Malville, Claudia Putnam.

260 \\$aBoulder :$bJohnson Books,$cc1998.

300 \\$a127 p. ;$c22 cm.

504 \\$aIncludes bibliographical references (p. 127).

533 \\$aElectronic reproduction.$bBoulder, Colo. :$cNetLibrary,$d1999.$nAvailable via the World Wide Web.$nAvailable in multiple electronic file formats.$nAccess may be limited to NetLibrary affiliated libraries.

650 \0$aNatural history$zHigh Plains (U.S.)

655 \7$aElectronic books.$2local

710 2\$aNetLibrary, Inc.

776 1\$cOriginal$w(DLC) 98029457$w(OCoLC)39498451

856 4\$3On campus link to Joe's database$uhttp://www.netlibrary.com/urlapi.asp?actionsummary&v1&bookid138$zAn electronic book accessible through the World Wide Web; click for information

856 4\$3Off campus link to Joe's database$uhttp://www.netlibrary.com/urlapi.asp?actionsummary&v1&bookid138$zAn electronic book accessible through the World Wide Web; click for information

994 \\$a92$bM7@

LDR 01616cam 2200397La 45{92}0

001 ocm42328461\

003 OCoLC

005 20010526091203.0

006 m\\\\\\\\u\\\\\\\\

007 cr\cn-

008 930414s1993\\\\coua\\\\sb\\\\001\0\eng\d

010 \\$z 93017712

020 \\$a0585001448 (electronic bk.)

040 \\$aN{dollar}T$cN{dollar}T$dOCL

020 \\$a0585001510 (electronic bk.)

020 \\$z1555661165

043 \\$an-ust--

050 14$aE78.S7$bM135 1993eb

082 04$a522/.0979$220

049 \\$aM7@A

100 1\$aMalville, J. McKim.

245 10$aPrehistoric astronomy in the Southwest$h[computer file] /$cJ. McKim Malville, Claudia Putnam.

250 \\$aRev. ed.

260 \\$aBoulder, Colo. :$bJohnson Books,$cc1993.

300 \\$a108 p. :$bill. ;$c23 cm.

504 \\$aIncludes bibliographical references (p. [99]-104) and index.

533 \\$aElectronic reproduction.$bBoulder, Colo. :$cNetLibrary,$d1999.$nAvailable via the World Wide Web.$nAvailable in multiple electronic file formats.$nAccess may be limited to NetLibrary affiliated libraries.

650 \0$aIndian astronomy$zSouthwest, New.

650 \0$aAstronomy, Prehistoric$zSouthwest, New.

650 \0$aIndians of North America$zSouthwest, New$xAntiquities.

651 \0$aSouthwest, New$xAntiquities.

655 \7$aElectronic books.$2local

700 1\$aPutnam, Claudia.

710 2\$aNetLibrary, Inc.

776 1\$cOriginal$w(DLC) 93017712$w(OCoLC)28065250

856 4\$3On campus Link to Harry's online database$uhttp://www.netlibrary.com/urlapi.asp?actionsummary&v1&bookid121$zAn electronic book accessible through the World Wide Web; click for information

856 4\$3Off campus user instructions to link to Harry's database$uhttp://www.netlibrary.com/urlapi.asp?actionsummary&v1&bookid138$zAn electronic book accessible through the World Wide Web; click for information

I would like to end up with this. One record now with 4 856 fields.

If anyone could also suggest software to do this which to accomplish this task would be stupendous.

LDR 01616cam 2200397La 45{92}0

001 ocm42328461\

003 OCoLC

005 20010526091203.0

006 m\\\\\\\\u\\\\\\\\

007 cr\cn-

008 930414s1993\\\\coua\\\\sb\\\\001\0\eng\d

010 \\$z 93017712

020 \\$a0585001448 (electronic bk.)

040 \\$aN{dollar}T$cN{dollar}T$dOCL

020 \\$a0585001510 (electronic bk.)

020 \\$z1555661165

043 \\$an-ust--

050 14$aE78.S7$bM135 1993eb

082 04$a522/.0979$220

049 \\$aM7@A

100 1\$aMalville, J. McKim.

245 10$aPrehistoric astronomy in the Southwest$h[computer file] /$cJ. McKim Malville, Claudia Putnam.

250 \\$aRev. ed.

260 \\$aBoulder, Colo. :$bJohnson Books,$cc1993.

300 \\$a108 p. :$bill. ;$c23 cm.

504 \\$aIncludes bibliographical references (p. [99]-104) and index.

533 \\$aElectronic reproduction.$bBoulder, Colo. :$cNetLibrary,$d1999.$nAvailable via the World Wide Web.$nAvailable in multiple electronic file formats.$nAccess may be limited to NetLibrary affiliated libraries.

650 \0$aIndian astronomy$zSouthwest, New.

650 \0$aAstronomy, Prehistoric$zSouthwest, New.

650 \0$aIndians of North America$zSouthwest, New$xAntiquities.

651 \0$aSouthwest, New$xAntiquities.

655 \7$aElectronic books.$2local

700 1\$aPutnam, Claudia.

710 2\$aNetLibrary, Inc.

776 1\$cOriginal$w(DLC) 93017712$w(OCoLC)28065250

856 4\$3On campus Link to Harry's online database$uhttp://www.netlibrary.com/urlapi.asp?actionsummary&v1&bookid121$zAn electronic book accessible through the World Wide Web; click for information

856 4\$3Off campus user instructions to link to Harry's database$uhttp://www.netlibrary.com/urlapi.asp?actionsummary&v1&bookid138$zAn electronic book accessible through the World Wide Web; click for information

856 4\$3On campus link to Joe's database$uhttp://www.netlibrary.com/urlapi.asp?actionsummary&v1&bookid138$zAn electronic book accessible through the World Wide Web; click for information

856 4\$3Off campus link to Joe's database$uhttp://www.netlibrary.com/urlapi.asp?actionsummary&v1&bookid138$zAn electronic book accessible through the World Wide Web; click for information