Sponsored Content
Full Discussion: Conditional Column Value
Top Forums Shell Programming and Scripting Conditional Column Value Post 303025525 by RudiC on Monday 5th of November 2018 07:14:21 AM
Old 11-05-2018
Code:
awk '
NR == 1                                                                 # On first line
||                                                                      # OR
/\/(data|binlogs|backup)/                                               # lines with respective mount points
{printf("%-30s\t %s\t %s\t %s\t %s\t %s\t \n", $6, $2, $3, $4, $5,      # print fields 2 - 6, AND, for field 7:
NR==1                                                                   # conditional assignment operator: 1. line
?"Status"                                                               # TRUE branch: print header field
:                                                                       # FALSE branch: another ...
($5+0 > 80)                                                             # cond.assg.op.: if percent > 80%
?"Space required"                                                       # TRUE branch
:"OK"                                                                   # FALSE branch
)}'

Please post the solution you found for others to learn, and for optional discussion.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

If conditional

Hi, I am new to unix and shell scripting.In my script,there is a line using the "if" conditional - if && ; then do something Here "x" is a variable holding string value.If it is not equal to a comma or a string,only then I want to enter the "if" loop. But I am getting error while... (1 Reply)
Discussion started by: abhinavsinha
1 Replies

2. Shell Programming and Scripting

If conditional

Hi, I am new to unix and shell scripting.In my script,there is a line using the "if" conditional - if && ; then do something Here "x" is a variable holding string value.If it is not equal to a comma or a string,only then I want to enter the "if" loop. But I am getting error while... (12 Replies)
Discussion started by: abhinavsinha
12 Replies

3. Shell Programming and Scripting

Changing one column of delimited file column to fixed width column

Hi, Iam new to unix. I have one input file . Input file : ID1~Name1~Place1 ID2~Name2~Place2 ID3~Name3~Place3 I need output such that only first column should change to fixed width column of 15 characters of length. Output File: ID1<<12 spaces>>Name1~Place1 ID2<<12... (5 Replies)
Discussion started by: manneni prakash
5 Replies

4. Shell Programming and Scripting

Conditional aggregation and print of a column in file

Hi My input file looks like field1 field2 field3 field4 field5 field1 field2 field3 field4 field5 field1 field2 field3 field4 field5 :::::::::::: :::::::::::: There may be one space of multiple spaces between fields and no fields contains spaces in them. If field 1 to 4 are equal for... (3 Replies)
Discussion started by: bittoo
3 Replies

5. Shell Programming and Scripting

Replace a column with a value conditional on a value in col1

Hi, Perhaps a rather simple problem...? I have data that looks like this. BPC0013 ANNUL_49610 0 0 1 1 BPC0014 ANNUL_49642 0 0 2 1 BPC0015 ANNUL_49580 0 0 1 1 BPC0016 ANNUL_49596 0 0 2 1 BPC0017 VULGO_49612 0 0 1 1 BPC0018 ANNUL_49628 0 0 1 1 BPC0019 ANNUL_49692 0 0 2 1 170291_HMG... (4 Replies)
Discussion started by: genehunter
4 Replies

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

7. Shell Programming and Scripting

awk , conditional involving line and column

Dear All, I indeed your help for managing resarch data file. for example I have, data1.txt : type of atoms z vz Si 34 54 O 20 56 H 14 13 Si 40 17 O ... (11 Replies)
Discussion started by: ariesto
11 Replies

8. Shell Programming and Scripting

Difference of the same column when two other column matches and one column differs less than 1 hour

This is my input file : # cat list 20130430121600, cucm, location,76,2 20130430121600,cucm1,location1,76,4 20130430122000,cucm,location,80,8 20130430122000,cucm1,location1,90,8 20130430140000,cucm1,location1,87,11 20130430140000, cucm,location,67,9 This is the required output ... (1 Reply)
Discussion started by: Lakshmikumari
1 Replies

