title: How do I easily convert a CSV with a strange date format to a specified format?
body: <p><em>This is more a data related question than programming, but I wasn't sure where else to post it. If it better fits elsewhere modders are free to move it.</em></p>
  
  <p>I'm trying to import a bank exported CSV into GNUcash, but GNUcash only takes specific date formats such as YYYY-MM-DD (1999-05-16), whereas my bank only exports as YYYYMMDD (19990516).</p>
  
  <p>I'm not sure what the easiest / most convenient way is to convert the file for use. Writing a script and/or using complex regexes for it seems excessive but might be necessary?</p>
  
  <p>I tried loading it into LibreOffice Calc and MS Excel but couldn't find any conversion options; formatting the cells with a custom YYYYMMDD format broke the output. I was hoping there was an easier way to solve this. If there isn't I might just end up writing that script and putting it online somewhere.</p>