Shell Programming and Scripting

Hi,

I have a directory that contains say 100 files named sequencially like input_1.25_50_C1.txt
input_1.25_50_C2.txt
input_1.25_50_C3.txt
input_1.25_50_C4.txt
..
..
..
input_1.25_50_C100.txt

an example of the content in each of the file is:

"NAME" "MEM.SHIP"
"cgd1_10" "cgd1_10" 0.938962779873022
"cgd1_1860" "cgd1_1860" 0.728179501334915
"cgd1_2500" "cgd1_2500" 0.751709755780061
"cgd1_2560" "cgd1_2560" 0.8086690400501
"cgd1_2640" "cgd1_2640" 0.750586302165714
"cgd1_2800" "cgd1_2800" 0.954020921349781
"cgd1_290" "cgd1_290" 0.757355995574881
"cgd1_2950" "cgd1_2950" 0.558344549451538
"cgd1_3010" "cgd1_3010" 0.667420188529345
"cgd1_50" "cgd1_50" 0.545172222953814
"cgd2_1000" "cgd2_1000" 0.944926355001402
"cgd2_1690" "cgd2_1690" 0.861817882469458
"cgd3_1820" "cgd3_1820" 0.817150133730118
"cgd3_2150" "cgd3_2150" 0.553855831143878
"cgd4_2220" "cgd4_2220" 0.577452218116135


I want to delete the second & third column of each file, make the file tab delimited and replace the column heading "NAME" in the first column as [Gene]

Is there a way in awk or shell programming to do this at a directory level; without openning each file and editing it.

Please let me know.

Lucky Ali

I think I am missing something here as usual.

Your input file seems to only have 3 columns, if you want to delete 2 and 3 what is left to delimit with tabs? You also say it is coma delimited but I see no coma's....

Sorry,
Forget about the tab delimit and comma separated. It was my mistake. I just wanted the first column with out enclosed with " " and change the heading for all the files in the Directory.

---------- Post updated at 02:39 PM ---------- Previous update was at 02:37 PM ----------

Need to delete column 2 and 3

---------- Post updated at 02:45 PM ---------- Previous update was at 02:39 PM ----------

Also if I import the above file in excel, I have to use ',' as delimter

suggestion to get the first column of each file

Code:

for FILE in *.txt
do
    NEWFILE=new-$FILE # It's an example
    cut -d' ' -f1 $FILE > $NEWFILE
done

Hi
I type this:

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

but it just copied the file like that into another file with the new name

Let me know what mistake I did

Option for cut : -d [delimiter] i've put a space between the quotes : -d ' '.
-f [field number(s)].
if You don't specify -d, the [TAB] will be used as delimiter. In any case the delimiter must be a single caracter.
It seems that you did'nt put anything between the quotes.

I specified a space in between the quotes and tried again. But still it just copying the file in a new file; not getting the first column. Let me know if you need any other info