awk - printing nth field based on parameter Post: 302822657

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 OPENSOLARIS

field_opts_off

form_field_opts(3CURSES)				     Curses Library Functions					  form_field_opts(3CURSES)

NAME

       form_field_opts, set_field_opts, field_opts_on, field_opts_off, field_opts - forms field option routines

SYNOPSIS

       cc [ flag... ] file... -lform  -lcurses	[ library... ]
       #include <form.h>

       int set_field_opts(FIELD *field, OPTIONS opts);

       int set_field_opts(FIELD *field, OPTIONS opts);

       int field_opts_on(FIELD *field, OPTIONS opts);

       int field_opts_off(FIELD *field, OPTIONS opts);

       OPTIONS field_opts(FIELD *field);

DESCRIPTION

       set_field_opts()  turns	on  the  named	options of field and turns off all remaining options. Options are boolean values that can be OR-ed
       together.

       field_opts_on() turns on the named options; no other options are changed.

       field_opts_off() turns off the named options; no other options are changed.

       field_opts() returns the options set for field.

       O_VISIBLE     The field is displayed.

       O_ACTIVE 	  The field is visited during processing.

       O_PUBLIC      The field contents are displayed as data is entered.

       O_EDIT		  The field can be edited.

       O_WRAP	     Words not fitting on a line are wrapped to the next line.

       O_BLANK	     The whole field is cleared if a character is entered   in the first position.

       O_AUTOSKIP    Skip to the next field when the current field becomes  full.

       O_NULLOK      A blank field is considered valid.

       O_STATIC      The field buffers are fixed in size.

       O_PASSOK      Validate field only if modified by user.

RETURN VALUES

       set_field_opts, field_opts_on and field_opts_off return one of the following:

       E_OK		 The function returned successfully.

       E_SYSTEM_ERROR	 System error.

       E_CURRENT	 The field is the current field.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |MT-Level		     |Unsafe			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       curses(3CURSES), forms(3CURSES), attributes(5)

NOTES

       The header <form.h> automatically includes the headers  <eti.h> and <curses.h>.

SunOS 5.11							    31 Dec 1996 					  form_field_opts(3CURSES)