awk for a line that contains someting in a field Post: 302505366

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

AWK line by line instead of field by field?

I've been using a lot of awk lately for csv files. But I've been using awk for csv files that contain 32 fields per line. For the first time, I've been given a csv file that contains one field per line (13 fields in each csv file). I need to check that a specific field, or line contains a...

2. Shell Programming and Scripting

awk - if field is empty, move line to new file

I have a script with this statement: /usr/xpg4/bin/awk -F"" 'NR==FNR{s=$2;next}{printf "%s\"%s\"\n", $0, s}' LOOKUP.TXT finallistnew.txt >test.txt I want to include logic or an additional step that says if there is no data in field 3, move the whole line out of test.txt into an additional...

3. Shell Programming and Scripting

awk append to one line if first field is the same

Hi all, How would I append the second field each time to one line if the first field is the same for example I have this data: 10430,187976 10430,251588 10430,262904 10430,275008 10430,279892 10430,275008 10430,303740 10430,318136 10430,336988 10430,350324 10430,373648 And I...

4. Shell Programming and Scripting

Replace line and field using SED and/or AWK or some other suggestion

QUESTION 1: How do you replace a specific line (i.e. line 4) with a new user defined line (i.e. the contents of SAMS’s name, history, math and English grades have been set already). I have been attempting to use SED (FYI: I don’t have GNU SED) or AWK, but haven’t had any luck. FYI: I am using...

5. UNIX for Dummies Questions & Answers

Values with common field in same line with awk

Hi all ! I almost did it but got a small problem. input: cars red cars blue cars green truck black Wanted: cars red-blue-green truck black Attempt: gawk 'BEGIN{FS="\t"}{a = a (a?"-":"")$2; $2=a; print $1 FS $2}' input But I also got the intermediate records...

6. UNIX for Dummies Questions & Answers

Help with awk, where line length and field position are variable

I have several questions about using awk. I'm hoping someone could lend me a hand. (I'm also hoping that my questions make sense.) I have a file that contains pipe separated data. Each line has similar data but the number of fields and the field position on each line is variable. ...

7. Shell Programming and Scripting

Pass awk field to a command line executed within awk

Hi, I am trying to pass awk field to a command line executed within awk (need to convert a timestamp into formatted date). All my attempts failed this far. Here's an example. It works fine with timestamp hard-codded into the command echo "1381653229 something" |awk 'BEGIN{cmd="date -d...

8. UNIX for Dummies Questions & Answers

Using awk to remove duplicate line if field is empty

Hi all, I've got a file that has 12 fields. I've merged 2 files and there will be some duplicates in the following: FILE: 1. ABC, 12345, TEST1, BILLING, GV, 20/10/2012, C, 8, 100, AA, TT, 100 2. ABC, 12345, TEST1, BILLING, GV, 20/10/2012, C, 8, 100, AA, TT, (EMPTY) 3. CDC, 54321, TEST3,...

9. Shell Programming and Scripting

awk to remove line if field has symbols in it

Trying to use awk to remove a line only if $1 contains either ; or :. Thje awk below runs but no lines are removed. Thank you :). awk awk '$1 !~ /;/ || $1 !~ /:/ { print }' file file AARS2;TMEM151B 1 AASS 2 ABAT 3 ABCA1 3 ABCA10 1 ABCA12 2 ABCA13 1 ABCA13:AX746840 2 ABCA2 5

10. 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,...

LEARN ABOUT NETBSD

form_field_just

FORMS(3)						   BSD Library Functions Manual 						  FORMS(3)

NAME

     field_just, set_field_just -- form library

LIBRARY

     Curses Form Library (libform, -lform)

SYNOPSIS

     #include <form.h>

     int
     field_just(FIELD *field);

     int
     set_field_just(FIELD *field, int justification);

DESCRIPTION

     Field justification is only applied to static fields, a dynamic field will not be justified.  The default justification for a field is
     NO_JUSTIFICATION.	The field_just() will return the current justification value of the given field and the justification may be set by call-
     ing the set_field_just() function.

PARAMETERS

     The following are the valid justifications for a field:

     NO_JUSTIFICATION  No justification is to be applied to the field.	In practice, this is the same as JUSTIFY_LEFT.
     JUSTIFY_RIGHT     The field will be right justified.  That is, the end of each line will be butted up against the right hand side of the
		       field.
     JUSTIFY_LEFT      The field will be left justified.  That is, the start of each line will be butted up against the left hand side of the
		       field.
     JUSTIFY_CENTER    The field will be centre justified, padding will be applied to either end of the line to make the line centred in the
		       field.

RETURN VALUES

     The functions will return one of the following error values:

     E_OK		The function was successful.
     E_CURRENT		The field specified is the currently active one on the form.
     E_BAD_ARGUMENT	A bad argument was passed to the function.

SEE ALSO

     curses(3), forms(3)

NOTES

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

BSD
								  January 1, 2001							       BSD

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

AWK line by line instead of field by field?

Discussion started by: yongho

2. Shell Programming and Scripting

awk - if field is empty, move line to new file

Discussion started by: scriptr2be

3. Shell Programming and Scripting

awk append to one line if first field is the same

Discussion started by: borderblaster

4. Shell Programming and Scripting

Replace line and field using SED and/or AWK or some other suggestion

Discussion started by: thibodc