looping through a csv 4 ways
2024-11-09:
When working with large files, command line tools tend to be king. They are built for speed an
d can handle large files with ease. Most GUI's do not do well with text files larger than 200MB. This is where command line tools really shine.
The data
| artist | verse | word |
| eminim | 1 | you |
| eminim | 1 | got |
| eminim | 1 | to |
| eminim | 1 | loose |
| eminim | 1 | yourself |
PowerShell
Get-Content bigfile.csv | ForEach-Object {
$words = $_ -split ','
Write-Output $words[2]
}