title: Adding a ROW for missing Attribute values to Export-CSV
body: <p>I using the following POWER SHELL script, to extract ( to csv ) managers name , from a &quot;Manager&quot; user attribute.</p>
  <pre><code>#This script, , Exports the Manager name of the employee`s in the TXT file.
  # users.txt file - contains a simply list of user names ( samaccount-names )
  
  Get-Content D:\powershell\permmisions\Users.txt | Foreach-Object {
  
  Get-ADUser -Identity $_ -Properties Manager | Select-Object name, Manager | Export-Csv D:\Powershell\ADuserinformation\Export-Managers-of-specific-users.csv
  -Append
  
  }
  </code></pre>
  <p>The challenge i am facing, is when is on the exported CSV file,
  the list &quot;SKIPS&quot; blank value-fields,In case there is no manager set for the user.
  And a ROWS is not created , where MANAGER is missing.</p>
  <p>What i would like to do , is the script to enter a charcter ( ~ ) for example, where, value is blank.
  That way , a row will be created for the blank MANAGER value, on the CSV file</p>
  <p>Please help ,
  Thanks all in advance.</p>