04-04-2011
Awk to add columns from a file into an existing file
Hi!
I would need some help to add the last two columns of one file into another file using awk (or something similar).
For example, I have:
file 1: file 2:
car book day root lag
bar look pay boot tag
tar took may moot sag
I want to have: file 2 transformed into:
file 2 (new):
root lag book day
boot tag look pay
moot sag took may
Thanks!!!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
not required this time (36 Replies)
Discussion started by: Sandeep_Malik
36 Replies
2. Solaris
Hi,
I was trying to add a file to the existing zip file and i was using the below command but could not able to succeed. Could you please throw some light on this. Thanks for your time.
Syntax
zip 20081029.zip Siebel_DW_Rep_Dev2_20081016.rep
Error message:
zip warning: missing end... (2 Replies)
Discussion started by: Ariean
2 Replies
3. Shell Programming and Scripting
Hi guys,
Please help me if u have some solution.
I have a file with three columns separated by ':' -
INPUT_FILE
C416722_2 : calin Dirigent : Dirigent
AC4174_6 : Jac : cal_co
TC4260_5 : [no : lin kite
BC426302_1 : [no : calin Dirigent lin
JC426540_3 : lin Pymo_bin : calin
TC428_3 : no7... (4 Replies)
Discussion started by: sam_2921
4 Replies
4. Shell Programming and Scripting
Hi All ,
Kindly help me with this soln
awk '{printf "%s %7s \n", $1,$c}' infile
where
value of variable c I am externally giving input
But executing the above command shows all the columns of infile where as I want only 1st column of infile and 2nd column should print value c (8 Replies)
Discussion started by: Pratik4891
8 Replies
5. Shell Programming and Scripting
Hi everybody,
I need some help please
I have a csv file named masterFile1.csv
header1,header2,header3
value1,value2,value3
value4,value5,value6
I am trying to add new columns in the end of the csv to have a new csv file named masterFile2.csv like this :... (3 Replies)
Discussion started by: villebonnais
3 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
i have an excel sheet as below:
day
-----
monday
tuesday
wenesday
thursday
friday
i need to append the two more columns in this existing file below:
insert date should be todays date---
day insert date insert user
---- ---------- ... (3 Replies)
Discussion started by: arunmanas
3 Replies
7. Shell Programming and Scripting
I have two files which has one column comman in them.
The two files has exact same number of rows in the same sequence.
I want to add the second column of Users_detail_servicesonly.txt as last column in the existing file.
1) Users_detail_complete.txt
V0135 Memb Info ... (4 Replies)
Discussion started by: Sanjeev Yadav
4 Replies
8. Shell Programming and Scripting
Input File 1
cat S1.txt
MI0043 2731 miR-1
Input File 2
cat S4.txt
MI006 310 CiR-1
MI057 10 CiR-24
MI750 5 CiR-24
Desired Output File 1
cat S1.txt.out
MI0043 2731 miR-1 S1.txt
Desired Output File 2
cat S4.txt.out
MI006 310 CiR-1 S4.txt (3 Replies)
Discussion started by: perl_beginner
3 Replies
9. Shell Programming and Scripting
Hello all,
I have a .csv file of 16 columns consists of bunch of numbers.
6.45E+01 1.17E+01 8.10E+04 8.21E+01 8.50E+00 1.20E+01 1.02E+01 1.88E+01 1.86E+04 3.53E+03 1.09E+07 3.82E+04 2.09E+03 3.57E+03 2.98E+03 3.93E+03
6.34E+01 3.23E+01 9.24E+04 ... (5 Replies)
Discussion started by: Zam_1234
5 Replies
10. Shell Programming and Scripting
Hi all,
I am kind of stuck with printing my desired output. Please help me if you know how it can work.
My input file(tab separated):
NW_0068.1 41,16 100,900
NW_0699.1 4,2,19 200,700,80
My Output file (desired):
NW_0068.1 41,16 100,900 100 - 141
NW_0068.1 41,16 100,900 ... (3 Replies)
Discussion started by: sam_2921
3 Replies
sag(1) User Commands sag(1)
NAME
sag - system activity graph
SYNOPSIS
sag [-e time] [-f file] [-i sec] [-s time] [-T term] [-x spec] [-y spec]
DESCRIPTION
The sag utility graphically displays the system activity data stored in a binary data file by a previous sar(1) run. Any of the sar data
items may be plotted singly or in combination, as cross plots or versus time. Simple arithmetic combinations of data may be specified. sag
invokes sar and finds the desired data by string-matching the data column header (run sar to see what is available). The sag utility
requires a graphic terminal to draw the graph, and uses tplot(1) to produce its output. When running Solaris 2.x and OpenWindows, perform
the following steps:
1. Run an "xterm" as a Tektronics terminal: prompt# xterm -t
2. In the "xterm" window, run sag specifying a tek terminal: prompt# sag -T tek options
OPTIONS
The following options are supported and passed through to sar (see sar(1)):
-e time Select data up to time. Default is 18:00.
-f file Use file as the data source for sar. Default is the current daily data file /usr/adm/sa/sadd.
-i sec Select data at intervals as close as possible to sec seconds.
-s time Select data later than time in the form hh[:mm]. Default is 08:00.
-T term Produce output suitable for terminal term. See tplot(1) for known terminals. Default for term is $TERM.
-x spec x axis specification with spec in the form:
name[op name]...[lo hi]
name is either a string that will match a column header in the sar report, with an optional device name in square brackets, for
example, r+w/s[dsk-1], or an integer value. op is + - * or / surrounded by blank spaces. Up to five names may be specified.
Parentheses are not recognized. Contrary to custom, + and - have precedence over * and /. Evaluation is left to right. Thus,
A/A+B*100 is evaluated as (A/(A+B))*100, and A+B/C+D is (A+B)/(C+D). lo and hi are optional numeric scale limits. If unspecified,
they are deduced from the data.
Enclose spec in double-quotes ("") if it includes white space.
A single spec is permitted for the x axis. If unspecified, time is used.
-y spec y axis specification with spec in the same form as for -x. Up to 5 spec arguments separated by a semi-colon (;) may be given for
-y. The -y default is:
-y"%usr0100;%usr+%sys0100;%usr+%sys+%wio0100"
EXAMPLES
Example 1: Examples of the sag command.
To see today's CPU utilization:
example$ sag
To see activity over 15 minutes of all disk drives:
example$ TS=`date +%H:%M`
example$ sar -o /tmp/tempfile 60 15
example$ TE=`date +%H:%M`
example$ sag -f /tmp/tempfile -s $TS -e $TE -y "r+w/s[dsk]"
FILES
/usr/adm/sa/sadd daily data file for day dd
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWaccu |
+-----------------------------+-----------------------------+
SEE ALSO
sar(1), tplot(1), attributes(5)
SunOS 5.10 4 Mar 1998 sag(1)