Same drug_name, multiple generic_name

[eashwarsiddharth]

17

@Rajhan Please check it out and let me know if modify the generic names.

$BETAMETHASONE DIPROPIONATE drug_name--- generic_name 119554 BETAMETHASONE DIPROPIONATE--- BETAMETHASONE DIPROPIONATE 147251 BETAMETHASONE DIPROPIONATE--- BETAMETHASONE/PROPYLENE GLYC

$CICLOPIROX drug_name--- generic_name 43847 CICLOPIROX--- CICLOPIROX 161867 CICLOPIROX--- CICLOPIROX OLAMINE

$DDAVP drug_name--- generic_name 60866 DDAVP--- DESMOPRESSIN ACETATE 268032 DDAVP--- DESMOPRESSIN (NONREFRIGERATED)

$DEMEROL--- drug_name generic_name 61652 DEMEROL--- MEPERIDINE HCL/PF 191084 DEMEROL--- MEPERIDINE HCL

$DEPAKENE drug_name--- generic_name 10931 DEPAKENE--- VALPROIC ACID 24502 DEPAKENE--- VALPROIC ACID (AS SODIUM SALT)

$DESMOPRESSIN ACETATE drug_name--- generic_name 10756 DESMOPRESSIN ACETATE--- DESMOPRESSIN ACETATE 316765 DESMOPRESSIN ACETATE--- DESMOPRESSIN (NONREFRIGERATED)

$DILANTIN drug_name--- generic_name 339 DILANTIN--- PHENYTOIN SODIUM EXTENDED 1588 DILANTIN--- PHENYTOIN

$EASY TOUCH drug_name--- generic_name 345414 EASY TOUCH--- SYRING W-NDL,DISP,INSUL,0.5 ML 345415 EASY TOUCH--- SYRINGE & NEEDLE,INSULIN,1 ML

$EXELON drug_name--- generic_name 106 EXELON--- RIVASTIGMINE 34480 EXELON--- RIVASTIGMINE TARTRATE

$FENOFIBRATE drug_name--- generic_name 4152 FENOFIBRATE--- FENOFIBRATE 4223 FENOFIBRATE--- FENOFIBRATE NANOCRYSTALLIZED 11026 FENOFIBRATE--- FENOFIBRATE,MICRONIZED

$HALOPERIDOL drug_name--- generic_name 228 HALOPERIDOL--- HALOPERIDOL 309402 HALOPERIDOL--- HALOPERIDOL LACTATE

$HYDROMORPHONE HCL drug_name--- generic_name 1686 HYDROMORPHONE HCL--- HYDROMORPHONE HCL 149508 HYDROMORPHONE HCL--- HYDROMORPHONE HCL/PF

$IMITREX drug_name--- generic_name 6054 IMITREX--- SUMATRIPTAN SUCCINATE 114331 IMITREX--- SUMATRIPTAN

$INSULIN SYRINGE drug_name--- generic_name 81641 INSULIN SYRINGE--- SYRINGE & NEEDLE,INSULIN,1 ML 126183 INSULIN SYRINGE--- SYRING W-NDL,DISP,INSUL,0.5 ML 337696 INSULIN SYRINGE--- SYRING W-NDL,DISP,INSUL,0.3 ML

$LEVOCARNITINE drug_name--- generic_name 3478 LEVOCARNITINE--- LEVOCARNITINE 5983 LEVOCARNITINE--- LEVOCARNITINE (WITH SUGAR)

$MEPERIDINE HCL drug_name--- generic_name 21831 MEPERIDINE HCL--- MEPERIDINE HCL 61675 MEPERIDINE HCL--- MEPERIDINE HCL/PF

$MIDAZOLAM HCL drug_name--- generic_name 19511 MIDAZOLAM HCL--- MIDAZOLAM HCL 19512 MIDAZOLAM HCL--- MIDAZOLAM HCL/PF

$ONDANSETRON HCL drug_name--- generic_name 56 ONDANSETRON HCL--- ONDANSETRON HCL 4904 ONDANSETRON HCL--- ONDANSETRON HCL/PF

$SODIUM CHLORIDE drug_name--- generic_name 4914 SODIUM CHLORIDE--- 0.9 % SODIUM CHLORIDE 24895 SODIUM CHLORIDE--- SODIUM CHLORIDE IRRIG SOLUTION 31552 SODIUM CHLORIDE--- SODIUM CHLORIDE 0.45 %

$SOLU-MEDROL drug_name--- generic_name 7240 SOLU-MEDROL--- METHYLPREDNISOLONE SOD SUCC/PF 14154 SOLU-MEDROL--- METHYLPREDNISOLONE SOD SUCC

$SURE COMFORT drug_name--- generic_name 17743 SURE COMFORT--- SYRING W-NDL,DISP,INSUL,0.5 ML 345528 SURE COMFORT--- SYRINGE & NEEDLE,INSULIN,1 ML

$VALPROIC ACID drug_name--- generic_name 980 VALPROIC ACID--- VALPROIC ACID (AS SODIUM SALT) 2295 VALPROIC ACID--- VALPROIC ACID

[Rajhan]

hard code it. just take the common word between the generic names for a drug. and replace it manually.