search

OpenUpSA / mpr_analysis

0 stars 0 forks source link

Ingredients with different names for the same product are added as additional instead of being coalesced #1

Open jbothma opened 7 years ago

jbothma commented 7 years ago 

697 | Alcon Laboratories (Sa) (Pty) Ltd | 33/3/0182 | 882911004 | S01KA | S4 | Duovisc 0.35 V / 0.4 P | Chondroitin Sulfate | 4 | % | OPD | 1 |   | 691 | 114 | 113 | 918.09 | 918 | 02/20/09
-- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | --
  |   |   |   |   |   |   | Hyaluronic Acid | 3 | % |   |   |   |   |   |   |   |   |  
  |   |   |   |   |   |   | Phenylephrine | 1 | % |   |   |   |   |   |   |   |   |  
697 | Alcon Laboratories (Sa) (Pty) Ltd | 33/3/0182 | 882903001 | S01KA | S4 | Duovisc 0.50 V / 0.55 P | Chondroitin Sulfate | 3 | % | COM | 1 |   | 968 | 160 | 158 | 1286.79 | 1287 | 02/20/09
  |   |   |   |   |   |   | Hyaluronic Acid | 4 | % |   |   |   |   |   |   |   |   |  
  |   |   |   |   |   |   | Phenylephrine | 1 | % |   |   |   |   |   |   |   |   |  

vs


697 | Alcon Laboratories (Sa) (Pty) Ltd | 33/3/0182 | 882903001 | S01KA | S4 | Duovisc Intraocular Viscoelatic System | (viscoat)sodium Chondroitin Sulphate | 40 | mg/ml | COM | 1 | 1 | 1188.08 | 196.63 | 193.86 | 1578.57 | 1503.4 | 04/07/14 |   | Originator
-- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | --
  |   |   |   |   |   |   | (viscoat)sodium Hyaluronate | 30 | mg/ml |   |   |   |   |   |   |   |   |   |   |  
  |   |   |   |   |   |   | (provisc)sodium Hyaluronate | 10 | mg/ml |   |   |   |   |   |   |   |   |   |   |  
697 | Alcon Laboratories (Sa) (Pty) Ltd | 33/3/0182 | 882911004 | S01KA | S4 | Duovisc Intraocular Viscoelatic System | (viscoat)sodium Chondroitin Sulphate | 40 | mg/ml | COM | 1 | 1 | 848.63 | 140.45 | 138.47 | 1127.55 | 1503.4 | 04/07/14 |   | Originator
  |   |   |   |   |   |   | (viscoat)sodium Hyaluronate | 30 | mg/ml |   |   |   |   |   |   |   |   |   |   |  
  |   |   |   |   |   |   | (provisc)sodium Hyaluronate | 10 | mg/ml |   |   |   |   |   |   |   |   |   |   |  
jbothma commented 7 years ago

-provisc-sodium-hyaluronate-10-mg-ml--viscoat-sodium-chondroitin-sulphate-40-mg-ml--viscoat-sodium-hyaluronate-30-mg-ml

jbothma commented 7 years ago

-provisc-sodium-hyaluronate-10-mg-ml--viscoat-sodium-chondroitin-sulphate-40-mg-ml--viscoat-sodium-hyaluronate-30-mg-ml-chondroitin-sulfate-3- -hyaluronic-acid-4- -phenylephrine-1-