Sponsored Content
Full Discussion: awk script row to column
Top Forums Shell Programming and Scripting awk script row to column Post 303016122 by RudiC on Friday 20th of April 2018 02:49:46 AM
Old 04-20-2018
WHAT don't you get? Please be way more eloquent, showing non-satisfying output and error messages. rdrtx1's proposal works for me.
This User Gave Thanks to RudiC For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Get value of last row and 6 column from awk

I want to get value of last row and 6 column from awk. Below is the format of my file. And RED one is my desired value. Actaully this stats usally update after every 1 hour so i want that every time i run the script i get the latest value. Ending time - 01:00:58 HOURLY CALL ATTEMPTS... (4 Replies)
Discussion started by: wakhan
4 Replies

2. UNIX for Dummies Questions & Answers

awk question row into column

I have a csv file: test1.csv with 26 columns Sample: Data collected Comp1,,,,,,,,,,,,,,,,,,,,,,,,,Average Number of Arrivals with non Zero,0,0,0,0,0,0,0,0,0,...,0 %Utilization,0.1,0.23,0.14,...,0.36 Data collected Comp2,,,,,,,,,,,,,,,,,,,,,,,,,Average Number of Arrivals with non... (2 Replies)
Discussion started by: calitiggr
2 Replies

3. Shell Programming and Scripting

AWK Script - Print a column - within a Row Range

Hi, Please read the whole thread. I have been working on this script below. It works fine, feel free to copy and test with the INPUT File below as well. example: PACKET DATA PROTOCOL CONTEXT DATA APNID PDPADD EQOSID VPAA PDPCH PDPTY PDPID 10 ... (6 Replies)
Discussion started by: panapty
6 Replies

4. Shell Programming and Scripting

Subtracting each row from the first row in a single column file using awk

Hi Friends, I have a single column data like below. 1 2 3 4 5 I need the output like below. 0 1 2 3 4 where each row (including first row) subtracting from first row and the result should print below like the way shown in output file. Thanks Sid (11 Replies)
Discussion started by: ks_reddy
11 Replies

5. Shell Programming and Scripting

awk transpose row into 2 field column

Need to transpose every 2 fields of a row into a single 2 field column. input 4 135 114 76 217 30 346 110 5 185 115 45 218 85 347 125 6 85 116 130 220 65 352 95 11 30 117 55 221 42 355 75 16 72 118 55 224 37 357 430 17 30 119 55 225 40 358 62 21 52 120 65 232 480 360 180 ....... (8 Replies)
Discussion started by: sdf
8 Replies

6. UNIX for Dummies Questions & Answers

append column and row header to a file in awk script.

Hi! Is there a way to append column and row header to a file in awk script. For example if I have Jane F 39 manager Carlos M 40 system administrator Sam F 20 programmer and I want it to be # name gend age occup 1 Jane F 39 manager 2 Carlos M ... (4 Replies)
Discussion started by: FUTURE_EINSTEIN
4 Replies

7. Shell Programming and Scripting

awk - script help: column to row format of data allignment?

Experts Good day, I have the following data, file1 BRAAGRP1 A2X B2X C2X D2X BRBGRP12 A3X B3X Z10 D09 BRC1GRP2 LO01 (4 Replies)
Discussion started by: rveri
4 Replies

8. UNIX for Dummies Questions & Answers

awk to print first row with forth column and last row with fifth column in each file

file with this content awk 'NR==1 {print $4} && NR==2 {print $5}' file The error is shown with syntax error; what can be done (4 Replies)
Discussion started by: cdfd123
4 Replies

9. Shell Programming and Scripting

Transpose column to row - awk

Hi there, I have a small csv file example below: source,cu_001,cu_001_volume,cu_001_mass,cu_002,cu_002_volume,cu_002_mass,cu_003,cu_003_volume,cu_003_mass ja116,1.33,3024000,9374400,1.54,3026200,9375123,1.98,3028000,9385512 I want to transpose columns to rows starting at the second... (3 Replies)
Discussion started by: theflamingmoe
3 Replies

10. UNIX for Beginners Questions & Answers

Script to do column to row in awk

Hi , Can anyone help me suggesting - how to do the below trick with awk Input 120 130 140 210 310 410 645 729 800 Output 120 130 140 (6 Replies)
Discussion started by: Indra2011
6 Replies
analog(1)						      General Commands Manual							 analog(1)

