parse out dosage from name

[zdavatz]

grab xxxxx and put it in column G of pharma.csv

1. ~APHENYLBARBIT streuli tabl 50 mg 100 stk~
2. ~RAPIDOCAIN 1% + epin 10 mcg/ml vial 20 ml~
3. ~KYTTA salbe tb 50 g~
4. ~SUCCINOLIN inj lös 100 mg/2ml 100 amp 2 ml~
5. ~VITARUBIN inj lös 1000 mcg/ml 5 amp 1 ml~
6. ~SYNTOCINON inj inf präp 5 ie 5 amp 1 ml~
7. ~SOLCOSERYL inj lös 212.5 mg/5ml 5 amp 5 ml~
8. ~Solcoseryl 85 mg/2 ml i.v., see #76~
9. ~AKINETON inj lös 5 mg/ml 5 amp 1 ml~
10. ~KENACORT a 10 inj susp 50 mg/5ml durchstf 5 ml~
11. ~SOLCOSERYL gel 4 mg/g mite tb 20 g~
12. VENORUTON gel tb 100 g
13. AEQUIFUSINE inf lös 500ml ecofl pl 10 stk
14. GLUC braun inf lös 10 % 100ml durchstfl 20 stk
15. KCL braun inf konz 7.45 % 20ml mini pl con 20 stk
16. NACL braun träger lös 0.9 % 100ml durchstfl 20 stk
17. CO-VALSARTAN sandoz filmtabl 80/12.5 28 stk
18. ~Pramipexol Stada 0.25 mg~
19. ~XEOMIN trockensub 100 e durchstf~
20. ~Methrexx 15 mg / 1.5 ml -> 15 mg/1.5 ml~
21. ~METHREXX inj lös 7.5 mg/0.375ml fertspr 0.375 ml~
22. ~LOSARTAN hct axapharm filmtabl 100/12.5mg 28 stk~
23. ~REFACTO af fusengo 2000 ie c solv fertspr~
24. ~DEXDOR inf konz 200 mcg/2ml 25 amp 2 ml~ #77
25. ~BLEOMYCIN baxter 15000 i.u. durchstf 10 stk~
26. ~QUILONORM retard ret filmtabl 12.2 mmol 300 stk~
27. NASIVIN gtt nas 0.01 % bébé 5 ml
28. EFUDIX creme 5 % 20 g
29. ~OSPEN 400 sirup 400000 ie/5ml 60 ml~
30. BACTRIM inf konz 400/80mg i.v. 10 amp 5 ml
31. ~PERINDOPRIL indapamid-mepha 10/2.5 ds 90 stk~
32. LONSURF filmtabl 20mg/8.19mg 20 stk
33. ~DESOGYNELLE tabl 150mcg/20mcg 3 x 21 stk~
34. CLARISCAN inj lös 13.965 g/50ml pp fl 50 ml
35. ALENDRON d3-mepha wochentabl 70/2800 12 stk
36. TWINRIX 720/20 inj susp fertspr 1 ml
37. LYXUMIA inj lös 1x10 mcg/1x20 mcg fertpen set
38. Calvive D3 600/400
39. CANSARTAN mepha plus tabl 32/25 98 stk
40. ~COVERSUM n combi filmtabl 5/1.25 mg 90 stk~
41. ~PERINDOPRIL indapamid-mepha 2.5/0.625 ds 30 stk~

[bettar]

Why is 20 different from the others ?

[zdavatz]

The reason for the arrow is the space before and after the /, that can be removed.

It comes from Swissmedic, not from Refdata. Names that come from Refdata have all CAPITAL letters, names that come from Swissmedic do not.