Read a Csv file with powershell and capture corresponding data

by

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     | [email protected]
Sammy | 555.1234     | [email protected]

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:

I Found Sammy

More Related Contents:

  1. how do I loop through a line from a csv file in powershell
  2. How to remove all quotations mark in the csv file using powershell script?
  3. Merging multiple CSV files into one using PowerShell
  4. ConvertTo-Csv Output without quotes
  5. How to use powershell to reorder CSV columns?
  6. Add Column to CSV Windows PowerShell
  7. Using Powershell environmental variables as strings when outputting files
  8. Remove last line from file with Powershell
  9. PS Script is exporting an empty CSVs
  10. Powershell Invoke-WebRequest Fails with SSL/TLS Secure Channel
  11. How can I find the Upgrade Code for an installed MSI file?
  12. How to enter a multi-line command
  13. Add a where-object on a table construct?
  14. Is there a way to make a PowerShell script work by double clicking a .ps1 file?
  15. How to redirect the output of a PowerShell to a file during its execution
  16. How can I make PowerShell handle [ or ] in file name well?
  17. What’s the difference between .replace and -replace in powershell?
  18. Why does the `using` scope work locally with Start-Job, but not Invoke-Command?
  19. Get-Content and show control characters such as `r – visualize control characters in strings
  20. Powershell send-mailmessage – email to multiple recipients
  21. Function Get-IniContent is not recognized – INI file support inPowerShell
  22. Copy file remotely with PowerShell
  23. What does the & symbol in powershell mean?
  24. Powershell Get-ChildItem -Filter operates differently to Where clause with same value
  25. How to print environment variables to the console in PowerShell?
  26. PowerShell script won’t execute as a Windows scheduled task
  27. What security setting is preventing Remote PowerShell 2.0 from accessing UNC paths
  28. PowerShell Capture Write-Host output
  29. start remote process within the context
  30. How can I elevate Powershell while keeping the current working directory AND maintain all parameters passed to the script?

Leave a Comment