Hi all,

I have a text file that has (4) columns. There are about 300 lines on this file. It is a plain text file. I am looking to write a simple script that will read each line from the file and generate another text file. The file looks something like this:

These are the columns:

StudentName Grade Class Teacher
StudentName2 Grade Class Teacher
...
...
...
StudentName300 Grade Class Teacher

What I need to do is extract the text from this file and re-arrange it into another file.

For example, this is how the new file would be arranged:

Teacher Class Grade StudentName

I can easily do it when a file has just a single line, like this:
-------------------
StudentName = `cat /fileName | awk '{print $1}'
Grade = `cat /fileName | awk '{print $2}'
Class = `cat /fileName | awk '{print $3}'
Teacher = `cat /fileName | awk '{print $4}'

echo "${Teacher} ${Class} ${Grade} ${StudentName}" >> /NewFile
-------------------

Where I am struggling is how would I do this for a file that has 300 lines instead of just one?

I am sure it is something simple, I just need to be pointed in the right direction.

Thanks in advance!