How can I add a Column of values in a file which has a certain number of rows. I have a input file like this:
SPATA17 1 217947738 LYPLAL1 1 219383905 FAM47E 4 77192838 SHROOM3 4 77660162 SHROOM3 4 77660731 SHROOM3 4 77662248
SPATA17 1 217947738 file1 LYPLAL1 1 219383905 file1 FAM47E 4 77192838 file1 SHROOM3 4 77660162 file1 SHROOM3 4 77660731 file1 SHROOM3 4 77662248 file1
In this case,I want to add a Column of values,upto the number of rows in the file.The value remains consistent,such as "file1".
The reason is I have 100 of those files.I dont want to open each file and paste a column. Also is there any way to automate this,by going in a directory and adding a column of values. The value comes from the filename,which has to be added in each row of the file in the last/first column.