Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

awk help urgent

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers awk help urgent
# 1  
Old 03-04-2008
awk help urgent
Hi

i am trying to read a line from a file and add the values in a new file

eg

Input file
a1|a2|a3|a4|a5|a6
b1|b2|b3|b4|b5|b6
c1|c2|c3|c4|c5|c6


expected output

File one

a1|a2|a3
b1|b2|b3
c1|c2|c3


file two

a1|a4
a1|a5
a1|a6
b1|b4
b1|b5
b1|b6
c1|c4
c1|c5
c1|c6


Please help.

Thanks
# 2  
Old 03-04-2008
Code:
> outfile1
> outfile2
awk -F'|' ' BEGIN {OFS="|"}
			{
			print $1,$2,$3 >> "outfile1"
			print $1,$4 >>    "outfile2"
			print $1,$5 >>    "outfile2"
			print $1,$6 >>    "outfile2"
			} ' filename

input
Quote:
/home/jmcnama> cat filename
a1|a2|a3|a4|a5|a6
b1|b2|b3|b4|b5|b6
c1|c2|c3|c4|c5|c6
output
Quote:
/home/jmcnama> cat outfile1
a1|a2|a3
b1|b2|b3
c1|c2|c3
/home/jmcnama> cat outfile2
a1|a4
a1|a5
a1|a6
b1|b4
b1|b5
b1|b6
c1|c4
c1|c5
c1|c6
# 3  
Old 03-04-2008
Woow thanks, That was wonderful..


iam trying to run it .. do i have to save the below code as sh


> outfile1
> outfile2
awk -F'|' ' BEGIN {OFS="|"}
{
print $1,$2,$3 >> "outfile1"
print $1,$4 >> "outfile2"
print $1,$5 >> "outfile2"
print $1,$6 >> "outfile2"
} ' filename

btw what does > outfile1 and outfile2 do??

Thanks Again
# 4  
Old 03-04-2008
Jesus H. Christ Jim. Get a home that you belong to. Smilie
Sorry, couldn't resist.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need Urgent help on awk/sed

Hi, Sample Input Table 1 XXXXX YYYYY A 1 2 3 4 5 B 1 2 3 4 5 C 1 2 3 4 5 D 1 2 3 4 5 A 6 7 B 6 7 C 6 7 D 6 7 Table 2 XXXXX YYYYY E 1 2 3 4 5 F 1 2 3 4 5 E 6 7 F 6 7 Table 3 XXXXX YYYYY G 1 2 3 4 5 (4 Replies)
Discussion started by: ravin
4 Replies

2. Shell Programming and Scripting

awk or sed help urgent

Hello, I have a file with the follwoing pattern: Input file: =========== tcp://xxx:123 8179 YY 1798 YY tcp://abc:2345 not found tcp://swt:4945 7356 QQ tcp://pqr:456 8178 PP 9485 PP 4485 PP (8 Replies)
Discussion started by: uandme2k2
8 Replies

3. Shell Programming and Scripting

Urgent awk help !!

Hi All,I need to convert following field from a file L2578978CLC/576/116804 => L2578978CLC/00000576/00168304 i have to append Zeros in the third and fourth number after slash / in the above string (total length of number should be 8). means L2578978CLC/576/116804 should be converted to... (3 Replies)
Discussion started by: unknown123
3 Replies

4. Shell Programming and Scripting

urgent help awk script

Hi I have a scenario where i have a file name as abcd_To_hfgh.20090456778_1.dat I will get the filename as parameter and i need a string in between second _ and first . i.e i need hfgh in this case. Please help me with the script. This may not be awk script even if it can be... (2 Replies)
Discussion started by: dsdev_123
2 Replies

5. Shell Programming and Scripting

XML Awk : Urgent

Hi All, I am a beginner to Unix. So would really appreciate if people out here can help me out. I have a XML file which has a element <NoteData> in which two values DBHA and DAKO. I need to search these in all the XML files in a directory and if found in the XML file then replace the... (3 Replies)
Discussion started by: karansachdeva
3 Replies

6. Shell Programming and Scripting

Awk Doubt _ Urgent

Guys I have the file TEST.csv generated after a join of two different files with the same columns: key,string,data,number,key,string,data,number abc,test,020202,3,abc,test,010305,4 abc,level,070202,9,abc,tool,010203,7 def,tool,010101,7,,,, ghi,,,ghi,test,010203,8 I have to generate a... (2 Replies)
Discussion started by: Rafael.Buria
2 Replies

7. Shell Programming and Scripting

Urgent!!!!! AWK

Thank everyone advanced. Would you please tell me how to use the shell variable in the awk body? I try follows but they all do not work, pls kindly help me: 1. str=`cat file2` awk 'BEGIN{print("'"$str"'"}' file1 > file3 2. str=`cat file2` awk 'BEGIN{print(ENVIRON}' file1 > file3 3.... (3 Replies)
Discussion started by: summer_cherry
3 Replies

8. Shell Programming and Scripting

Urgent - Looping using AWK

Hi I have a file which is having following text. The file is in a tabular form with 5 fields. i.e field1, field2 ..... field5 are its columns and there are many rows in it say COUNT is the number of rows Field 1 Field2 Field3 Field4 Field5 ------- ------- ... (8 Replies)
Discussion started by: skyineyes
8 Replies

9. Shell Programming and Scripting

Help me for AWK URGENT

i have a record like 1,23423,4545,6767,89898,3434,121212,123123,322 2,23233,3434,4545,56566,rxrx,e344343,343434,3434 1,23223,336,78787,78787,654,6767677,6877989,7878 i want to check the $6 field if its start with any letters, i want to move this record to some other file and keep rest of... (2 Replies)
Discussion started by: readycpbala
2 Replies
Login or Register to Ask a Question