using bash (sed/awk) to extract rows AND columns in CSV files? using bash (sed/awk) to extract rows AND columns in CSV files? bash bash

using bash (sed/awk) to extract rows AND columns in CSV files?


bash csv sed awk 

awk -F, 'NR > 1 { print $3 "," $4 "," $5 }'

NR is the current line number, while $3, $4 and $5 are the fields separated by the string given to -F

bash csv sed awk

Try this:

tail -n+2 file.csv | cut --delimiter=, -f3-5

bash csv sed awk

Bash solutions;

Using IFS

#!/bin/bashwhile IFS=',' read -r rank name school major year; do    echo -e "Rank\t: $rank\nName\t: $name\nSchool\t: $school\nMajor\t: $major\nYear\t: $year\n"done < file.csvIFS=$' \t\n'

Using String Manipulation and Arrays

#!/bin/bashdeclare -a arrwhile read -r line; do    arr=(${line//,/ })    printf "Rank\t: %s\nName\t: %s\nSchool\t: %s\nMajor\t: %s\nYear\t: %s\n" ${arr[@]}done < file.csv

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last