Sponsored Content
Top Forums Shell Programming and Scripting Replacing column with another column of different file by awk Post 302457462 by kurumi on Tuesday 28th of September 2010 05:28:20 AM
Old 09-28-2010
Code:
$ ruby  -ane 'BEGIN{a=[];b=File.read("file2").split}; $F[3]=b[$.-1]; puts $F.join(" ")' file
qq ww rr aa ee ff
qq ww rr aa ee ff

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Replacing column with column of another file

Hi, I have two input files. File1: ID Name Place 1-234~name1~Newyork 1-34~name2~Boston 1-2345~name3~Hungary File1 is a variable length file where each column is seperated by delimitter "~". File2: ID Country 1-34<<11 SPACES>>USA<<7 spaces>> 1-234<<10 SPACES>>UK<<8 spaces>> ... (1 Reply)
Discussion started by: manneni prakash
1 Replies

2. UNIX for Advanced & Expert Users

Replacing column with column of another file

Hi, I have two input files. File1: ID Name Place 1-234~name1~Newyork 1-34~name2~Boston 1-2345~name3~Hungary File1 is a variable length file where each column is seperated by delimitter "~". File2: ID Country 1-34<<11 SPACES>>USA<<7 spaces>> 1-234<<10 SPACES>>UK<<8 spaces>> ... (1 Reply)
Discussion started by: manneni prakash
1 Replies

3. Shell Programming and Scripting

Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2

Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2 file 1 sample SNDK 80004C101 AT XLNX 983919101 BB NETL 64118B100 BS AMD 007903107 CC KLAC 482480100 DC TER 880770102 KATS ATHR 04743P108 KATS... (7 Replies)
Discussion started by: rydz00
7 Replies

4. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

I have a text file in the following format: 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... (3 Replies)
Discussion started by: evelibertine
3 Replies

5. 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

6. 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

7. Shell Programming and Scripting

Compare the second column of a file with the second column of another in awk

Hi, I know that this topic has been discussed in the past and I've tried to follow all the guidelines. Anyhow, I following describe my problem. I have a file (file1 , no. records = 67) containing pairs of IP addresses as follows (with single space as delimiter between the fields): example... (5 Replies)
Discussion started by: amarn
5 Replies

8. Shell Programming and Scripting

How to awk or grep the last column in file when date on column contains spaces?

Hi have a large spreadsheet which has 4 columns APM00111803814 server_2 96085 Corp IT Desktop and Apps APM00111803814 server_2 96085 Corp IT Desktop and Apps APM00111803814 server_2 96034 Storage Mgmt Team APM00111803814 server_2 96152 GWP... (6 Replies)
Discussion started by: kieranfoley
6 Replies

9. Shell Programming and Scripting

Solution for replacement of 4th column with 3rd column in a file using awk/sed preserving delimters

input "A","B","C,D","E","F" "S","T","U,V","W","X" "AA","BB","CC,DD","EEEE","FFF" required output: "A","B","C,D","C,D","F" "S", T","U,V","U,V","X" "AA","BB","CC,DD","CC,DD","FFF" tried using awk but double quotes not preserving for every field. any help to solve this is much... (5 Replies)
Discussion started by: khblts
5 Replies

10. Shell Programming and Scripting

Matching column value from 2 different file using awk and append value from different column

Hi, I have 2 csv files. a.csv HUAWEI,20LMG011_DEKET_1296_RTN-980_IDU-1-11-ISV3-1(to LAMONGAN_M),East_Java,20LMG011_DEKET_1296_RTN-980_IDU-1,20LMG011,20LMG 027_1287_LAMONGAN_RTN980_IDU1,20LMG027,1+1(HSB),195.675,20LMG011-20LMG027,99.9995,202.6952012... (7 Replies)
Discussion started by: tententen
7 Replies
RUBY-BUILD(1)															     RUBY-BUILD(1)

NAME
ruby-build - compile and install Rubies SYNOPSIS
ruby-build [-v|--verbose] [-k|--keep] definition prefix ruby-build --definitions ruby-build --version ruby-build [-h|--help] rbenv install [-k|--keep] definition DESCRIPTION
ruby-build provides a simple way to compile and install different versions of Ruby on UNIX-like systems. ruby-build downloads, builds and installs the Ruby version specified in a definition into a prefix directory. Definitions can be chosen from the list of installed definitions or by specifying a file path for a definition. rbenv(1) users can also use the provided rbenv install command, which installs Rubies into the rbenv directory. OPTIONS
--definitions List available definitions. -k, --keep Don't delete source code after installation. -v, --verbose Display compiler messages on standard output. --version Show ruby-build version and exit. -h, --help Show usage information and exit. EXAMPLES
Install Ruby 1.9.3 (MRI, patch level 0) to ~/rubies/mri-1.9.3 $ ruby-build 1.9.3-p0 ~/rubies/mri-1.9.3 Install Ruby Enterprise Edition 1.8.7 (patch level 2011.03) for rbenv(1): $ rbenv install ree-1.8.7-2011.03 Install Ruby from a custom definition into ~/your-ruby: $ rbenv install /path/to/your/own/ruby/definition ~/your-ruby ENVIRONMENT
CC Sets the path to the C compiler. CONFIGURE_OPTS Options that are passed to configure when building a Ruby. MAKE_OPTS Options that are passed to make when building a Ruby. MAKEOPTS Used instead of MAKE_OPTS when MAKE_OPTS is not defined. TMPDIR Sets the location where ruby-build stores temporary files. RUBY_BUILD_BUILD_PATH Sets the location in which sources are downloaded and built. AUTHORS
ruby-build is developed by Sam Stephenson <sam@37signals.com>. This man page was written for the Debian GNU/Linux distribution by Sebastian Boehm <sebastian@sometimesfood.org> but may be used by others. SEE ALSO
rbenv(1) June 2012 RUBY-BUILD(1)
All times are GMT -4. The time now is 06:10 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy