Powershell cannot read CSV - Export is from Oracle

Question

As people maybe have seen I'm busy with adding a User Principle Name to a CSV. Now with some help that code works.
Only after debugging I discovered the issue. I don't get data from the CSV I import.

When i try the easiest thing, my variable stays empty

$csvfile = Import-CSV -Path C:\Temp\eport.csv

Foreach ($line in $csvfile) {

Write-Host $line.EMAIL  

}

My import-csv is from an Oracle DB export and looks like this, I trimmed spaces
EMAIL;Username;
a.borgeld@Karima ben .com;ABORGELD;
a.borgeld@Karima ben .com;ABORGELD;

Does anybody have experience with CVS's from a database that you can't read? Of course when i open the notepad then the data is there

Answer 1

Adding the -Delimiter ";" should help:

$csvfile = Import-Csv -Path C:\Temp\export.csv -Delimiter ";"  
foreach ($line in $csvfile)  
    {  
        Write-Output $line.EMAIL  
    }  

My CSV file looks like this:
EMAIL;Username;
a.borgeld@Karima ben .com;ABORGELD;
test@Anonymous .bar;TEST

Output of the script is the email of every line:
a.borgeld@Karima ben .com
test@Anonymous .bar

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Answer 2

Oh my @Andreas Baumgarten sometimes life can be so easy.
Thanks for getting me out of that black whole. The whole script will work now.
You've got to deal with different outputs.