Sponsored Content
Top Forums Shell Programming and Scripting Convert rows into column along with header Post 302996709 by john_prince on Monday 1st of May 2017 08:39:26 AM
Old 05-01-2017
Convert rows into column along with header

Hi,

I have a requirement to format the data in a new order. Here is my source format :

Code:
ppp ***Wed Dec 16 10:32:30 GMT 2015
header1 header2 header3 header4 header5

server1  0.00    0.02     0.07   0.98
server2  0.01    0.00     0.08  0.79 
server3  0.05    0.82     0.77  0.86

I need to change the above data snippet to the following format.
Code:
ppp ***Wed Dec 16 10:32:30 GMT 2015 server1-header2 server1-header3 server1-header4 server1-header5 server2-header2 server2-header3 server2-header4 server2-header5 server3-header2 server3-header3 server3-header4 server3-header5

0.00    0.02      0.07  0.98 0.01  0.00  0.08 0.79 0.05    0.82   0.77    0.86

The intent is to create multiple tables of timestamp while converting rows into columns.

I am not sure from to start, any help. I tried awk to grab the column, and not sure how to merge rows into column.

Thanks in advance.
 

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
ntp.conf(5)							File Formats Manual						       ntp.conf(5)

Name
       ntp.conf - Network Time Protocol configuration file

Description
       The  file  is the configuration file for the Network Time Protocol (NTP) daemon, This file must be configured on your system before running
       Any host names that you specify in the file must have an entry in the file, or an entry in the master database, if the  database  is  being
       served to your system by BIND/Hesiod or Yellow Pages.

       The file has four entry formats:

       trusting no
	    This entry guarantees that your system synchronizes only to the NTP servers identified in the peer and server entries specified.  Dig-
	    ital recommends that all systems include the entry.

       peer server
	    This entry identifies server as one of the NTP servers that your system trusts, and from which your system will accept  time  synchro-
	    nization.	 Your  system  may  also  provide time synchronization to this server.	Servers can be identified by host name or internet
	    address.

	    NTP servers should be configured with entries.

       server server
	    This entry identifies server as one of the NTP servers that your system trusts, and from which your system will accept  time  synchro-
	    nization.	Your  system  can  not	provide  time  synchronization to this server.	Servers can be identified by host name or internet
	    address.

	    NTP clients should be configured with entries.

       peer   /dev/null       LOCL    1       -5      local
	    This entry identifies your system as a local reference clock.  A local reference clock is the most accurate system clock available	at
	    your  site.   If you receive time synchronization from the Internet NTP service, you should not include this entry on any of your sys-
	    tems.  At most, one system in a set of nodes running should be identified as a local reference clock.

	    A host which specifies this entry should not specify any or entries.

Examples
       This is a sample configuration file for an NTP client which receives time synchronization from the NTP servers: and Lines beginning with  a
       number sign (#) are comments.
       #
       #	       NTP  Configuration File
       #	This file is mandatory for the ntpd daemon
       #
       #
       #
       #   **  A L L  **
       #
       #  "trusting no" prevents this host from synchronizing
       #   to any host that is not listed below.  It is recommended
       #   that all hosts include the line "trusting no".
       #
       trusting no
       #
       #
       #    **	S E R V E R  **
       #
       #  If you are configuring a server, use "peer" entries to
       #  synchronize to other NTP servers.  For example, server1,
       #  server2, and server3.
       #
       #peer	      server1
       #peer	      server2
       #peer	      server3
       #
       #
       #
       #
       #    **	C L I E N T  **
       #
       #  If you are configuring a client, use "server" entries to
       #  synchronize to NTP servers.  For example, server1, server2,
       #  and server3.
       #
       server	      server1
       server	      server2
       server	      server3
       #
       #
       #
       #    **	L O C A L   R E F E R E N C E	C L O C K  **
       #
       #  If you are configuring a local reference clock, include the
       #  following entry and the "trusting no" entry ONLY.
       #
       #peer	 /dev/null LOCL 1    -5   local
       #

See Also
       ntp(1), ntpd(8), ntpdc(8)
       RFC 1129--Internet time synchronization:  The Network Time Protocol
       Introduction to Networking and Distributed System Services

																       ntp.conf(5)
All times are GMT -4. The time now is 03:12 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy