Hello 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.

Provided in your current directory that all of your datafiles end with a csv extension: #!/bin/bash # untested for nm in *.csv do nfile=$(basename "$nm" .csv) nfile="${nfile}_new.csv" awk ... "$nm" > "$nfile" done

You may want to try Perl as your scripts get more advanced. It is on most Linux/UNIX systems shipped. perldoc perl from the command line. Perl was inspired by awk in the 80's. Larry Wall of NASA is the original author. UNIX/Linux is its home turf. Web Developer