9. Shell Programming and Scripting

Filter on one column and then perform conditional calculations on another column with a Linux script

Hi, I have a file (stats.txt) with columns like in the example below. Destination IP address, timestamp, TCP packet sequence number and packet length. destIP time seqNo packetLength 1.2.3.4 0.01 123 500 1.2.3.5 0.03 44 1500 1.3.2.5 0.08 44 1500 1.2.3.4 0.44... (12 Replies)
Discussion started by: Zooma
12 Replies

10. UNIX for Beginners Questions & Answers

UNIX - 2 tab delimited files, conditional column extraction

Please know that I am very new to unix and trying to learn 'on the job'. I'm only manipulating large tab-delimited files (millions of rows), but I'm stuck and don't know how to proceed with the following. Hoping for some friendly advice :) I have 2 tab-delimited files - with differing column &... (10 Replies)
Discussion started by: GTed
10 Replies
branch(1rheolef)                                                    rheolef-6.1                                                   branch(1rheolef)

NAME
branch -- handle a family of fields SYNOPSIS
branch [options] filename EXAMPLE
Generates vtk file colection for visualization with paraview: branch output.branch -paraview DESCRIPTION
Read and output a branch of finite element fields from file, in field text file format. INPUT FILE SPECIFICATION
-Idir add dir to the RHEOPATH search path. See also geo(2) for RHEOPATH mechanism. filename specifies the name of the file containing the input field. - read field on standard input instead on a file. -ndigit int Number of digits used to print floating point values when using the `-geo' option. Default depends upon the machine precision asso- ciated to the Float type. OUTPUT AND RENDER SPECIFICATION
-extract int Extract the i-th record in the file. The output is a field or multi-field file format. -branch Output on stdout in `.branch' format. This is the default. -paraview Generate a collection of vtk files for using paraview. -vtk Generate a single vtk file with numbered fields. -gnuplot Run 1d animation using gnuplot. -plotmtv This driver is unsupported for animations. OTHER OPTIONS
-umin float -umax float set the solution range for the gnuplot driver. By default this range is computed from the first field of the branch, and this could be problematic when this field is initialy zero. -topography filename[.field[.gz]] performs a tridimensionnal elevation view based on the topographic data. -proj performs a P1 projection on the fly. This option is useful when rendering P0 data while vtk render requieres P1 description. -elevation For two dimensional field, represent values as elevation in the third dimension. This is the default. -noelevation Prevent from the elevation representation. -scale float applies a multiplicative factor to the field. This is useful e.g. in conjonction with the elevation option. The default value is 1. -verbose print messages related to graphic files created and command system calls (this is the default). -noverbose does not print previous messages. -clean clear temporary graphic files (this is the default). -noclean does not clear temporary graphic files. -execute execute graphic command (this is the default). -noexecute does not execute graphic command. Generates only graphic files. This is usefull in conjuction with the -noclean command. BRANCH FILE FORMAT
The `.branch' file format bases on the `.field' one: EXAMPLE GENERAL FORM #!branch #!branch branch branch 1 1 11 <version> <nfield=1> <nvalue=N> time u <key> <field name> #time 3.14 #<key> <key value 1> #u #<field name> field <field 1> ..... .... ..... .... #time 6.28 #<key> <key value N> #u #<field name> field <field N> ..... .... The key name is here time, but could be any string (without spaces). The previous example contains one field at each time step. Labels appears all along the file to facilitate direct jumps and field and step skips. The format supports several fields, such as (t,u(t),p(t)), where u could be a multi-component (e.g. a vector) field: #!branch branch 1 2 11 time u p #time 3.14 #u mfield 1 2 #u0 field ... #u1 field ... #p #time 6.28 ... SEE ALSO
geo(2) rheolef-6.1 rheolef-6.1 branch(1rheolef)
All times are GMT -4. The time now is 05:03 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy