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
VOS_CHANGELOC(1)					       AFS Command Reference						  VOS_CHANGELOC(1)

NAME
vos_changeloc - Change a volume's entry in the VLDB SYNOPSIS
vos changeloc [-server] <new server name> [-partition] <new partition location> [-id] <volume name or ID> [-cell <cell name>] [-noauth] [-localauth] [-verbose] [-encrypt] [-noresolve] [-help] vos changel [-s] <new server name> [-p] <new partition location> [-i] <volume name or ID> [-c <cell name>] [-noa] [-l] [-v] [-e] [-nor] [-h] DESCRIPTION
The vos changeloc command changes the location of a volume in the Volume Location Database (VLDB) without needing to contact the original file server on which the volume was hosted. This is useful when a file server has gone down permanently and the data that was stored on that server has been moved to a new file server with a different name and IP address (perhaps by mounting the same /vicepX partitions on a different host). After moving the data and running vos changeloc, run vos syncvldb and then vos syncserv against the new server to ensure full synchronization of the VLDB with the file server. In essence, vos changeloc performs the same operations on the VLDB as vos move, but it does NOT move the data from one server's file system to another. CAUTIONS
Using vos changeloc changes the VLDB without modifying the file server data, so it inherently causes the VLDB to be out of sync with the data on the servers. It should only be used when recovering from server failure. If the servers are on-line, vos move should be used instead. It is highly recommended that vos syncvldb and vos syncserv be run after using the vos changeloc command to ensure properly synchronization of the VLDB with the file servers. OPTIONS
vos changeloc takes the following options: -server <new server name> Specifies the new server where the VLDB should believe the volume resides. Provide the machine's IP address or its host name (either fully qualified or using an unambiguous abbreviation). For details, see vos(1). -partition <partition name> Specifies the partition where the VLDB should believe the volume resides. Provide the -server argument along with this one. Provide the partition's complete name with preceding slash (for example, "/vicepa") or use one of the three acceptable abbreviated forms. For details, see vos(1). -id <volume name or ID> Specifies the name or volume ID number on which to operate. -cell <cell name> Names the cell in which to run the command. Do not combine this argument with the -localauth flag. For more details, see vos(1). -noauth Assigns the unprivileged identity "anonymous" to the issuer. Do not combine this flag with the -localauth flag. For more details, see vos(1). -localauth Constructs a server ticket using a key from the local /etc/openafs/server/KeyFile file. The vos command interpreter presents it to the Volume Server and Volume Location Server during mutual authentication. Do not combine this flag with the -cell argument or -noauth flag. For more details, see vos(1). -verbose Produces on the standard output stream a detailed trace of the command's execution. If this argument is omitted, only warnings and error messages appear. -encrypt Encrypts the command so that the operation's results are not transmitted across the network in clear text. This option is available in OpenAFS versions 1.4.11 or later and 1.5.60 or later. -noresolve Shows all servers as IP addresses instead of the DNS name. This is very useful when the server address is registered as 127.0.0.1 or when dealing with multi-homed servers. This option is available in OpenAFS versions 1.4.8 or later and 1.5.35 or later. -help Prints the online help for this command. All other valid options are ignored. OUTPUT
vos changeloc shows a brief message upon completion: Changed location to server2 /vicepa for volume user.jdoe EXAMPLES
The following command changes the location of the "user.jdoe" volume to be /vicepa on the file server machine "server2" while being verbose: % vos changeloc server2 a user.jdoe -verbose done Changed location to server2 /vicepa for volume user.jdoe The following command changes the location of the "user.jdoe" volume to be /vicepa on "server1" without being verbose: % vos changeloc server1 a user.jdoe Changed location to server1 /vicepa for volume user.jdoe PRIVILEGE REQUIRED
The issuer must be listed in the /etc/openafs/server/UserList file on each database server machine. If the -localauth flag is included, the issuer must instead be logged on to a server machine as the local superuser "root". SEE ALSO
vos(1), vos_move(1), vos_syncserv(1), vos_syncvldb(1) COPYRIGHT
Copyright 2007 Jason Edgecombe <jason@rampaginggeek.com> This documentation is covered by the BSD License as written in the doc/LICENSE file. This man page was written by Jason Edgecombe for OpenAFS. OpenAFS 2012-03-26 VOS_CHANGELOC(1)
All times are GMT -4. The time now is 10:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy