Copy a column and paste to other file question


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Copy a column and paste to other file question
# 1  
Old 03-29-2012
Bug Copy a column and paste to other file question

Please help me. This is simple, but urgent problem for me. Smilie

I have a two files

file1
Code:
1  2  3  4  5  6
1  2  3  4  5  6  
1  2  3  4  5  6

.....

file2
Code:
11  12  13  14  15
11  12  13  14  15
11  12  13  14  15

.....

1) I hope to make a new file, file 3, that consists of 2nd column of file 1, and 5th column of file 2. And the result would be
file3
Code:
2  15
2  15
2  15

...

2) I hope to copy 2nd column of file1, then paste it to file 2 as 6th column. The result would be
file2
Code:
11  12  13  14  15  2
11  12  13  14  15  2
11  12  13  14  15  2

....

I've been tried with awk or cut command, but all of my codes didn't work. Please, somebody help me.
Linux code or vi editor method, anything is fine. Please help me Smilie
# 2  
Old 03-29-2012
for case 1)
Code:
pr -tm -s" " file1 file2  | awk -F " "  '{print $2FS$11}'  > file3

for case 2)
Code:
pr -tm -s" " file1 file2  | awk -F " "  '{print $6FS$7FS$8FS$9FS$10FS$11FS$2}'  > file2_tmp
mv file2_tmp file2

# 3  
Old 03-29-2012
No need for the overhead of the pr command:

Code:
# case 1
awk -v f2=file2 ' { c = $2; getline < f2; print c, $5; } ' file1 >output-file

#case 2
awk -v f2=file2 ' { c = $2; getline < f2; print $0, c; } ' file1 >output-file



This is the simple case; a bit of extra code is needed to handle the case where files are not of equal length. It sounds like both files are the same length, so I'll leave it simple.
This User Gave Thanks to agama For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to copy a column of multiple files and paste into new excel file (next to column)?

I have data of an excel files as given below, file1 org1_1 1 1 2.5 100 org1_2 1 2 5.5 98 org1_3 1 3 7.2 88 file2 org2_1 1 1 2.5 100 org2_2 1 2 5.5 56 org2_3 1 3 7.2 70 I have multiple excel files as above shown. I have to copy column 1, column 4 and paste into a new excel file as... (26 Replies)
Discussion started by: dineshkumarsrk
26 Replies

2. Shell Programming and Scripting

Bash copy and paste text in file from one position to another

Hi I have a text file with lines beginning with 71303, 71403, 71602, I need to copy the 10 digit text at position 30 on lines beginning with 71303 (5500011446) to position 99 on every line beginning with 71602 (see example below), There may be many 71303 lines but I need the text copying to... (2 Replies)
Discussion started by: firefox2k2
2 Replies

3. Shell Programming and Scripting

Copy and paste text inside a xml file

I have a really big XML file. I need copy the value of one tag inside another one tag. I try to publish one example. <channel update="i" site="merge-xmltv" site_id="" xmltv_id="Rai 1">Rai 1</channel> <channel update="i" site="merge-xmltv" site_id="" xmltv_id="Rai 1 +2HD">Rai 1... (6 Replies)
Discussion started by: Tapiocapioca
6 Replies

4. UNIX for Dummies Questions & Answers

Paste column from one file as column of

Any shortcuts for doing this? I need to cut the column 4 values from File1 and paste them as column4 values of File2, but only for the (first) same number of lines as File1 . All rows in File1 are contained in File2 in the exact same order, so the cut paste should work. File1 (with header and 3... (4 Replies)
Discussion started by: senhia83
4 Replies

5. UNIX for Dummies Questions & Answers

Copy Lines between Keywords & paste them to another file

hi, I have Multiple files with the following data : File1 100414 DR1 END XXXXX Test1 Test2 Test3 Test4 Test5 Test6 END 100514 DR2 END XXXXX Test7 Test8 Test9 Test10 Test11 Test12 END 100614 DR3 (5 Replies)
Discussion started by: newageBATMAN
5 Replies

6. UNIX for Advanced & Expert Users

Copy a column to another column in UNIX fixedwidth file

Hi All, I have a fixedwidth file of length 3000. Now i want to copy a column of 4 chars i.e( length 1678-1681) to column 1127 – 1171 to the same file. Please let me know how can i achive using a single command in fixed width file. Also source column length is 4 chars and target column length... (4 Replies)
Discussion started by: kiranparsha
4 Replies

7. Shell Programming and Scripting

Copy and Paste Columns in a Tab-Limited Text file

I have this text file with a very large number of columns (10,000+) and I want to move the first column to the position of the six column so that the text file looks like this: Before cutting and pasting ID Family Mother Father Trait Phenotype aaa bbb ... (5 Replies)
Discussion started by: evelibertine
5 Replies

8. Solaris

Copy and paste text from a word document into a txt file in vi

Hello, Can anybody please tell me how we can copy and paste text from a word document into a text file that we are editing in vi? Is it possible to do that while we are editing the text file in vi in insert mode? Thanks, (3 Replies)
Discussion started by: Pouchie1
3 Replies

9. UNIX for Dummies Questions & Answers

copy and paste certain many lines of huge file in linux

Dear All, I am working with windoes OS but remote a linux machine. I wonder the way to copy an paste some part of a huge file in linux machine. the contain of file like as follow: ... dump annealling all custom 10 anneal_*.dat id type x y z q timestep 0.02 run 200000 Memory... (2 Replies)
Discussion started by: ariesto
2 Replies

10. Shell Programming and Scripting

read file column and paste it in command

Hi Unix gurus I have a file containing 2 coloumns. I would like to do a script which reads the lines and executes a command like this: command <field1> parameters <field2> some more parameters Please let me know how you would do this without AWK, SED or any other mini language (for special... (5 Replies)
Discussion started by: BearCheese
5 Replies
Login or Register to Ask a Question