I have data like below in a text file which I would like to convert into PS Object
Date : 10-11-2018 16:00:16
Direction : Inbound
SenderAddress : adriana@abc.com
RecipientAddress : werner.pedersen@abc.com
Subject : Black Hat & DEF CON® 2018 - a debrief with Quinn Shamblin
Action :
Domain : abc.com
EventType : SpamContentFiltered
Organization : abc.onmicrosoft.com
MessageTraceId : fb-ad49-4706-e29a-08d647259b57
MessageId : <B1.BC.28078.D8007EB5@abc>
Date : 10-11-2018 16:00:43
Direction : Inbound
SenderAddress : bob@abc.com
RecipientAddress : werner.pedersen@abc.com
Subject : Black Hat & DEF CON® 2018 - a debrief with Quinn Shamblin
Action :
Domain : abc.com
EventType : SpamContentFiltered
Organization : abc.onmicrosoft.com
MessageTraceId : fb-ad49-4706-e29a-08d647259b57
MessageId : <B1.BC.28078.D8007EB5@abc>
So far I have below but its only adding the first property "Date" in the object
$a = gc C:\temp.txt
$Result = @()
$a | % {
$line = $_
#Below If statement is for removing empty line
If ($line -ne "") {
$Split = $line -split ": "
$Header = $Split[0]
$Value = $Split[1]
$Object = New-Object psobject
$Object | Add-Member -NotePropertyName $Header ($Value)
$Result += $Object
}
}
$Result
Thanks, Samer
