05-02-2013
Sounds like a task for awk. What have you tried so far? I can see you have plenty of threads opened with questions about similar problems, which have all been answered and solved.
Any post before the OP answers will be moderated.
Last edited by zaxxon; 05-02-2013 at 12:15 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi guys,
Couldn't find the solution of this problem. Please Help!
I have a file-
Input_File
TC200232 92 30
TC215306 2 74
TC210135 42 14
I want an output file in which if column2>column3, the values are swapped and an additional column with value Rev_Com is... (4 Replies)
Discussion started by: smriti_shridhar
4 Replies
2. Shell Programming and Scripting
I've got a long logfile of the form
network1:123:45:6789:01:234:56
network2:12:34:556:778:900:12
network3:...
I've got a similar logfile from a week later with different values for each of the fields eg
network1:130:50:6800:10:334:66
network2:18:40:600:800:999:20
network3:...
... (5 Replies)
Discussion started by: Yorkie99
5 Replies
3. Shell Programming and Scripting
Hi,
I want to subtract a number from all columns except the first column. I have a number of files each having different columns around 60/70. How to do that in awk or any other command?
Thanks
Input
Col 1 Col 2 Col3 - - - - Col55
1 .0123 .098 - - - 0.6728
2 - -... (3 Replies)
Discussion started by: Surabhi_so_mh
3 Replies
4. Shell Programming and Scripting
Hi,
I have a file as listed below.. What I want to get is for each unique value in column 1 the corresponding values in the rest of the columns should be summed up..
AAK1 0 1 0 11
AAK1 0 0 1 1
AAK1 0 0 1 2... (2 Replies)
Discussion started by: Diya123
2 Replies
5. Shell Programming and Scripting
space_used.lst
/dev/vx/dsk/A06487-S01-c4e3s-ORACLE-dg/oradata01 505G 318G 175G 65% /dborafiles/nethealth21/PV/oradata01
/dev/vx/dsk/A06487-S01-c4e3s-ORACLE-dg/oradata02 505G 433G 67G 87% /dborafiles/nethealth21/PV/oradata02
/dev/vx/dsk/A06487-S01-c4e3s-ORACLE-dg/oradata03 507G 422G 79G 85%... (4 Replies)
Discussion started by: sathik
4 Replies
6. Shell Programming and Scripting
Hi All,
I have a pipe seperated file. I need to add the values in second and third columns with group by on first column.
MYFILE_28012012_1115|47|173.90
MYFILE_28012012_1115|4|0.00
MYFILE_28012012_1115|6|22.20
MYFILE_28012012_1116|47|173.90
MYFILE_28012012_1116|4|0.00... (3 Replies)
Discussion started by: angshuman
3 Replies
7. UNIX for Dummies Questions & Answers
---------- Post updated at 01:58 PM ---------- Previous update was at 01:48 PM ----------
For some reason my question is not getting printed. Here are the details:
Greetings.
I would like to add/subtact an integer to/from two columns of integers. I feel like this should be easy using awk... (3 Replies)
Discussion started by: Twinklefingers
3 Replies
8. Shell Programming and Scripting
Hi below is a file
Date Category Time Attempts Success
2/17/2014 PayFlow ATB 0.999988 4039104 4039057
2/18/2014 PayFlow ATB 0.999912 4620964 4620558
2/19/2014 PayFlow ATB 0.999991 4380836 4380796
2/20/2014 PayFlow ATB 0.999988 5031047 5030985
2/21/2014 ... (5 Replies)
Discussion started by: villain41
5 Replies
9. Shell Programming and Scripting
data.txt:
0,mq_conn_open_error,1444665949,734,/PROD/G/cicsitlp/sys/unikixmain.log,64K,mq_conn_open_error,62022,0,733--734
0,mq_conn_open_error,1444666249,734,/PROD/G/cicsitlp/sys/unikixmain.log,64K,mq_conn_open_error,62022,0,734--734... (7 Replies)
Discussion started by: SkySmart
7 Replies
10. UNIX for Beginners Questions & Answers
Columns 4 and 5 are X and Y coordinates, column 6 is the elevation
I would like to add 2 new columns at the end of the file with values
the distance between first(X)(Y) and last location (X)(Y), based in 2 rows
the difference in elevation = ($6-prev6)
How to calculate the requested values... (6 Replies)
Discussion started by: jiam912
6 Replies
LEARN ABOUT MINIX
pnmarith
pnmarith(1) General Commands Manual pnmarith(1)
NAME
pnmarith - perform arithmetic on two portable anymaps
SYNOPSIS
pnmarith -add|-subtract|-multiply|-difference|-minimum|-maximum. pnmfile1 pnmfile2
DESCRIPTION
Reads two portable anymaps as input. Performs the specified arithmetic operation, and produces a portable anymap as output. The two input
anymaps must be the same width and height.
The arithmetic is performed between corresponding pixels in the two anymaps, as if maxval was 1.0, black was 0.0, and a linear scale in
between. Results that fall outside of [0..1) are truncated.
The operator -difference calculates the absolute value of pnmarith -subtract pnmfile1 pnmfile2, i.e. no truncation is done.
All flags can be abbreviated to their shortest unique prefix.
SEE ALSO
pbmmask(1), pnmpaste(1), pnminvert(1), pnm(5)
AUTHOR
Copyright (C) 1989, 1991 by Jef Poskanzer. Lightly modified by Marcel Wijkstra <wijkstra@fwi.uva.nl>
26 August 1993 pnmarith(1)