Thank you.
The input & desired output are:
Input:
id:"200207",
label : "MACROLIDES",
type:"category",
close:["200476"],
drug:[
"<h3>AZITHROMYCIN 250 MG TABLET</h3> <p class='cd1'>Restricted to a ma
+ximum quantity per dispensing of eight (8) tablets ... </p><p>mfg cod
+es:68084, 64679, 60505</p><p>ZITHROMAX | AZITHROMYCIN</p> ",
"<h3>AZITHROMYCIN 1 G PACKET (EA)</h3><p>mfg codes:59762, 00069</p><p>
+ZITHROMAX | AZITHROMYCIN</p> ",
"<h3>AZITHROMYCIN 200 MG/5ML SUSPENSION, RECONSTITUTED, ORAL (ML)</h3>
+ <p class='cd1'>Restricted to use for individuals less than eight ...
+ </p><p>mfg codes:59762, 501119</p><p>ZITHROMAX | AZITHROMYCIN</p> ",
,NCdrug:[
"AZITHROMYCIN ZMAX ZITHROMAX AZITHROMYCIN",
"AZITHROMYCIN HYDROGEN CITRATE AZITHROMYCIN",
"CLARITHROMYCIN CLARITHROMYCIN ER CLARITHROMYCIN BIAXIN",
"DIRITHROMYCIN DYNABAC",
"ERY E-SUCC/SULFISOXAZOLE PEDIAZOLE ERYTHROMYCIN-SULFISOXAZOLE",
"ERYTHROMYCIN BASE ERYTHROMYCIN BASE ERYTHROMYCIN ERYC ERY-TAB",
"ERYTHROMYCIN ESTOLATE ERYTHROMYCIN ESTOLATE",
"ERYTHROMYCIN ETHYLSUCCINATE ERYTHROMYCIN ETHYLSUCCINATE ERYPED 400 E.
+E.S. 400",
"ERYTHROMYCIN LACTOBIONATE ERYTHROCIN LACTOBIONATE",
"ERYTHROMYCIN STEARATE MY-E FILM ERYTHROMYCIN STEARATE",
"FIDAXOMICIN DIFICID"]
},
id:"939383",
label : "FIBROMYALGIA AGENTS,SEROTONIN-NOREPINEPH RU INHIB",
type:"category",
drug:[
"<h3>MILNACIPRAN HCL 12.5 MG TABLET</h3><p>mfg codes:00456</p><p>SAVEL
+LA</p> ",
"<h3>MILNACIPRAN HCL 25 MG TABLET</h3><p>mfg codes:00456</p><p>SAVELLA
+</p> ",
"<h3>MILNACIPRAN HCL 50 MG TABLET</h3><p>mfg codes:00456</p><p>SAVELLA
+</p> ",
"<h3>MILNACIPRAN HCL 100 MG TABLET</h3><p>mfg codes:00456</p><p>SAVELL
+A</p> ",
"<h3>MILNACIPRAN HCL 12.5-25-50 TABLET, DOSE PACK</h3><p>mfg codes:004
+56</p><p>SAVELLA</p> "]
}]}
Desired Output
# Spaces added between fields to make it more readable.
ID| CATEGORY| GENERIC_PRODUCT_NAME| GENERIC_NAME| STRENGTH_DESCRIPTION
+| INSTRUCTIONS| MFG_CODE| TRADE_NAME
# ROW ONE
### Different MFG_Code
200207 | MACROLIDES | AZITHROMYCIN 250 MG TABLET| AZITHROMYCIN| 250 MG
+ TABLET| Restricted to a maximum quantity per dispensing of eight (8)
+ tablets ...| 68084| ZITHROMAX
200207 | MACROLIDES | AZITHROMYCIN 250 MG TABLET| AZITHROMYCIN| 250 MG
+ TABLET| Restricted to a maximum quantity per dispensing of eight (8)
+ tablets ...| 64679| ZITHROMAX
200207 | MACROLIDES | AZITHROMYCIN 250 MG TABLET| AZITHROMYCIN| 250 MG
+ TABLET| Restricted to a maximum quantity per dispensing of eight (8)
+ tablets ... |60505| ZITHROMAX
#### Different trade names than above (last column)
200207| MACROLIDES| AZITHROMYCIN 250 MG TABLET| AZITHROMYCIN| 250 MG T
+ABLET| Restricted to a maximum quantity per dispensing of eight ...|
+68084| AZITHROMYCIN
200207| MACROLIDES| AZITHROMYCIN 250 MG TABLET| AZITHROMYCIN| 250 MG T
+ABLET| Restricted to a maximum quantity per dispensing of eight ...|
+64679| AZITHROMYCIN
200207| MACROLIDES| AZITHROMYCIN 250 MG TABLET| AZITHROMYCIN| 250 MG T
+ABLET| Restricted to a maximum quantity per dispensing of eight ...|6
+0505| AZITHROMYCIN
# ROW 2
200207| MACROLIDES| AZITHROMYCIN 1 G PACKET (EA)| AZITHROMYCIN| 1 G P
+ACKET| NULL| 59762| ZITHROMAX
200207| MACROLIDES| AZITHROMYCIN 1 G PACKET (EA)| AZITHROMYCIN| 1 G P
+ACKET| NULL| 00069| ZITHROMAX
200207| MACROLIDES| AZITHROMYCIN 1 G PACKET (EA)| AZITHROMYCIN| 1 G P
+ACKET| NULL| 59762| AZITHROMYCIN
200207| MACROLIDES| AZITHROMYCIN 1 G PACKET (EA)| AZITHROMYCIN| 1 G P
+ACKET| NULL| 00069| AZITHROMYCIN
# ROW 3
200207| MACROLIDES| AZITHROMYCIN 200 MG/5ML SUSPENSION, RECONSTITUTED,
+ ORAL (ML)| Restricted to use for individuals less than eight ...| 59
+762| ZITHROMAX
200207| MACROLIDES| AZITHROMYCIN 200 MG/5ML SUSPENSION, RECONSTITUTED,
+ ORAL (ML)| Restricted to use for individuals less than eight ...| 50
+1119| ZITHROMAX
200207| MACROLIDES| AZITHROMYCIN 200 MG/5ML SUSPENSION, RECONSTITUTED,
+ ORAL (ML)| Restricted to use for individuals less than eight ...| 59
+762| AZITHROMYCIN
200207| MACROLIDES| AZITHROMYCIN 200 MG/5ML SUSPENSION, RECONSTITUTED,
+ ORAL (ML)| Restricted to use for individuals less than eight ...| 50
+1119| AZITHROMYCIN
...
