Why cant i remove the suffix from import-csv

Clinton van Axel 126 Reputation points

I want to remove the suffix from an import-csv UPN

But i keep getting that the value is null.

$ADUsers = Import-Csv C:\temp\guid.csv -Delimiter ";"

ForEach ($User in $ADUsers) { 
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,273 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Rich Matheisen 43,926 Reputation points

    Have you verified that the CSV contains a column named "UserPrincipalName"?

    0 comments No comments

  2. Ian Xue (Shanghai Wicresoft Co., Ltd.) 27,266 Reputation points Microsoft Vendor


    Is the value of $ADUsers.UserPrincipalName null? If so, please check the header and the delimiter of the CSV file.

    Best Regards,
    Ian Xue


    If the Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments