awk to print exact field number Post: 302380055

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

use awk to aggregrate the field number

Hi, I have a various files;each filled with hundreds of line with similar number of fields. I would like to extract out field $5 from each of this file and aggregate them before printing out to a file. I tried to :- #!/usr/bin/awk -f file="file1.txt file2.txt file3.txt file4.txt" ...

2. Shell Programming and Scripting

Print matching field using awk

Hi All, I have a string like below: str="Hold=True Map=False 'This will map the data' Run=Yes Modify=False" I want to print the field Run=Yes and retrive the value "Yes". I cannot use simple awk command because the position of the "Run" will be different at different times. Is there a way...

3. UNIX for Dummies Questions & Answers

[awk] print from field n to field x

Hi, I'm trying to print every line from first field to the fourth from a file containing more. $ cat input a b c d e f g a b c d e f gI'm trying awk '{for (i=1; i <= NF-3; i++) print $i}' awkTest.datbut it printsa b c d a b c dSo, I easily guess I'm wrong. :) Of course, I want:a b...

4. UNIX for Advanced & Expert Users

Awk command to print the field

894344202808090;11122;040320 075858 166;101;0;0;10u;0;NA;65;221890;2;101973;185059;568674;Y; PRE;0;0;NA;NA;0;NA;0;NA;textmsg;textmsg_snd1;telusmob;TEXTMSG1;0.15000000;126037;2010/03/04 12:58:57gmt;0;70532192; plz tell me any awk command which on the basis of the yellow field which is...

5. Shell Programming and Scripting

awk - print all fields except for last field

How do I print all the fields of a record except for the $(NF) field?

6. Shell Programming and Scripting

AWK print number of records, divide this number

I would like to print the number of records of 2 files, and divide the two numbers awk '{print NR}' file1 > output1 awk '{print NR}' file2 > output2 paste output1 output2 > output awl '{print $1/$2}' output > output_2 is there a faster way?

7. UNIX for Dummies Questions & Answers

Print first field in awk

Hi, I have below text file 01.02.2014,asdas,arse,aere,4tfsd 12.03.2014,sdte,45gf,8iuj,qw343w 01.02.0214,aetre,sdfgter,asfrwe I have writen below code to print only first field that is only date field from text file #!/bin/ksh echo "enter week" read week while read -r...

8. UNIX for Dummies Questions & Answers

Print first field using awk

I want to print line by line only the first field from txt file input file etr,t7tu,e45xdt,e45exgt,cdgfe aqw34aw,45edgf,45estd,sert34 a232e,4etedf,w345er,qw345rw, qw354,q34asf,tw45f,q3drsf required o/p file etr aqw34aw a232e qw354

9. Shell Programming and Scripting

awk to find number in a field then print the line and the number

Hi I want to use awk to match where field 3 contains a number within string - then print the line and just the number as a new field. The source file is pipe delimited and looks something like 1|net|ABC Letr1|1530||| 1|net|EXP_1040 ABC|1121||| 1|net|EXP_TG1224|1122||| 1|net|R_North|1123|||...

10. Shell Programming and Scripting

awk sum of all columns needs to print exact amount

Hi I have attached txt file as input, and i'm able to calculate sum of columns at the end but the format of sum is not coming up right. awk -F"," '{for (i=4;i<=NF;i++) sum+=$i}{print}; END { sum="Total:"; for (i=1;i<=NF;i++) {printf sum ","} print "\n"}' input.txt check the o/p file, at...

LEARN ABOUT HPUX

read

read(1) 						      General Commands Manual							   read(1)

NAME

       read - read a line from standard input

SYNOPSIS

       var ...

DESCRIPTION

       reads  a single line from standard input.  The line is split into fields as when processed by the shell (refer to shells in the first field
       is assigned to the first variable var, the second field to the second variable var, and so forth.  If there are more fields than there  are
       specified  var  operands,  the remaining fields and their intervening separators are assigned to the last var.  If there are more vars than
       fields, the remaining vars are set to empty strings.

       The setting of variables specified by the var operands affect the current shell execution environment.

       Standard input to can be redirected from a text file.

       Since affects the current shell execution environment, it is usually provided as a normal shell special (built-in) command.  Thus, if it is
       called  in  a  subshell	or  separate utility execution environment similar to the following, it does not affect the shell variables in the
       caller's environment:

   Options
       recognizes the following options:

	      Do not treat a backslash character in any special way.
		     Consider each backslash to be part of the input line.

   Opperands
       recognizes the following operands:

	      var    The name of an existing or nonexisting shell variable.

EXTERNAL INFLUENCES

   Environment Variables
       determines the internal field separators used to delimit fields.

RETURN VALUE

       exits with one of the following values:

	       0     Successful completion.

	      >0     End-of-file was detected or an error occurred.

EXAMPLES

       Print a file with the first field of each line moved to the end of the line.

	      while read -r xx yy
	      do
		      printf "%s %s 
" "$yy" "$xx"
	      done < input_file

SEE ALSO

       csh(1), ksh(1), sh(1), sh-posix(1).

STANDARDS CONFORMANCE

																	   read(1)