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> "]
}]}

[download]
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
...

[download]

In reply to Re^2: parsing a line with $1, $2, $3 by kevyt
in thread parsing a line with $1, $2, $3 by kevyt

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.