This data is store in a file
AUTOM01-AYEHU1:No Updates Available
AUTOM01-AYEHU2:No Updates Available
AUTOM01-AYEHU3:No Updates Available
AUTOM01-AYEHU4:No Updates Available
AUTOM01-AYEHU5:No Updates Available
AUTOM01-AYEHU6:No Updates Available
I have a above dataset in a file i need to create 2 powershell custom object with the name of (SERVERNAME,STATUS) and put respective data into it .
before : is servername and rest is status
This is the answer if you really want 2 objects
$fileLines = @("AUTOM01-AYEHU1:No Updates Available","AUTOM01-AYEHU2:No Updates Available")
$serverArray = [System.Collections.ArrayList]::new()
$statusArray = [System.Collections.ArrayList]::new()
foreach($fileLine in $fileLines)
{
$splittedLine = $fileLine.split(":")
$serverArray.Add([PSCustomObject]@{ServerName=$splittedLine[0]})
$statusArray.add([PsCustomobject]@{Status=$splittedLine[1]})
}
find them in $serverArray and $statusArray
As commented in your previous question, you can simply do
$result = (Get-Content -Path 'thefile.txt' -Raw) -replace ':', '=' | ConvertFrom-StringData
ConvertFrom-StringData returns a Hashtable, in which by default the items are unordered.
As you would like to keep the order as in the input file, you may want to use this instead:
$result = Get-Content -Path 'D:\Test\thefile.txt' | ConvertFrom-String -Delimiter ':' -PropertyNames Server, Status
To return an array of PSCustomObjects:
Server Status ------ ------ AUTOM01-AYEHU1 No Updates Available AUTOM01-AYEHU2 No Updates Available AUTOM01-AYEHU3 No Updates Available AUTOM01-AYEHU4 No Updates Available AUTOM01-AYEHU5 No Updates Available AUTOM01-AYEHU6 No Updates Available
try..catch and -ErrorAction Stop should suffice.
Import-Csv.\YourFile.csv -Delimiter ':' -Header 'ServerName','Status'