awk - printing nth field based on parameter Post: 302822653

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk substitute variable value in nth field

I have a large csv file that looks like this: The 3rd field is a unix time stamp that I want to convert to human readable. I wrote a bash script with this code: IFS=$',' cat $1 | while read ID user DATE text flags read; do echo -e "$ID,$user,$(date -d @$DATE),$text,$flags,$read...

2. Shell Programming and Scripting

how to find the nth field value in delimiter file in unix using awk

Hi All, I wanted to find 200th field value in delimiter file using awk.? awk '{print $200}' inputfile I am getting error message :- awk: The field 200 must be in the range 0 to 199. The source line number is 1. The error context is {print >>> $200 <<< } using...

3. Shell Programming and Scripting

How to Print from nth field to mth fields using awk

Hi, Is there any short method to print from a particular field till another filed using awk? Example File: File1 ==== 1|2|acv|vbc|......|100|342 2|3|afg|nhj|.......|100|346 Expected output: File2 ==== acv|vbc|.....|100 afg|nhj|.....|100

4. Shell Programming and Scripting

Awk product of nth field

How do I do the product of nth filed just like sum. For sum I know like awk '{ sum += $12 } END {printf "%.2f\n", sum}' works as initial sum = 0. But for product how do initialize the variable to 1?

5. Shell Programming and Scripting

Replace a value of Nth field of nth row

Using Awk, how can I achieve the following? I have set of record numbers, for which, I have to replace the nth field with some values, say spaces. Eg: Set of Records : 4,9,10,55,89,etc I have to change the 8th field of all the above set of records to spaces (10 spaces). Its a delimited...

6. Shell Programming and Scripting

awk to update value in field based on another field

In the tab-delimeted input file below I am trying to use awk to update the value in $2 if TYPE=ins in bold, by adding the value of HRUN= in italics. In the below since in line 1 TYPE=ins the 117282541 value in $2 has 6 added because that is the value of HRUN=. Hopefully the awk is a start but I...

7. Shell Programming and Scripting

awk to adjust coordinates in field based on sequential numbers in another field

I am trying to output a tab-delimited result that uses the data from a tab-delimited file to combine and subtract specific lines. If $4 matches in each line then the first matching sequential $6 value is added to $2, unless the value is 1, then the original $2 is used (like in the case of line...

8. UNIX for Beginners Questions & Answers

Print lines based upon unique values in Nth field

For some reason I am having difficulty performing what should be a fairly easy task. I would like to print lines of a file that have a unique value in the first field. For example, I have a large data-set with the following excerpt: PS003,001 MZMWR/ L-DWD// * PS003,001...

9. Shell Programming and Scripting

Printing string from last field of the nth line of file to start (or end) of each line (awk I think)

My file (the output of an experiment) starts off looking like this, _____________________________________________________________ Subjects incorporated to date: 001 Data file started on machine PKSHS260-05CP ********************************************************************** Subject 1,...

10. UNIX for Beginners Questions & Answers

Problem with getting awk to multiply a field by a value set based on condition of another field

Hi, So awk is driving me crazy on this one. I have searched everywhere and read man, docs and every related post Google can find and still no luck. The actual files I need to run this on are sensitive in nature, but it is the same thing as if I needed to calculate weighted grades for multiple...

LEARN ABOUT MOJAVE

io::seekable

IO::Seekable(3pm)					 Perl Programmers Reference Guide					 IO::Seekable(3pm)

NAME

       IO::Seekable - supply seek based methods for I/O objects

SYNOPSIS

	   use IO::Seekable;
	   package IO::Something;
	   @ISA = qw(IO::Seekable);

DESCRIPTION

       "IO::Seekable" does not have a constructor of its own as it is intended to be inherited by other "IO::Handle" based objects. It provides
       methods which allow seeking of the file descriptors.

       $io->getpos
	   Returns an opaque value that represents the current position of the IO::File, or "undef" if this is not possible (eg an unseekable
	   stream such as a terminal, pipe or socket). If the fgetpos() function is available in your C library it is used to implements getpos,
	   else perl emulates getpos using C's ftell() function.

       $io->setpos
	   Uses the value of a previous getpos call to return to a previously visited position. Returns "0 but true" on success, "undef" on
	   failure.

       See perlfunc for complete descriptions of each of the following supported "IO::Seekable" methods, which are just front ends for the
       corresponding built-in functions:

       $io->seek ( POS, WHENCE )
	   Seek the IO::File to position POS, relative to WHENCE:

	   WHENCE=0 (SEEK_SET)
		   POS is absolute position. (Seek relative to the start of the file)

	   WHENCE=1 (SEEK_CUR)
		   POS is an offset from the current position. (Seek relative to current)

	   WHENCE=2 (SEEK_END)
		   POS is an offset from the end of the file. (Seek relative to end)

	   The SEEK_* constants can be imported from the "Fcntl" module if you don't wish to use the numbers 0 1 or 2 in your code.

	   Returns 1 upon success, 0 otherwise.

       $io->sysseek( POS, WHENCE )
	   Similar to $io->seek, but sets the IO::File's position using the system call lseek(2) directly, so will confuse most perl IO operators
	   except sysread and syswrite (see perlfunc for full details)

	   Returns the new position, or "undef" on failure.  A position of zero is returned as the string "0 but true"

       $io->tell
	   Returns the IO::File's current position, or -1 on error.

SEE ALSO

       perlfunc, "I/O Operators" in perlop, IO::Handle IO::File

HISTORY

       Derived from FileHandle.pm by Graham Barr <gbarr@pobox.com>

perl v5.18.2							    2013-11-04							 IO::Seekable(3pm)