Sponsored Content
Full Discussion: Row to Columns
Top Forums UNIX for Dummies Questions & Answers Row to Columns Post 302111361 by dennis.jacob on Wednesday 21st of March 2007 01:52:27 AM
Old 03-21-2007
Please give a try on thsi..

awk -F"," '{if (NR==1)
{first=$1; sec=$2; flag=0; }
if(first==$1 && sec==$2)
{ if (flag==1) {print $3"\n"$4"\n"$5"\n"$6}
else
{print first"\n"sec"\n"$3"\n"$4"\n"$5"\n"$6; flag=1;}
}
else
{first=$1; sec=$2; flag=0;
if (flag==1) {print $3"\n"$4"\n"$5"\n"$6;}
else
{print first"\n"sec"\n"$3"\n"$4"\n"$5"\n"$6;flag=1;}
} }' filename

Thnx.Dennis
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to change row into columns

hi, I have a input file like a,123,456,789,012,.......,b I need to change the output file into a,123,b a,456,b a,789,b a,012,b a,...,b like that.. how to achieve that through UNIX................. (5 Replies)
Discussion started by: aaha_naga
5 Replies

2. Shell Programming and Scripting

3 Columns to Row question

I have a file that looks like this... a b c d e f g h i I would like to it to be like this a b c d e f g h i Thanks (8 Replies)
Discussion started by: elbombillo
8 Replies

3. Shell Programming and Scripting

Row to Columns question

Hi, I have a question for Row to Columns by script. e.g. i have a file Start 1 2 3 4 End Start 1 2 3 3 4 4 End (6 Replies)
Discussion started by: bleach8578
6 Replies

4. UNIX for Dummies Questions & Answers

convert matrix to row and columns

Dear Unix Gurus, I have a sample data set that looks like this y1 y2 y3 y4 y5 x1 0.3 0.5 2.3 3.1 5.1 x2 1.2 4.1 3.5 1.7 1.2 x3 3.1 2.1 1.0 4.1 2.1 x4 5.0 4.0 6.0 7.0 1.1 I want to open it up so that I get x1 y1 0.3 x2 y1 1.2 x3 y1 3.1 x4 y1 5.0 x1 y2 0.5 x2 y2... (3 Replies)
Discussion started by: tintin72
3 Replies

5. Shell Programming and Scripting

Print columns from each row

I have awk command to print column 8 awk '/select/ {print $8}' which will print column 8 But I need to print 3, 5 and 8 column in a row and each column should be de-limited by "\t" Hope anyone help me quickly. (2 Replies)
Discussion started by: elamurugu
2 Replies

6. Shell Programming and Scripting

help [[row and columns]]

i ask to do ,,program that convert the last row to be the first row ,,,and after that exchange the the columns ex,, 1 2 3 4 5 6 7 8 9 to be 7 8 9 4 5 6 1 2 3 and then to be 9 8 7 6 5 4 3 2 1 give mee the code .... (0 Replies)
Discussion started by: khaled1989kh
0 Replies

7. UNIX for Dummies Questions & Answers

help [[row and columns]]

i ask to do ,,program that convert the last row to be the first row ,,,and after that exchange the the columns ex,, 1 2 3 4 5 6 7 8 9 to be 7 8 9 4 5 6 1 2 3 and then to be 9 8 7 6 5 4 3 2 1 (0 Replies)
Discussion started by: khaled1989kh
0 Replies

8. UNIX for Dummies Questions & Answers

Dividing all columns by the nth row

Hi All! if I have a file like this: 8 10 12 14 16 18 0 2 6 2 4 6 8 10 12 16 18 10 6 8 12 16 18 0 2 2 6 2 2 2 2 2 2 2 2 2 10 12 16 4 8 16 4 16 0 8 10 14 16 0 4 8 12 14 And I want to divide all the lines by line 4 for example... (6 Replies)
Discussion started by: cosmologist
6 Replies

9. UNIX for Dummies Questions & Answers

Select 2 columns and transpose row by row

Hi, I have a tab-delimited file as follows: 1 1 2 2 3 3 4 4 a a b b c c d d 5 5 6 6 7 7 8 8 e e f f g g h h 9 9 10 10 11 11 12 12 i i j j k k l l 13 13 14 14 15 15 16 16 m m n n o o p p The output I need is: 1 1 a a 5 5 e e 9 9 i i 13... (5 Replies)
Discussion started by: mvaishnav
5 Replies

10. Shell Programming and Scripting

Transpose columns to row

