Forum Discussion
Raghava Tiruchanur
Dec 30, 2022Copper Contributor
How to read tabbed delimitted csv file line by line using Powershell ?
Hi , I have file with many rows . Since the size of limitations I want to read only line by line and put into any array . Please assist .
Dec 31, 2022
Raghava Tiruchanur This splits every line by the tab character and fills the $total array with a ; delimiter
$total=@()
foreach ($line in Get-Content D:\Temp\file.txt) {
$content=$line.Split("`t") -join ';'
$total += $content
}
The contents of my test file.txt file are:
test1 test2 test3 test4
test5 test6 test7 test8