Newbie to PowerShell. I want to filter in column 1 where value in a text file equal "Find"

    Get-Content -Path C:\home\file.csv | Select-String -SimpleMatch "Find"
When I ran the above script it returns all records in column 1 that equal "Find" and other columns that have "Find", it should only return column 1 where value is "Find"
Please can you help?
                This works. How do I export result to csv. Out-File maintains the same staggered format but not comma seperated
                    – Olu Akin
                Nov 16 '17 at 11:33
        
Use Import-csv:
Import-Csv C:\home\file.csv -Header Col1,Col2,Col3 | Select-Object -Unique Col1 | Select-String -SimpleMatch "Find"
Adjust the header columns to the columns you have. I assume you have no headers in the csv. otherwise it would be even easier. 
                I was about to write that, but you already gave that answer.Good call mate
                    – Ranadip Dutta
                Nov 16 '17 at 11:31
        
Thanks for contributing an answer to Stack Overflow!
Please be sure to answer the question. Provide details and share your research!
But avoid …
Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
                        
Related
                            
575Setting Windows PowerShell environment variables
2588Determine installed PowerShell version
683How to run a PowerShell script
1639PowerShell says “execution of scripts is disabled on this system.”
925How do you comment out code in PowerShell?
1Filtering this collection and writing to txt file
290How to search a string in multiple files and return the names of files in Powershell?
1Powershell txt file filtering
0Powershell DistinctBy Condition
1Filter CSV file with powershell
site design / logo © 2020 Stack Exchange Inc; user contributions licensed under cc by-sa 4.0
                            with attribution required.
                    rev 2020.2.12.36053