I want to use sed on Linux to change all the second fields in a CSV file for all rows except the first row (which is the header). I'm aware that I can just loop this and go line by line using sed -i '{$LINE_NUMBER ....' and not using this on that line, but I'm wondering if there is a way to do this without a loop which is slower.
I guess I could also just change all contents. Then in the next line change it back for this one particular line.
| Q1 | Q2 | Q3 |
| Name | Resource_ID | Key |
| Joseph | 343433| AGFD |
| Mary | 242355 | AREW |
sed
will be the best tool for the job if you are working with fields, but we can't know without seeing the data.