AWK multiple line fields sorting

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Print multiple fields with awk

so its common knowledge one can print multiple fields with simple commands like this: echo 12 44 45 552 24 | awk '{print $1,$4,$3}' but suppose i want to avoid specifying the "$" symbol. is that possible? can something like this be done: echo 12 44 45 552 24 | awk '{print $(1,4,3)}' ...

2. Shell Programming and Scripting

Replace 0 with 1 in multiple fields with awk

Hello, I have the following input file: 1 3 3 2 3 3 4 0 4 0 5 4 5 2 2 0 5 3 4 0 6 0 3 2 I am trying to remove all zeroes in fields 2 and 4 and replace them with "1's" I tried the following, but it's not working awk -F"\t" '{ if (($2==0) || ($4==0) $2=1; $4=1; print $0 ) }' input ...

3. Shell Programming and Scripting

awk multiple fields separators

Can you please help me with this .... Input File share "FTPTransfer" "/v31_fs01/root/FTP-Transfer" umask=022 maxusr=4294967295 netbios=NJ09FIL530 share "Test" "/v31_fs01/root/Test" umask=022 maxusr=4294967295 netbios=NJ09FIL530 share "ENR California" "/v31_fs01/root/ENR California"...

4. Shell Programming and Scripting

awk gsub multiple fields

Hi, I am trying to execute this line awk -F ";" -v OFS=";" '{gsub(/\./,",",$6); print}' FILE but for multiple fields $6 $7 $8 Do you have a suggstion? Tried: awk -F ";" -v OFS="";"" "function GSUB( F ) {gsub(/\./,\",\",$F); print} { GSUB( 6 ); GSUB( 7 ); GSUB( 8 ) } 1"...

5. Shell Programming and Scripting

awk (or other) script that assigns fields from a line to multiple variables

Hey all, Unfortunately I have only basic knowledge of awk and/or scripting. If I have a file with lines that can look similar to this: Name=line1 Arg1=valueA Arg2=valueB Arg3=valueC Name=line2 Arg1=valueD Name=line3 Arg1=valueE Arg3=valueF Name=line4 Arg2=valueG ...

6. UNIX for Dummies Questions & Answers

Formatting Multiple fields on 1 line to multiple rows

I'm trying extract a number of filename fields from a log file and copy them out as separate rows in a text file so i can load them into a table. I'm able to get the filenames but the all appear on one line. I tried using the cut command with the -d (delimiter) option but cant seem to make it...

7. Shell Programming and Scripting

AWK multiple fields separators

I need to print the second field of a file, taking spaces, tab and = as field separators. ; for 16-bit app support MAPI=1 CMC=1 CMCDLLNAME32=mapi32.dll CMCDLLNAME=mapi.dll MAPIX=1 MAPIXVER=1.0.0.1 OLEMessaging=1 asf=MPEGVideo asx=MPEGVideo ivf=MPEGVideo m3u=MPEGVideo

8. Shell Programming and Scripting

sorting(both Ascending & Descending) files based on multiple fields

Hi All, I am encountered with a problem while sorting a file based on multiple columns . I need to sort like: (field2,ascending) , (field3,ascending) ,(field8,descending) , (field7,ascending),(field13,ascending). So far i was sorting only in ascending order but here i need to use one...

9. Shell Programming and Scripting

Compare multiple fields in file1 to file2 and print line and next line

Hello, I have two files that I need to compare and print out the line from file2 that has the first 6 fields matching the first 6 fields in file1. Complicating this are the following restrictions 1. file1 is only a few thousand lines at most and file2 is greater than 2 million 2. I need to...

10. UNIX for Dummies Questions & Answers

sorting fields of a line

Hi all, I have a file that looks like this... ########## 1zz2_15-43 1ouy_0-13-35 1.12619901947 2gfs_41-7 1yqj_3 0.793602121208 1bl7_11-3 1wbo_1-3-4 0.791065168287 1ywr_16-3 2ghl_22 0.956896171134 2exc_11-35 1pmq_13-15-87 0.597677672501 2bal_25-7 1ouk_17-19-21-228-58 0.668388304836...

LEARN ABOUT NETBSD

utmp

UTMP(5) 						      BSD File Formats Manual							   UTMP(5)

NAME

     utmp, wtmp, lastlog -- login records

SYNOPSIS

     #include <utmp.h>

DESCRIPTION

     The file <utmp.h> declares the structures used to record information about current users in the file utmp, logins and logouts in the file
     wtmp, and last logins in the file lastlog.  The time stamps of date changes, shutdowns and reboots are also logged in the wtmp file.

     The wtmp file can grow rapidly on busy systems, and is normally rotated with newsyslog(8).

     These files must be created manually; if they do not exist, they are not created automatically.

	   #define _PATH_UTMP	   "/var/run/utmp"
	   #define _PATH_WTMP	   "/var/log/wtmp"
	   #define _PATH_LASTLOG   "/var/log/lastlog"

	   #define UT_NAMESIZE	   8
	   #define UT_LINESIZE	   8
	   #define UT_HOSTSIZE	   16

	   struct lastlog {
		   time_t  ll_time;
		   char    ll_line[UT_LINESIZE];
		   char    ll_host[UT_HOSTSIZE];
	   };

	   struct utmp {
		   char    ut_line[UT_LINESIZE];
		   char    ut_name[UT_NAMESIZE];
		   char    ut_host[UT_HOSTSIZE];
		   time_t  ut_time;
	   };

     Each time a user logs in, the login(1) program looks up the user's UID in the file lastlog.  If it is found, the timestamp of the last time
     the user logged in, the terminal line and the hostname are written to the standard output, providing the login is not set quiet; see
     login(1).	The login(1) program then records the new login time in the file lastlog.

     After the new lastlog record is written, the file utmp is opened and the utmp record for the user inserted.  This record remains there until
     the user logs out at which time it is deleted (by clearing the user and host fields, and updating the timestamp field).  The utmp file is
     used by the programs rwho(1), users(1), w(1), and who(1).

     Next, the login(1) program opens the file wtmp, and appends the user's utmp record.  When the user logs out, a utmp record with the tty line,
     an updated time stamp, and cleared user and host fields is appended to the file by init(8).  The wtmp file is used by the programs last(1)
     and ac(8).

     In the event of a date change, a shutdown or reboot, the following items are logged in the wtmp file.

     reboot
     shutdown	 A system reboot or shutdown has been initiated.  The character '~' is placed in the field ut_line, and reboot or shutdown in the
		 field ut_name (see shutdown(8) and reboot(8)).

     date	 The system time has been manually or automatically updated by date(1).  The command name date is recorded in the field ut_name.
		 In the field ut_line, the character '|' indicates the time prior to the change, and the character '{' indicates the new time.

FILES

     /var/run/utmp     The utmp file.
     /var/log/wtmp     The wtmp file.
     /var/log/lastlog  The lastlog file.

SEE ALSO

     last(1), login(1), w(1), who(1), utmpx(5), ac(8), init(8), lastlogin(8), newsyslog(8)

HISTORY

     A utmp and wtmp file format appeared in Version 6 AT&T UNIX.  The lastlog file format appeared in 3.0BSD.

BSD
								   May 14, 2003 							       BSD

Shell Programming and Scripting