PowerShell Script Example

Use it for whatever it helps you. Attached also the textfile: textfile-A

<<<------------------------------------------- START SCRIPT ------------------------------------------->>
clear

Get-Content -Path "U:\Users\adi\Documents\ssc\textfile-A.txt"

$newStreamReader = New-Object System.IO.StreamReader("U:\Users\adi\Documents\ssc\textfile-A.txt")
$eachlinenumber = 1
$delimiter = "|"


#while (($readeachline =$newStreamReader.ReadLine()) -ne $null) {
# # Write-Host "$eachlinenumber = $readeachline"
# 
# $colA = $readeachline.Substring(0,10)
# $colB = $readeachline.Substring(10,10)
# $colC = $readeachline.Substring(20,10)
# $colD = $readeachline.Substring(30,10)
# $colE = $readeachline.Substring(40,10)
# $colF = $readeachline.Substring(50,10)
# $colG = $readeachline.Substring(60,10)
# $colH = $readeachline.Substring(70,10)
# $colI = $readeachline.Substring(80,10)
# $colJ = $readeachline.Substring(90,10)
# $colK = $readeachline.Substring(100,10)
# $colL = $readeachline.Substring(110,10)
# $colM = $readeachline.Substring(120,10)
# $colN = $readeachline.Substring(130,10)
# $colO = $readeachline.Substring(140,10)
# $colP = $readeachline.Substring(150,10)
# $colQ = $readeachline.Substring(160,10)
# $colR = $readeachline.Substring(170,10)
# $colS = $readeachline.Substring(180,10)
#
# Write-Host "$colA$delimiter$colB$delimitercolC$delimiter$colD$delimiter$colE$delimiter$colF$delimiter$colG$delimiter$colH$delimiter$colI$delimiter$colJ$delimiter$colK$delimiter$colL$delimiter$colM$delimiter$colN$delimiter$colO$delimiter$colP$delimiter$colQ$delimiter$colR$delimiter$colS"
#
# $eachlinenumber++
#}

$newStreamReader.Dispose();

#
# Example with split function
#

#clear
$newStreamReader = New-Object System.IO.StreamReader("U:\Users\adi\Documents\ssc\textfile-A.txt")
$eachlinenumber = 1
$delimiter = "|"
$numOfFields = 0

$newStreamWriter = New-Object System.IO.StreamWriter("U:\Users\adi\Documents\ssc\textfile-A-out.txt")




while (($readeachline =$newStreamReader.ReadLine()) -ne $null) {
# Write-Host "$eachlinenumber = $readeachline"

if ($eachlinenumber -eq 1) {
Write-Host $readeachline
$newStreamWriter.WriteLine($readeachline)
}

$writeline = ""
$field = $readeachline -split '\s'


if ($eachlinenumber -eq 2) {
$numOfFields = $field.Count
Write-Host "Number of fields = $numOfFields"
}
elseif ($eachlinenumber -gt 1) {
foreach($i in $field) {
$writeline += "$i$delimiter"
}
Write-Host $writeline
$newStreamWriter.WriteLine($writeline)
}

$eachlinenumber++
}

$newStreamWriter.Close()

<<<------------------------------------------- END SCRIPT ------------------------------------------->>