Read a Csv file with powershell and capture corresponding data

Question

Using PowerShell I would like to capture user input  compare the input to data in a comma delimited CSV file and write corresponding data to a variable    Example     A user is prompted for a    Store Number     they enter  10   The input     10    is then compared to the data in the first position     or column of the   CSV file     Data  such as    District Number    in the corresponding position   column is captured and written to a variable    I have gotten this method to work with an Excel file   xlsx  but have found it to be terribly slow  Hoping that PowerShell can read a CSV file more efficiently   Link to an example CSV file here   Store Number Region District NO of Devices Go Live Date 1 2 230 10 2 21 2013 2 2 230 10 2 25 2013 3 2 260 12 3 8 2013 4 2 230 10 3 4 2013 5 2 260 10 3 4 2013 6 2 260 10 3 11 2013 7 2 230 10 2 25 2013 8 2 230 10 3 4 2013 9 2 260 10 5 1 2013 10 6 630 10 5 23 2013

User · Answer

Old topic  but never clearly answered  I ve been working on similar as well  and found the solution   The pipe     in this code sample from Austin isn t the delimiter  but to pipe the ForEach-Object  so if you want to use it as delimiter  you need to do this   Import-Csv H  Programs scripts SomeText csv -delimiter        ForEach-Object        Name       Name      Phone        Phone Number      Spent a good 15 minutes on this myself before I understood what was going on  Hope the answer helps the next person reading this avoid the wasted minutes   Sorry for expanding on your comment Austin

User · Answer

So I figured out what is wrong with this statement   Import-Csv H  Programs scripts SomeText csv       Original   Import-Csv H  Programs scripts SomeText csv -Delimiter        Proposed  You must use quotations  otherwise  it will not work and ISE will give you an error   It requires the -Delimiter      in order for the variable to be populated with an array of items  Otherwise  Powershell ISE does not display the list of items   I cannot say that I would recommend the   operator  since it is used to pipe cmdlets into one another   I still cannot get the if statement to return true and output the values entered via the prompt   If anyone else can help  it would be great  I still appreciate the post  it has been very helpful

User · Answer

What you should be looking at is Import-Csv  Once you import the CSV you can use the column header as the variable   Example CSV   Name    Phone Number   Email Elvis   867 5309       Elvis Geocities com Sammy   555 1234       SamSosa Hotmail com   Now we will import the CSV  and loop through the list to add to an array  We can then compare the value input to the array    Name        Phone        Import-Csv H  Programs scripts SomeText csv        ForEach-Object            Name       Name          Phone        Phone Number          inputNumber   Read-Host -Prompt  Phone Number   if   Phone -contains  inputNumber            Write-Host  Customer Exists        Where    array   IndexOf  Phone   inputNumber      Write-Host  Customer Name     Name  Where          And here is the output

[powershell] Read a Csv file with powershell and capture corresponding data

Examples related to powershell

Examples related to csv