title: Replace multiple newlines & add delimiters with sed?
body: <p>I have a .txt file that is formatted like the below:</p>
  
  <pre><code>Artist 1, Artist 2, Artist 3,
  Venue name,
  City, State,
  xx/xx/xxxx
  
  
  
  
  
  
  
  
  Artist 4,
  Venue name,
  City, State,
  xx/xx/xxxx
  </code></pre>
  
  <p>Variable number of artists per section, and a bunch of newlines in between each entry. I want to get to a point where I can import this into a spreadsheet with some sort of delimiter, such that I can have each section in it's own row (of which each row has four columns, which pertain to the four fields - artist, venue, location, date.)</p>
  
  <p>Figure I need to:</p>
  
  <ol>
  <li>Replace all instances of <code>,\n</code> with some sort of delimiter</li>
  <li>Remove all extra newline characters</li>
  </ol>
  
  <p>...but can't seem to find a way to get this to work w/ <code>sed</code>. Any help would be appreciated!</p>