title: Replace NULL value in powershell output
body: <p>I'm really struggling with what seems to be a simple thing.  Any help is appreciated...</p>
  
  <p><strong>tldr; i'm trying to find and replace blank or NULL values from powershell
  output to "No Data"</strong></p>
  
  <p>I am using the following powershell script to obtain installed application information</p>
  
  <pre><code>Get-ItemProperty HKLM:\Software\Microsoft\Windows\CurrentVersion\Uninstall\*
  </code></pre>
  
  <p>Below is sample output of the above script (filtered to my liking).  I am taking this data, exporting it to CSV, in order to import into another application for analysis at a later time.</p>
  
  <pre><code>Host             : Computer1
  DisplayName      : AutoDWG DWG DXF Converter 2015
  Version          : 
  Publisher        : 
  InstallDate      : 
  arrival_datetime : 2015-11-03T09:42:18
  
  Host             : Computer2
  DisplayName      : Beyond Compare Version 3.1.11
  Version          : 
  Publisher        : Scooter Software
  InstallDate      : 20150218
  arrival_datetime : 2015-11-03T09:42:18
  </code></pre>
  
  <p>the CSV export puts the data in the correct format, but where items have no data for version, publisher, etc..., it represents it as ",," (see below)</p>
  
  <pre><code>"Computer1","AutoDWG DWG DXF Converter 2015",,,,"2015-11-03T09:54:21"
  "Computer2","Beyond Compare Version 3.1.11",,"Scooter Software","20150218","2015-11-03T09:54:21"
  </code></pre>
  
  <p>When importing the CSV, the blank values are re-interpreted as NULL, which throws the program for a loop, as it is expecting a string.  I am attempting to change those to the string "No Data" but am having lots of trouble...</p>
  
  <p>What would be the best way to handle this?</p>