Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Convert rows into column along with header
Top Forums Shell Programming and Scripting Convert rows into column along with header Post 302996754 by RudiC on Tuesday 2nd of May 2017 03:20:07 AM
Old 05-02-2017
"seems to work" is not quite the expected result...

Code:
awk '
NR == 1         {printf "%s ", $0                                               # print time stamp
                 next                                                           # continue with next record
                }
NR == 2         {for (i=2; i<=NF; i++) HD[i] = $i                               # collect header names from second field
                 MXHD = NF                                                      # collect header count
                 next                                                           # continue with next record
                }
                {MXSV     = NR - 3                                              # determine & keep maximum server No.
                 SV[MXSV] = $1                                                  # collect server name
                 for (i=2; i<=NF; i++) DT[i, MXSV] = $i                         # collect server data
                }
END             {for (i=1; i<=MXSV; i++)                                        # use nested loops (i & j)
                   for (j=2; j<=MXHD; j++) printf " %s-%s", SV[i], HD[j]        # to print server-header combinations
                 printf RS                                                      # print line feed
                 for (i=1; i<=MXSV; i++)                                        # use nested loops (i & j)
                   for (j=2; j<=MXHD; j++) printf "%s\t", DT[j,i]               # to print server data
                 printf RS                                                      # print line feed
                }
' file

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert Header into Column in Text file

Hi Gurus, I have a requirement like this and have to create a UX shell scripts. Thanks in advance. File-in: ------ Header2007-12-012007-11-21 100|xyz|was 101|wsa|qws ...... ....... Output should be: ------------------- 2007-12-01|100|xyz|was 2007-12-01|101|wsa|qws ...... .......... (7 Replies)
Discussion started by: vsubbu1000
7 Replies

2. Shell Programming and Scripting

convert rows into column

if u have a data 2 4 6 8 5 4 4 5 6 then result shud be like 2 4 6 7 5 4 4 5 6 (3 Replies)
Discussion started by: cdfd123
3 Replies

3. UNIX for Dummies Questions & Answers

How to convert a single column into several rows and columns?

I have a program which gives me the output as a single column with hundreds of rows like: 213 314 324 324 123 I want to be able to create a new file from this file which allows me to set the number of rows and columns in the new file, i.e. for this example, if I specify 3 rows and 2... (5 Replies)
Discussion started by: ashton_smith
5 Replies

4. Shell Programming and Scripting

Convert Column to rows

Hi, I have a file with below contents. Heading1 Heading2 Heading3 Heading4 Value1 Value2 Value3 Value4 The file has only 2 rows and is tab separated The desired output is : Heading1 Value1 Heading2 Value2 Heading3 Value3 Heading4 Value4 CAn you please help? (5 Replies)
Discussion started by: kaponeh
5 Replies

5. Shell Programming and Scripting

Convert rows into column groups

Hi I have the text file like this "A" "AA Info" "AA Text" "AAA" "ABC" "ABC Info" "ABC Tech" "AGH" "SYN" "SYMBony" "SYN BEREN" Like about 2000 lines Output would be in Column with groups like following "A" "AA Info", "AA Text" "AAA" "ABC","ABC Info","ABC Tech" (0 Replies)
Discussion started by: selvanraj
0 Replies

6. Shell Programming and Scripting

Convert Rows into Column

Hi Experts, I have a requirement to convert rows into columns. For e.g. Input File: Output File should be like Appreciate if you could suggest code snippet(may be awk) for above requirement... Thanks in Advance for your help... (3 Replies)
Discussion started by: sai_2507
3 Replies

7. Shell Programming and Scripting

Convert header rows into

I want to put the 3 first lines into a single line separated by ; I've tried to use Sed and Awk but without success. I'm new to Shell scripting. Thanks in advance! Input 112 DESAC_201309_OR_DJ10 DJ10 1234567890123;8 1234567890124;20 1234567890125;3 expected Output... (8 Replies)
Discussion started by: MoroccanRoll
8 Replies

8. Shell Programming and Scripting

Convert single column into multiple rows

Convert Single column to multiple rows file a.txt contains data like below Server=abc Run=1 Tables=10 Sessions=16 Time=380 Jobs=5 Server=abc Run=2 Tables=15 Sessions=16 Time=400 Jobs=5 Server=abc Run=3 Tables=20 Sessions=16 Time=450 (5 Replies)
Discussion started by: sol_nov
5 Replies

9. Shell Programming and Scripting

Convert rows to column and add header

Hi, I need help to convert rows in input file into a table. inputfile 192.98.1 192.98.192.98.17 VVC family Zorro 10 192.98.1 192.98.192.98.17 VVC family Ace 1 192.98.1 192.98.192.98.17 VVC family ... (4 Replies)
Discussion started by: redse171
4 Replies

10. Shell Programming and Scripting

Convert Column data values to rows

Hi all , I have a file with the below content Header Section employee|employee name||Job description|Job code|Unitcode|Account|geography|C1|C2|C3|C4|C5|C6|C7|C8|C9|Csource|Oct|Nov|Dec|Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep Data section ... (1 Reply)
Discussion started by: Hypesslearner
1 Replies

LEARN ABOUT CENTOS

pcap_set_tstamp_precision

PCAP_SET_TSTAMP_PRECISION(3PCAP)										  PCAP_SET_TSTAMP_PRECISION(3PCAP)

NAME

       pcap_set_tstamp_precision - set the time stamp precision returned in captures

SYNOPSIS

       #include <pcap/pcap.h>

       int pcap_set_tstamp_precision(pcap_t *p, int tstamp_precision);

DESCRIPTION

       pcap_set_tstamp_precision()  sets the precision of the time stamp desired for packets captured on the pcap descriptor to the type specified
       by tstamp_precision.  It must be called on a pcap descriptor created by pcap_create() that has not yet been activated  by  pcap_activate().
       Two time stamp precisions are supported, microseconds and nanoseconds. One can use options PCAP_TSTAMP_PRECISION_MICRO and PCAP_TSTAMP_PRE-
       CISION_NANO to request desired precision. By default, time stamps are in microseconds.

RETURN VALUE

       pcap_set_tstamp_type() returns 0 on success if the specified time stamp precision is expected to be  supported  by  the	operating  system,
       PCAP_ERROR_TSTAMP_PRECISION_NOTSUP if operating system does not support requested time stamp precision, PCAP_ERROR_ACTIVATED if called on a
       capture handle that has been activated.

SEE ALSO

       pcap(3PCAP), pcap_get_tstamp_precision(3PCAP), pcap-tstamp(7)

								  27 August 2013				  PCAP_SET_TSTAMP_PRECISION(3PCAP)
All times are GMT -4. The time now is 07:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy