Visit Our UNIX and Linux User Community


Replacing a specific column of a text file with another column


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Replacing a specific column of a text file with another column
# 1  
Old 06-28-2011
Replacing a specific column of a text file with another column

I have a text file in the following format:
Code:
13412 NA06985 0 0 2 46.6432798439	4 4 4 4 
13412 NA06991 NA06993 NA06985 2 48.8478948517   4 4 2 4
13412 NA06993 0 0 1 45.8022601455	4 4 2 4 
13401 NA06994 0 0 1 48.780669145        4 4 4 4 
13401 NA07000 0 0 2 47.7312017846	2 4 4 4 
13402 NA07019 NA07022 NA07056 2 41.7389244255   4 4 4 4 
13402 NA07022 0 0 1 54.1498530714	4 4 4 4 
13401 NA07029 NA06994 NA07000 1 X	2 4 4 4 
13411 NA07034 0 0 1 41.709838673        4 4 2 4 
13411 NA07048 NA07034 NA07055 1 41.4599808018   4 4 4 4

I want to replace column 6 with a different column (The new column is in a file called column.txt) How do I go about doing that? Thanks!

Last edited by Scott; 06-28-2011 at 05:32 PM.. Reason: Code tags, please...
# 2  
Old 06-28-2011
Is there a key in the new file (then it is a join) or one for one (paste together and awk the columns around?)
Code:
$ echo '1
> 2
> 3'>a
$ echo '4
> 5
> 6'>b
$ paste a b
1       4
2       5
3       6
$ paste a b|awk '{print $2 $1}'  
41
52
63
$

# 3  
Old 06-28-2011
The new file basically looks like this:

0.8790063238
0.8474671494
0.7592438321
0.9052356303
0.8498985801
0.940782332
0.7890000695
X
0.8253697252
0.7597086586
0.8380313668
0.8243804613
0.7485355649

It will replace the sixth column of the original file
# 4  
Old 06-28-2011
Yes, one column, no key to drive a join, like a SSN in the first column of both that must be matched. Enjoy the paste awk example.
 

Previous Thread | Next Thread
Test Your Knowledge in Computers #454
Difficulty: Medium
LibreOffice is a free and open office suite developed and maintained by IBM.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Append a specific keyword in a text file into a new column

All, I have some sample text file(.csv) in the below format. In my actual file there are at least 100K rows. date 03/25/2016 A,B,C D,E,F date 03/26/2016 1,2,3 4,5,6 date 03/27/2016 6,4,3 4,5,6 I require the following output where in the date appeared at different locations need to... (3 Replies)
Discussion started by: ks_reddy
3 Replies

2. Shell Programming and Scripting

Overwrite specific column in xml file with the specific column from adjacent line

I have an xml file dumped from rrd file, that I want to "patch" so the xml file doesn't contain any blank hole in the resulting graph of the rrd file. Here is the file. <!-- 2015-10-12 14:00:00 WIB / 1444633200 --> <row><v> 4.0419731265e+07 </v><v> 4.5045912770e+06... (2 Replies)
Discussion started by: rk4k
2 Replies

3. UNIX for Dummies Questions & Answers

Switching the values in a specific column of a text file

Hi, I have a space de-limited text file. In the fifth column, I would like to switch "1"s with "2"s. How do I go about doing that? Thanks! Sample input: 0 311000259 0 0 1 1 0 311000397 0 0 1 2 0 311000491 0 0 2 1 0 311000516 0 0 2 1 0 311000541 0 0 1 1 0 311000558 0 0 2 1 0 311000566 0... (1 Reply)
Discussion started by: evelibertine
1 Replies

4. Shell Programming and Scripting

Awk: Need help replacing a specific column in a file by part of a column in another file

Hi, I have two input files as File1 : ABC:client1:project1 XYZ:client2-aa:project2 DEF:client4:proj File2 : client1:W-170:xx client2-aa:WT-04:yy client4:L-005A:zz Also, array of valid values can be hardcoded like Output : ABC:W:project1 XYZ:WT:project2 (1 Reply)
Discussion started by: aa2601
1 Replies

5. Shell Programming and Scripting

Replace column that matches specific pattern, with column data from another file

Can anyone please help with this? I have 2 files as given below. If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value. file1 abc_1 foo1@a .... abc_1 soo2@a ... def_2 soo2@a .... def_2 foo1@a ........ (7 Replies)
Discussion started by: prashali
7 Replies

6. UNIX for Dummies Questions & Answers

Use sed to replace but only in a specific column of the text file

Hi, I would like to use sed to replace NA to x ('s/NA/x/g'), but only in the 5th column of the space delimited text file, nowhere else. How do I go about doing that? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies

7. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

Hi, I have a text file in the following format: Code: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 ... (2 Replies)
Discussion started by: evelibertine
2 Replies

8. Shell Programming and Scripting

Replacing column with another column of different file by awk

Hi All, I will really appreciate if you kindly lookinto my requirement below and provide me a solution First file format test1.txt qq ww rr tt ee ff qq ww rr tt ee ff Second file format text2.txt aa aa Now o/p I want as text1.txt's 4th column replaced... (5 Replies)
Discussion started by: Pratik4891
5 Replies

9. Shell Programming and Scripting

Assigning a specific format to a specific column in a text file using awk and printf

Hi, I have the following text file: 8 T1mapping_flip02 ok 128 108 30 1 665000-000008-000001.dcm 9 T1mapping_flip05 ok 128 108 30 1 665000-000009-000001.dcm 10 T1mapping_flip10 ok 128 108 30 1 665000-000010-000001.dcm 11 T1mapping_flip15 ok 128 108 30... (2 Replies)
Discussion started by: goodbenito
2 Replies

10. UNIX for Dummies Questions & Answers

Replacing a column in a text file

Say I had a text file that contained four columns, like the following: Mack Christopher:237 Avondale Blvd:970-791-6419:S Ben Macdonor:30 Dragon Rd:647-288-6395:B I'm making a loop that will replace the fourth column a line in the file with the contents of a variable 'access', but I have no... (6 Replies)
Discussion started by: Sotau
6 Replies

Featured Tech Videos