Shell Programming and Scripting

I tried with a file containing your sample data and returns the first column.
I thought the delimiter in your file was a space but if i'ts a TAB just remove the -d option

Code:

for FILE in *.txt; do NEWFILE=new-$FILE; cut -f1 $FILE > $NEWFILE; done

for test you can remove the " > $NEWFILE " for a screen output and when it works, put it again.

Actually this is the content of each file.

"","NAME","MEM.SHIP"
"cgd2_3990","cgd2_3990",0.502835961835107
"cgd2_580","cgd2_580",0.518630633066887
"cgd3_2220","cgd3_2220",0.542186902734677
"cgd4_1650","cgd4_1650",0.583454483346155
"cgd4_260","cgd4_260",0.551425561426544
"cgd5_840","cgd5_840",0.675010580680461
"cgd6_70","cgd6_70",0.517322140721342
"cgd8_1520","cgd8_1520",0.743127593091679


The first column is "","

---------- Post updated at 04:02 PM ---------- Previous update was at 03:38 PM ----------

The file was comma separated and when I specified -d ',' it worked fine.
Thanks.
the out put of the file looks like

"NAME"
"cgd1_200"
"cgd1_3210"
"cgd1_560"
"cgd2_2760"
"cgd2_290"
"cgd3_3210"
"cgd3_3310"
"cgd3_660"
"cgd5_2130"
"cgd5_4080"
"cgd6_3690"
"cgd6_4480"
"cgd8_1540"
"cgd8_3860

I have another question:
I wanted to remove the " " from the above.
I can apply regular expression to this file using the command %s/"//ig.
But I have to do it for each and every file.

How do i apply the above regular expression in awk or shell programming so that I do it to all the files.

Please let me know.

---------- Post updated at 04:05 PM ---------- Previous update was at 04:02 PM ----------

Frans,

The file was comma separated and when I specified -d ',' it worked fine.
Thanks.
the out put of the file looks like

"NAME"
"cgd1_200"
"cgd1_3210"
"cgd1_560"
"cgd2_2760"
"cgd2_290"
"cgd3_3210"
"cgd3_3310"
"cgd3_660"
"cgd5_2130"
"cgd5_4080"
"cgd6_3690"
"cgd6_4480"
"cgd8_1540"
"cgd8_3860

I have another question:
I wanted to remove the " " from the above.
I can apply regular expression to this file using the command %s/"//ig.
But I have to do it for each and every file.

How do i apply the above regular expression in awk or shell programming so that I do it to all the files.

Please let me know.

replace the

Code:

cut -d',' -f1 > $NEWFILE

with

Code:

cut -d',' -f1 | sed 's/"//g' > $NEWFILE