title: Redshift unnest alternative
body: <p>I have a field that I'm trying to unnest essentially. Since Redshift is still on Postgres 8.0, I've been trying to find a way to create a function to do this, but am a bit stuck. The only thing that's difficult is that this field can have multiple entries.</p>
  
  <p>So the field looks like: <code>Aleppo-09-SY ; Chicago-IL-US</code>. Sometimes, it'll be blank or have 1 entry like <code>Chicago-IL-US</code>.</p>
  
  <p>Is it possible to create a UDF to do this splitting?</p>