Sponsored Content
Top Forums Shell Programming and Scripting If condition satisfies print the column header Post 302803077 by Fredrick on Monday 6th of May 2013 02:34:43 AM
Old 05-06-2013
If condition satisfies print the column header

Dear All,

Good Day. I would like to solve the following issue and got some strange results, if anyone could help me in this regard, you are most welcome.

Here is the problem:

I have a file like

Header Value1 Value2 Value3 Value4 Value5 Value6 ... Value9
12.144 6 5 5 4 3 2 ...
10.2567 10 8 6 4 4 4 ...
22.2 2 2 1 1 1 1 ...
.................................
.................................

The above-mentioned file have more than 500 rows and 10 columns.

I would like to print a new additional columns (say for example column11 and column12), where the values from column2 to column9 can satisfy the following conditions:

if ($i > 5 && $(i+1) < 5) ------ print the column header (for example, in the first row case, Value 4) should be printed in column11 and at the same time,

if ($i > 3 && $(i+1) < 3) ------ print the column header (for example, in the first row case, Value 6) should be printed in column12 (in the output file with the same format).

I tried the following code, but i couldn't get the same number of rows. here is my code:
Code:
awk '{for(i=2; i<=NF; i++) {if($i > 5 && $(i+1) < 5) print $1=(i*5); else print ""}}' inputfile > outputfile

Expecting your reply and thanks in advance.

Warm regards
Fredrick.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

need to read a file and keep waiting till it satisfies some condition

In my script i am writing to a counter file the no of processes i had started, that is each time i start a process, i will increment the content of counter file and also when the process ends i will decrement the content of the file. after this i do some other activities, by now i want to... (1 Reply)
Discussion started by: senthilk615
1 Replies

2. Shell Programming and Scripting

awk/sed column replace using column header - help

$ cat log.txt Name Age Sex Lcation nfld alias xsd CC 25 M XYZ asx KK Y BB 21 F XAS awe SS N SD 21 M AQW rty SD A How can I replace the column with header "Lcation" with the column with header "alias" and delete the "alias" column? so that the final output will become: Name Age Sex... (10 Replies)
Discussion started by: jkl_jkl
10 Replies

3. Shell Programming and Scripting

Filter the column and print the result based on condition

Hi all This is my output of the some SQL Query TABLESPACE_NAME FILE_NAME TOTALSPACE FREESPACE USEDSPACE Free ------------------------- ------------------------------------------------------- ---------- --------- ---------... (2 Replies)
Discussion started by: jhon
2 Replies

4. Shell Programming and Scripting

Rename a header column by adding another column entry to the header column name URGENT!!

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies

5. UNIX for Dummies Questions & Answers

Rename a header column by adding another column entry to the header column name

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (1 Reply)
Discussion started by: Vavad
1 Replies

6. Shell Programming and Scripting

write a matrix element, if the "if" condition satisfies

Hi All, I would like to check a condition in a nxm matrix and if the condition satisfies then, I need to write the matrix element in the output file. For example, I have a matrix like this: 1 2 3 4 5 2 3 4 5 1 3 4 5 1 ... (8 Replies)
Discussion started by: Fredrick
8 Replies

7. Shell Programming and Scripting

Add column header and row header

Hi, I have an input like this 1 2 3 4 2 3 4 5 4 5 6 7 I would like to count the no. of columns and print a header with a prefix "Col". I would also like to count the no. of rows and print as first column with each line number with a prefix "Row" So, my output would be ... (2 Replies)
Discussion started by: jacobs.smith
2 Replies

8. Shell Programming and Scripting

Print column header

Hi, Below is the data in a tab limited file Here ACCENT is just a heading and the line starting with Pcode has the column headers, and there is a 2 lines space between the file header and column header. I want to print $2, that is Dealer Name I used the below code nawk... (1 Reply)
Discussion started by: kedar_laveti
1 Replies

9. Shell Programming and Scripting

Print the column content based on the header

i have a input of csv file as below but the sequence of column get changed. I,e it is not necessary that name comes first then age and rest all, it may vary. name,age,marks,roll,section kevin,25,80,456,A Satch,23,56,789,B Meena,24,78,H245,C So i want to print that column entires which... (12 Replies)
Discussion started by: millan
12 Replies

10. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies
Email::Simple::Header(3pm)				User Contributed Perl Documentation				Email::Simple::Header(3pm)

NAME
Email::Simple::Header - the header of an Email::Simple message SYNOPSIS
my $email = Email::Simple->new($text); my $header = $email->head; print $header->as_string; DESCRIPTION
This method implements the headers of an Email::Simple object. It is a very minimal interface, and is mostly for private consumption at the moment. METHODS
new my $header = Email::Simple::Header->new($head, \%arg); $head is a string containing a valid email header, or a reference to such a string. If a reference is passed in, don't expect that it won't be altered. Valid arguments are: crlf - the header's newline; defaults to CRLF as_string my $string = $header->as_string(\%arg); This returns a stringified version of the header. header_names This method returns the unique header names found in this header, in no particular order. header_pairs This method returns all the field/value pairs in the header, in the order that they appear in the header. header my $first_value = $header->header($field); my @all_values = $header->header($field); This method returns the value or values of the given header field. If the named field does not appear in the header, this method returns false. header_set $header->header_set($field => @values); This method updates the value of the given header. Existing headers have their values set in place. Additional headers are added at the end. If no values are given to set, the header will be removed from to the message entirely. crlf This method returns the newline string used in the header. PERL EMAIL PROJECT
This module is maintained by the Perl Email Project <http://emailproject.perl.org/> COPYRIGHT AND LICENSE
Copyright 2006-2007 by Ricardo SIGNES Copyright 2004 by Casey West Copyright 2003 by Simon Cozens This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.14.2 2011-12-23 Email::Simple::Header(3pm)
All times are GMT -4. The time now is 01:16 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy