Hi all,

I cut specific cell(row=2, column=1) in my excel file and created new file using following script.

awk -F"," 'NR ==2 {print $1}' file1.csv > file1_new.csv

awk -F"," 'NR ==2 {print $1}' file2.csv > file2_new.csv

and so on....

The problem is that I have thousand files and I have to do the same procedure thousand times.

How can I make this simple using loop command?

Thanks in advance.

I did not test this one, but you can do it:

for file in *.csv
do
    awk -F"," 'NR==2 {print $1}' ${file} > ${file}_new
done

This should work:

...
    awk -F"," 'NR==2 {print $1}' ${file} > ${file%.*}_new.cvs
...

Thanks a lot!!!!