UNIX for Dummies Questions & Answers

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.

Assuming:
A. You know how many files there are
B. The files are named consecutively ie. file1.csv => file1000.csv

Try this for 1000 files: (I haven't tested though)

Code:

count=1000
while [[ $count -gt 0 ]];do
  awk -F"," 'NR ==2 {print $1}' file$count.csv > file$count_new.csv   
   (( count -= 1 ))
done

Thanks a lot!!!!!

Or:
(use nawk or /usr/xpg4/bin/awk on Solaris)

Code:

awk -F, 'FNR == 2 { 
  sub(/\.[^.]*$/, "", FILENAME)
  f = FILENAME "_new.csv"
  print $1 > f
  close(f)
}' *csv

Closing this thread because it's a duplicate of this one.