Parse materials for IP injections

[mekhlakapoor]

User story

As a user, I want the data from sharepoint to be mapped more completely to IP Injections. Parse "substance to be administered" to NonViralMaterial.

Acceptance criteria

• [ ] substance to be administered to NonViralMaterial

Sprint Ready Checklist

• [ ] 1. Acceptance criteria defined
• [ ] 2. Team understands acceptance criteria
• [ ] 3. Team has defined solution / steps to satisfy acceptance criteria
• [ ] 4. Acceptance criteria is verifiable / testable
• [ ] 5. External / 3rd Party dependencies identified
• [ ] 6. Ticket is prioritized and sized

Notes

The substance to be administered field has no set pattern because the input field is a string. We'll need to figure out best way to parse information

[mekhlakapoor]

IP Injections are tracked in this list through Dosing and Dosing points to IP. The volume and non viral material are both stored in "Substance to be administered". It'll be useful to first generate a summary of what the string entries are. From there we can see if there's a general pattern(s) that this field follows and parse accordingly.

[mekhlakapoor]

"doseSub": {
    "Data Type": "object",
    "Sample": [
        "Quinpirole for 730940, 730941; Saline for 730943, 730944",
        "Doxycycline, dosage 50mg/kg",
        "Quinpirole",
        "2% solution of Evans blue due (premade by NSB)",
        "Doxycycline",
        "heparin  1000U/mL (2 mice only)",
        "Heparin 1000u/ml",
        "1000U/mL Heparin",
        "MnCl2 @ 100 mM (prepared by Galen Lynch)",
        "Heparin (1000U/mL",
        "Heparin 1000u /mL",
        "Heparin 1000U / mL",
        "Heparin 1000u/mL",
        "heparin 1000U/mL",
        "2% Evans blue",
        "Heparin 1000 U/ml",
        "2% evans blue",
        "AAV",
        "Doxycycline diet (200 mg/kg)",
        "heparin 1000u/ml",
        "methoxy-XO4",
        "Dox diet (200 mg/kg)",
        "1,000U/mL Heparin",
        "5 DAY TAM for triple positives at p35 (min P34 pull)",
        "MnCl2",
        "methoxy-X04",
        "Saline, L-DOPA (5mg/kg), or L-DOPA (20mg/kg)",
        "FITC- dextran (tail vein)",
        "2% solution Evans blue dye (premade by NSB)",
        "Methoxy-XO4",
        "Doxycycline diet",
        "Heparin 1000U/ml",
        "Heparin, 1000U/mL",
        " 5 DAY TAM for triple positives at p35 (min P34 pull)",
        "Vehicle for 4-OHT",
        "2% solution of Evans blue due (premade by Christian Bonatto)",
        "Heparin 1000 U/mL",
        "Heparin 1000U/mL",
        "Heparin",
        "Heparin (1000U/mL)",
        "4-OHT"
    ],
    "Unique Count": 41
},