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 Loop of parsing dosage from Swissmedic is cutting off the name upto the comma #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 Dexdor mcg = µg #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.