Example how to split text into 2 part with Powershell version 2+.
Example 1:
#Simple text split based on delimiter
$text = "Left Part;Right Part"
$pos = $text.IndexOf(";")
$leftPart = $text.Substring(0, $pos)
$rightPart = $text.Substring($pos+1)
Write-Output $leftPart
Write-Output $rightPart
Example 2:
#Set own delimiter in text and split then
$text = "Left Part - Right Part" -replace " - ",";"
$pos = $text.IndexOf(";")
$leftPart = $text.Substring(0, $pos)
$rightPart = $text.Substring($pos+1)
Write-Output $leftPart
Write-Output $rightPart
Example 3:
#Comprehensive example - load values from array, set own delimiter, split them into left and right part, save them as object values and export object.
$text = (
"Left Part1 - Right Part1",
"Left Part2 - Right Part2",
"Left Part3 - Right Part3",
"Left Part4 - Right Part4"
)
$ObjArr = @()
foreach ($item in $text) {
$obj = New-Object psobject
[array]$ReplacedText = $item -replace " - ",";"
[int]$LineArrCounter = 0
$pos = $ReplacedText[$LineArrCounter].IndexOf(";")
$leftPart = $ReplacedText[$LineArrCounter].Substring($LineArrCounter, $pos)
$rightPart = $ReplacedText[$LineArrCounter].Substring($pos+1)
$LineArrCounter++
$obj | Add-Member -MemberType NoteProperty -Name LeftPart -Value $leftPart
$obj | Add-Member -MemberType NoteProperty -Name RightPart -Value $rightPart
$ObjArr += $obj
}
Write-Output $ObjArr