Gents Using the attached file and using this code. awk '{print substr($0,4,2)}' input.txt | sort -k1n | awk '{a++}END{for(i in a) print i,a}' | sort -k1 > output i got the this output. 00 739 01 807 02 840 03 735 04 782 05 850 06 754 07 295 08 388 09 670 10 669 11 762 (8 Replies)
Discussion started by: jiam912
8 Replies
acctcom(1)							   User Commands							acctcom(1)

NAME
acctcom - search and print process accounting files SYNOPSIS
acctcom [-abfhikmqrtv] [-C sec] [-e time] [-E time] [-g group] [-H factor] [-I chars] [-l line] [-n pattern] [-o output-file] [-O sec] [-s time] [-S time] [-u user] [filename]... DESCRIPTION
The acctcom utility reads filenames, the standard input, or /var/adm/pacct, in the form described by acct.h(3HEAD) and writes selected records to standard output. Each record represents the execution of one process. The output shows the COMMAND NAME, USER, TTYNAME, START TIME, END TIME, REAL (SEC), CPU (SEC), MEAN SIZE (K), and optionally, F (the fork()/exec() flag: 1 for fork() without exec()), STAT (the system exit status), HOG FACTOR, KCORE MIN, CPU FACTOR, CHARS TRNSFD, and BLOCKS READ (total blocks read and written). A `#' is prepended to the command name if the command was executed with super-user privileges. If a process is not associated with a known terminal, a `?' is printed in the TTYNAME field. If no filename is specified, and if the standard input is associated with a terminal or /dev/null (as is the case when using `&' in the shell), /var/adm/pacct is read; otherwise, the standard input is read. If any filename arguments are given, they are read in their respective order. Each file is normally read forward, that is, in chronological order by process completion time. The file /var/adm/pacct is usually the current file to be examined; a busy system may need several such files of which all but the current file are found in /var/adm/pacctincr. OPTIONS
The following options are supported: -a Show some average statistics about the processes selected. The statistics will be printed after the output records. -b Read backwards, showing latest commands first. This option has no effect when standard input is read. -f Print the fork()/exec() flag and system exit status columns in the output. The numeric output for this option will be in octal. -h Instead of mean memory size, show the fraction of total available CPU time consumed by the process during its execution. This "hog factor" is computed as (total CPU time)/(elapsed time). -i Print columns containing the I/O counts in the output. -k Instead of memory size, show total kcore-minutes. -m Show mean core size (the default). -q Do not print any output records, just print the average statistics as with the -a option. -r Show CPU factor (user-time/(system-time + user-time)). -t Show separate system and user CPU times. -v Exclude column headings from the output. -C sec Show only processes with total CPU time (system-time + user-time) exceeding sec seconds. -e time Select processes existing at or before time. -E time Select processes ending at or before time. Using the same time for both -S and -E shows the processes that existed at time. -g group Show only processes belonging to group. The group may be designated by either the group ID or group name. -H factor Show only processes that exceed factor, where factor is the "hog factor" as explained in option -h above. -I chars Show only processes transferring more characters than the cutoff number given by chars. -l line Show only processes belonging to terminal /dev/term/line. -n pattern Show only commands matching pattern that may be a regular expression as in regcmp(3C), except + means one or more occur- rences. -o output-file Copy selected process records in the input data format to output-file; suppress printing to standard output. -O sec Show only processes with CPU system time exceeding sec seconds. -s time Select processes existing at or after time, given in the format hr[:min[:sec]]. -S time Select processes starting at or after time. -u user Show only processes belonging to user. The user may be specified by a user ID, a login name that is then converted to a user ID, `#' (which designates only those processes executed with superuser privileges), or `?' (which designates only those processes associated with unknown user IDs). FILES
/etc/group system group file /etc/passwd system password file /var/adm/pacctincr active processes accounting file ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWaccu | +-----------------------------+-----------------------------+ |CSI |Enabled | +-----------------------------+-----------------------------+ SEE ALSO
ps(1), acct(1M), acctcms(1M), acctcon(1M), acctmerg(1M), acctprc(1M), acctsh(1M), fwtmp(1M), runacct(1M), su(1M), acct(2), regcmp(3C), acct.h(3HEAD), utmp(4), attributes(5) System Administration Guide: Basic Administration NOTES
acctcom reports only on processes that have terminated; use ps(1) for active processes. SunOS 5.11 11 Jan 1996 acctcom(1)
All times are GMT -4. The time now is 05:51 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy