This protocol will read an output .sd file from a CAP2006 DB search (that includes 1D supplier information) and will do the following:

1. clean the data so that and are removed from the supplier information

2. remove redundant reports of the same compound that simply refer to different quantities of chemical compound

3. count the number of suppliers that offer the same compound

4. ouput a new .sd file with easily readable properties in the output folder

5. (optionally) present the data in an Excel Viewer or html format (using the Pipeline Pilot/DS Developer Client)

How to use:
(1) Download the attachment and unzip it. It contains the protocol and a sample SD file from CAPS(CAPS_first1000.sd).
(2) Open the Discovery Studio 2.1 client
(3) In the protocol explorer panel, right click at your folder and import the protocol
(4) Double click on the protocol to open its parameter explorer