Powershell | Import .csv file

Question

I want to import .csv file in Powershell. It is only one line in the CSV, which is structured as follows: Text;Text;Text...

This is what i have tried before:

$folder_csv = 'C:\Users\Win_User\Desktop\Folder\CSV_Files'
$files = Get-ChildItem $folder_csv -File -Filter *.csv

foreach ($file in $files) {

                    $Split_content = $file.split(";")
    
                    $timestamp = $($Split_content[0])
                    $User = $($Split_content[1])
                    $PC = $($Split_content[2])
                    $Software = $($Split_content[3]).Substring(1)
                    }
Write-Host $timestamp + " " + $User + " " + $PC + " " + $Software

I get the following Error Message: "Method invocation failed because [System.IO.FileInfo] does not contain a method named 'split'" .

Is there a better way to imort a csv file and safe each value in a seperate varibale? Thanks for your help.

Use the Import-CSV function instead: learn.microsoft.com/en-us/powershell/module/… — Daniel Björk
– Daniel Björk, Commented Jul 27, 2020 at 6:27
Hello, thanks for the comment. I have already tried that: Unfortunately it is not outputing anything when i try the following code: $Test = Import-Csv 'C:\Users\Win_User\Desktop\CSV-Files\2020-7-23 11-52-14.csv' -Delimiter ";" Write-Host $Test — User-2375
– User-2375, Commented Jul 27, 2020 at 6:36
Then you are doing it wrong, you should use Import-CSV. Thats the proper way to import a CSV file. If you update your question with example rows of the CSV I can probably give you a solution. — Daniel Björk
– Daniel Björk, Commented Jul 27, 2020 at 6:38
Hello in the. csv file are only 4 values it looks like this: 27.7.2020 08:43:33;User;PC-Name;Software-Name . — User-2375
– User-2375, Commented Jul 27, 2020 at 6:44

Daniel Björk · Accepted Answer · 2020-07-27 06:59:23Z

1

Your example file is not containing a header so I guess that's your problem. Then you need to specify it manually when Importing the CSV file. This code works only for when you have one row, if you have multiple rows it will just overwrite the variables and keep the last one. But feel free to change that.

$Header = 'timestamp','User','PC','Software'

$data = Import-Csv -Path .\testcsv.csv -Delimiter ';' -Header $Header



foreach ($row in $data) {
   
    $timestamp = $row.timestamp
    $User = $row.User
    $PC = $row.PC
    $Software = $row.Software
}

$timestamp
$User
$PC
$Software

answered Jul 27, 2020 at 6:59

Daniel Björk

2,5171 gold badge21 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hemendr · Accepted Answer · 2022-09-15 21:42:06Z

0

$Header = 'Name','Age','Profession'
$data = Import-Csv -Path F:\Temp\NoHeader.csv -Delimiter ',' -Header $Header
$data | select Name, Age, Profession

answered Sep 15, 2022 at 21:42

Hemendr

1,08813 silver badges20 bronze badges

Collectives™ on Stack Overflow

Powershell | Import .csv file

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related