NAME
analog - web server logfile analyser SYNOPSIS
analog --help analog [(-|+)1] [(-|+)4] [(-|+)5] [(-|+)6] [(-|+)7] [(-|+)A] [(-|+)a] [-B|+B[options]] [-b|+b[options]] [(-|+)C'configuration-line'] [-c|+c[options]] [(-|+)D] [(-|+)d] [-E|+E[options]] [-F|+Fdate] [-f|+f[options]] [-G] [+gfilename] [(-|+)H] [(-|+)h] [-I|+I[options]] [-i|+i[options]] [-J|+J[options]] [-j|+j[options]] [-K|+K[options]] [-k|+k[options]] [-L|+L[options]] [-l|+l[options]] [-M|+M[options]] [(-|+)m] [-N|+N[options]] [-n|+n[options]] [+Ooutput-file] [-o|+o[options]] [(-|+)P] [-p|+p[options]] [(-|+)Q] [-q|+q[[-|+]types]] [-R|+R[options]] [-r|+r[options]] [-S|+S[options]] [(-|+)S] [-T|+Tdate] [-t|+t[options]] [(-|+)Ucache] [-u|+u[options]] [-V|+V[[-|+]types]] [-v|+v[options]] [(-|+)W] [(-|+)w] [(-|+)X] [(-|+)x] [-Y|+Y[options]] [-y|+y[options]] [-Z|+Z[options]] [(-|+)z] [--settings] [logfile...] but normally just analog [-G] [+gfilename] DESCRIPTION
Analog is a program for analyzing log files, and is designed to be fast and to produce attractive statistics. The usual (and easier) way of configuring analog is through a configuration file, not command line options. For more information about writing a configuration file or about the command line options see Readme.html in the analog documentation. A description of what options are available for the non-time reports is available in othreps.html#othclarg in the analog documentation. OPTIONS
--help Display version and help information and exit. (-|+)1 Toggle the Yearly Report. (-|+)4 Toggle the Quarter-Hour Report. (-|+)5 Toggle the Five-Minute Report. (-|+)6 Toggle the Quarter-Hour Summary. (-|+)7 Toggle the Five-Minute Summary. (-|+)A Turn all the reports (except the General Summary) off or on. (-|+)a Toggle output style between HTML and PLAIN formats, respectively. -B|+B[options] Turn the Browser Report off or on, possibly setting options. -b|+b[options] Turn the Browser Summary off or on, possibly setting options. (-|+)C'configuration-line' Include configuration-line in the configuration commands. -c|+c[options] Turn the Status Code Report off or on, possibly setting options. (-|+)D Toggle the Daily Report. (-|+)d Toggle the Daily Summary. -E|+E[options] Turn the Redirection Report off or on, possibly setting options. -F|+Fdate Toggle or set the FROM date. Use -F to turn the FROM date off, and use +Fdate to set the FROM date. -f|+f[options] Turn the Referrer Report off or on, possibly setting options. -G Do not use the default configuration file. +gfilename Add filename to the list of configuration files. (-|+)H Turn the Hourly Report off or on, possibly setting options. (-|+)h Toggle the Hourly Summary. -I|+I[options] Turn the Failure Report off or on, possibly setting options. -i|+i[options] Turn the Directory Report off or on, possibly setting options. -J|+J[options] Turn the User Failure Report off or on, possibly setting options. -j|+j[options] Turn the User Redirection Report off or on, possibly setting options. -K|+K[options] Turn the Failed Referrer Report off or on, possibly setting options. -k|+k[options] Turn the Redirected Referrer Report off or on, possibly setting options. -L|+L[options] Turn the Host Failure Report off or on, possibly setting options. -l|+l[options] Turn the Host Redirection Report off or on, possibly setting options. -M|+M[options] Turn the Virtual Host Failure Report off or on, possibly setting options. (-|+)m Toggle the Monthly Report. -N|+N[options] Turn the Search Query Report off or on, possibly setting options. -n|+n[options] Turn the Search Word Report off or on, possibly setting options. (-|+)Ooutput-file Write output to output-file. Use - for stdout. -o|+o[options] Turn the Domain Report off or on, possibly setting options. (-|+)P Toggle the Processing Time Report. (-|+)p Toggle the Operating System Report. (-|+)Q Toggle the Quarterly Report. -q|+q[[-|+]types] Turn all warnings off/on, or remove/add/use exactly specified types of warnings. -R|+R[options] Turn the Virtual Host Redirection Report off or on, possibly setting options. -r|+r[options] Turn the Request Report off or on, possibly setting options. -S|+S[options] Turn the Host Report off or on, possibly setting options. -s|+s[options] Turn the Referring Site Report off or on, possibly setting options. -T|+Tdate Toggle or set the TO date. Use -T to turn the TO date off, and use +Tdate to set the TO date. -t|+t[options] Turn the File Type Report off or on, possibly setting options. (-|+)Ucache Use file cache for cache output. -u|+u[options] Turn the User Report off or on, possibly setting options. -V|+V[[-|+]types] Turn all debugging off/on, or remove/add/use exactly specified types of debugging messages. -v|+v[options] Turn the Virtual Host Report off or on, possibly setting options. (-|+)W Toggle the Weekly Report. (-|+)w Toggle the Hour of the Week Report. (-|+)X Toggle GOTOS (on and off only). (-|+)x Toggle the General Summary. -Y|+Y[options] Turn the Internal Search Query Report off or on, possibly setting options. -y|+y[options] Turn the Internal Search Word Report off or on, possibly setting options. -Z|+Z[options] Turn the Organization Report off or on, possibly setting options. (-|+)z Toggle the File Size Report. --settings Instead of processing any files, display in English the settings analog would use if it ran normally. This is useful for trou- bleshooting. logfile... The logfiles to be analysed. Use - for stdin. SEE ALSO
The analog home page at http://www.analog.cx/ The analog documentation on your local machine, or from the analog home page. BUGS
An up to date list of known bugs and bug fixes can be found at http://www.analog.cx/bugs.html AUTHORS
Analog and related documentation was written by Stephen Turner <analog-author@lists.meer.net>, with contributions from other authors. (See acknow.html in the analog documentation.) This man page was written by Alexander Toth <alex@purificator.net>. Analog Version 6.0 19 December 2004 analog(1)
All times are GMT -4. The time now is 03:34 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy