title: How can I split a column with multiple values into multiple lines while repeating value from 1st column?
body: <p>I'm trying get a list of all my CVEs and my Erratas, the CVE column is comma delimited. I need it to be newline delimited, and the corresponding Errata to be output as well</p>
  
  <p>I can either use sed or awk to accomplish this, but unsure how to get started</p>
  
  <p>Current Output:</p>
  
  <pre><code>RHSA-2017:3221  CVE-2016-10167, CVE-2016-10168
  RHSA-2015:2369  CVE-2015-3248
  RHSA-2015:1534  CVE-2014-9715, CVE-2015-2666, CVE-2015-2922, CVE-2015-3636
  </code></pre>
  
  <p>Desired Output:</p>
  
  <pre><code>RHSA-2017:3221  CVE-2016-10167
  RHSA-2017:3221  CVE-2016-10168
  RHSA-2015:2369  CVE-2015-3248
  RHSA-2015:1534  CVE-2014-9715
  RHSA-2015:1534  CVE-2015-2666
  RHSA-2015:1534  CVE-2015-2922
  RHSA-2015:1534  CVE-2015-3636
  </code></pre>
  
  <p>Update (Solved):
  <code>awk '{errata=$1; for(i=2; i&lt;NF; i++) {print errata,$i}}' FS=',? +' OFS='  ' /C/Temp/ERRATACVETEST.txt</code>
   I changed cyrus' a bit, I changed <code>i&lt;=NF</code> to <code>i&lt;NF</code>, and it yields my desired results, thanks!</p>