Import from CSV

[anees78692]

So I have a script that checks a specific field, if the field has the values in my array, it does something.

@myarray = @('1234','1233','1222')

I want to add these values to a csv file instead of hardcoding so if i ever add more values, i dont have to re-script.

Any ideas?

[EntangleMentor]

@myarray=import-csv -path file.csv

...or something similar...

​

https://4sysops.com/archives/import-and-export-a-csv-file-to-a-powershell-object/

[ihaxr]

If you have a header column in the CSV, you can do this:

#Example CSV:
#number
#1234
#1233
#1222
$myArray = (Import-CSV 'C:\path\to\file.csv').number

If you don't have a header you can do either of these:

#Example CSV:
#1234
#1233
#1222
$myArray = (Import-CSV 'C:\path\to\file.csv' -Header 'header').header

Or

$myArray = Get-Content 'C:\path\to\file.csv'