Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

writing to a file using awk

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting writing to a file using awk
# 1  
Old 09-14-2006
writing to a file using awk
using awk, we can read a specific column of a file.
is it possible to write to a specific column of a file too?
and how? (if possible)
# 2  
Old 09-14-2006
Quote:
Originally Posted by gfhgfnhhn
using awk, we can read a specific column of a file.
is it possible to write to a specific column of a file too?
and how? (if possible)

You could do something like

cat filename |while read file
do
echo $file |awk '{print $1,$2,$3"abc",$4}' >> newfile
done

Where abc will be joined onto existing text in column 3.
# 3  
Old 09-14-2006
in fact what i want to do is:
i have 8 files, each have 5 column data
i want to merge these files into 1 file,
so i will get a 1 file with 40 column
# 4  
Old 09-14-2006
use paste command to do that
# 5  
Old 09-14-2006
try this:
paste -d " " file1 file2 file3 file4 file5 > newfile

-d specifies the delimiter. i'm assuming that space is the delimiter in the files.
# 6  
Old 09-14-2006
thanks a lot, i got it
# 7  
Old 09-15-2006
Quote:
Originally Posted by gefa
You could do something like

cat filename |while read file
do
echo $file |awk '{print $1,$2,$3"abc",$4}' >> newfile
done

Where abc will be joined onto existing text in column 3.
Hi Gefa,

Just for you info, you don need the loop in the above command, rather use


Quote:
awk '{print $1,$2,$3"abc",$4}' filename > newfile
because awk processes each line in the file

Gaurav
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk - writing matching pattern to a new file and deleting it from the current file

Hello , I have comma delimited file with over 20 fileds that i need to do some validations on. I have to check if certain fields are null and then write the line containing the null field into a new file and then delete the line from the current file. Can someone tell me how i could go... (2 Replies)
Discussion started by: goddevil
2 Replies

2. Shell Programming and Scripting

help with writing a awk/sed script

Hi, I thought I am getting pretty good with sed and awk, but now I dont have a way out of this question. I have a table 0.5 16 1.3 14 0.25 15 0.85 16 I want to make a column 3 which contains values that are (corresponding $2 value/sum of all $2). Please help me out here. Thanks. (6 Replies)
Discussion started by: jamie_123
6 Replies

3. UNIX for Dummies Questions & Answers

awk: issues for writing a script

%%%%% (7 Replies)
Discussion started by: lucasvs
7 Replies

4. Shell Programming and Scripting

Writing over an old file using AWK

Hey guys! This should be fairly easy to most, not me evidently! I've written a script (see below). This script is going to be run daily, on a Task Scheduler, as data is going to be continuously added to the files it reads from(all the .dat files in the '2011' folder). Basically, whenever... (1 Reply)
Discussion started by: gd9629
1 Replies

5. Shell Programming and Scripting

Help in writing a find/replace script using awk

Hi All, I need to write a script that will go through 600+ files and perform find and replace. I was going to use sed but there is a level of complexity that is doing my head in. To explain: I have 600+ files that have a line in them that reads (for example) FILE=DCLCLHST... (4 Replies)
Discussion started by: Kocko
4 Replies

6. Shell Programming and Scripting

Writing output into different files while processing file using AWK

Hi, I am trying to do the following using AWK program. 1. Read the input data file 2. Parse the record and see if it contains errors 3. If the record contains errors, then write it into Reject file, else, write into usual output file or display it on the screen Here is what I have done -... (6 Replies)
Discussion started by: vidyak
6 Replies

7. Shell Programming and Scripting

AWK Help- Writing Data into a File

Hi All, I need to maintain a AUDIT file in system for every incoming and outgoing file. For this i am trying to append a record by using the AWK every time the file arriving. I have used the code as below. AWK '{print "FILENAME IS", $1,"DATE IS", $2}' >> AUDITFILE.txt $1 and $2 are global... (1 Reply)
Discussion started by: Raamc
1 Replies

8. Shell Programming and Scripting

plz help in writing awk script

hi buddies pls help in this matter i have file like this input file -------------------------- (PARTITION PARTITION_1 VALUES LESS THAN (101, 16383 ) TABLESPACE PART_1 ,PARTITION PARTITION_2 VALUES LESS THAN (101, 32766 ) TABLESPACE PART_2 ,PARTITION PARTITION_3 VALUES LESS THAN (101,... (3 Replies)
Discussion started by: LAKSHMI NARAYAN
3 Replies

9. Shell Programming and Scripting

help in writing awk script, plz urgent

I have a file like this I have to I have input file this , I want to give the out put in the below input file (NARAYANA 1 ENDING AT (100, 16383) ,NARAYANA 2 ENDING AT (100, 32766) ,NARAYANA 3 ENDING AT (100, 49149) ,NARAYANA 4 ENDING AT (100, 65535) ,NARAYANA 5... (8 Replies)
Discussion started by: LAKSHMI NARAYAN
8 Replies

10. Shell Programming and Scripting

hi help in writing awk script(urgently)

hi to all i have file like this file.txt this is naryana expect hyderabad is a cool place now climate VISAKHSAPATNAM became very cool #vizag is my birth place #hyderabad is a cool place #now climate of hyd became very cool #vizag is my birth place #hyderabad is a cool place ... (7 Replies)
Discussion started by: LAKSHMI NARAYAN
7 Replies
Login or Register to Ask a Question