Extract from CSV only lines with a specfic value for specific column
Closed this issue · 1 comments
bovirus commented
I have a CSV (or xls) file with this content
Column1 = Region
Column2 = City
Column3 = Latitude
Column4 = Longitude
etc
My scope is via powershell command line load this csv file and create a new csv (or Excel) file that contains ONLY (filter) lines with a specifc vale in a specific column (ex. value xxxx in Column2).
How can do that via command lire with Powershell and ImportExcel module?
Thanks.
dfinke commented
please post data and script of what you are trying to accomplish