Sponsored Content
Top Forums UNIX for Beginners Questions & Answers How to transpose pieces of data in a column to multiple rows? Post 303039581 by shellnewuser on Wednesday 9th of October 2019 11:47:40 PM
Old 10-10-2019
RE: How to transpose pieces of data in a column to multiple rows?

Thank you very much RavinderSingh13 for such a prompt response. The code did work but I have following issues:
1. The code did throw the expected output on the terminal but what I need is that the Input file itself is modified to have the data between "abc" and "***END***" transposed in rows as shown on the terminal.
2. Also, in some files the number of "*" around the word "END" varies, is there a way to generalize the number of "*" so I don't have to worry about it?
3. There is some additional data before "abc" which does not need to be transposed, how do I keep that data as it is along with transposing the data between "abc" and "***END***" like you did.

If its not too much to ask, could you kindly mention what each piece of your code does so I can learn as well.

Once again thank you for help!

Regards.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Transpose columns to Rows : Big data

Hi, I did read a few posts on the subjects, tried out a few solutions, but did not solve my problem. https://www.unix.com/302121568-post11.html https://www.unix.com/shell-programming-scripting/137953-large-file-columns-into-rows-etc-4.html Please help. Problem very similar to the second link... (15 Replies)
Discussion started by: genehunter
15 Replies

2. Shell Programming and Scripting

awk transpose rows to column

Need to transpose in awk rows to column like this: input: A1,6,5,4 3,2,1, A2,8,7,9,10,11,12,13,14 A3,1,2,3,5,7,8,9 A4,9,4,8,1,5,3, output: A1,1 A1,2 A1,4 ... A2,7 A2,8 ... A3,1 A3,2 ... A4,1 A4,3 (5 Replies)
Discussion started by: sdf
5 Replies

3. Shell Programming and Scripting

Transpose Data from Columns to rows

Hello. very new to shell scripting and would like to know if anyone could help me. I have data thats being pulled into a txt file and currently have to manually transpose the data which is taking a long time to do. here is what the data looks like. Server1 -- Date -- Other -- value... (7 Replies)
Discussion started by: Mikes88
7 Replies

4. Shell Programming and Scripting

Transpose Datefield from rows to column + Print time diff

Hi Experts, Can you please help me in transposing Datefield from rows to column and calculate the time difference for each of the Jobids: Input File: 08/23/2012 12:36:09,JOB_5340 08/23/2012 12:36:14,JOB_5340 08/23/2012 12:36:22,JOB_5350 08/23/2012 12:36:26,JOB_5350 Required Output:... (6 Replies)
Discussion started by: asnandhakumar
6 Replies

5. Shell Programming and Scripting

Transpose Column of Data to Rows

I can no longer find my commands, but I use to be able to transpose data with common fields from a single column to rows using a command line. My data is separated as follows: NAME=BOB ADDRESS=COLORADO PET=CAT NAME=SUSAN ADDRESS=TEXAS PET=BIRD NAME=TOM ADDRESS=UTAH PET=DOG I would... (7 Replies)
Discussion started by: docdave78
7 Replies

6. Shell Programming and Scripting

Transpose multiple rows (with a mix of space and enter) to a single column

How to change the uploaded weekly file data to the following format? New Well_Id,Old Well_Id,District,Thana,Date,Data,R.L,WellType,Lati.,Longi. BAG001,PT006,BARGUNA,AMTALI,1/2/1978,1.81,2.29,Piezometer,220825,901430 BAG001,PT006,BARGUNA,AMTALI,1/9/1978,1.87,2.29,Piezometer,220825,901430... (3 Replies)
Discussion started by: sara.nowreen
3 Replies

7. Shell Programming and Scripting

Transpose data as rows using awk

Hi I have below requirement, need help One file contains the meta data information and other file would have the data, match the column from file1 and with file2 and extract corresponding column value and display in another file File1: CUSTTYPECD COSTCENTER FNAME LNAME SERVICELVL ... (1 Reply)
Discussion started by: ravlapo
1 Replies

8. Shell Programming and Scripting

Peel syntax for transpose rows into column

Dear all, Plz let me know syntax for transposing rows into column in perl, I am having 30 csv files which are merged into a single xls sheet. but i want to transpose each row into column in excel sheet in each tab (1 CSV = 1tab in xls sheet) example is as below ... (0 Replies)
Discussion started by: sagar_1986
0 Replies

9. Programming

To transpose rows to column in hadoop

Hi, i am having an HDFS file which is comma seperated, i need to transpose from rows to column only the header columns text.csv cnt,name,place 1,hi,nz 2,hello,aus I need cnt, name, place while using below command in hadoop getting the error hadoop fs -fmt -1 text.csv (0 Replies)
Discussion started by: rohit_shinez
0 Replies

10. Shell Programming and Scripting

Linux - Transpose rows into column

hello, I have a server that collect some performance statistics of 4 servers in the following input file : $ cat inputfile Time,A,Server1,KPI1,data1 Time,A,Server1,KPI2,data2 Time,A,Server1,KPI3,data3 Time,A,Server1,KPI4,data4 Time,A,Server1,KPI5,data5 Time,A,Server2,KPI1,data6... (9 Replies)
Discussion started by: capitain25
9 Replies
named.star(4)						     Kernel Interfaces Manual						     named.star(4)

NAME
named.star - Defines data used by named to initialize the BIND (Berkeley Internet Name Domain) name server file SYNOPSIS
/etc/namedb/named.* DESCRIPTION
The data files referenced in the named.conf file can have any names, but they are generally given names of the form /etc/namedb/named.*. This naming convention is used for convenience in maintaining the named daemon's file. The records in the named data files are called resource records. Except for comments (starting with a ; (semicolon) and continuing to the end of the line), the resource records in the data files generally follow the format of the resource records that the named daemon returns in response to queries from resolver routines. The named.conf file is the default configuration (or boot) file for the named server. The named daemon reads the start-up file when the named daemon starts and when receiving the signal SIGHUP. EXAMPLES
The following examples portray two domains on two different networks: Domain abc.aus.osf.com, Internet address 192.9.201.n (where n varies for each system on the network) Domain xyz.aus.osf.com, Internet address 128.114.100.n (where n varies for each system on the network) In this sample configuration, both the primary and the secondary name servers are in the abc.aus.osf.com domain, and host hera is the gateway host. The following are sample entries in a named.ca file: ; root name servers. 1 IN NS relay.osf.com. relay.osf.com. 3600000 IN A 129.114.1.2 The following two files are sam- ple entries from the named.data files for hosts venus and allen. (The data files can have any name you choose, as long as that name is defined in the named.boot file. In this case, the names are named.abcdata and named.xyzdata.) The named file for host venus is in the following file, called named.abcdata: ;OWNER TTL CLASS TYPE RDATA ;local domain server is venus @ IN SOA venus bob.robert.abc.aus.osf.com. ( 1.1 ;serial 3600 ;refresh 600 ;retry 3600000 ;expire 86400) ;minimum IN NS venus IN NS kronos IN MX 10 venus.abc.aus.osf.com. ; address for local loopback localhost IN A 127.1 ; address of machines in the same domain venus IN A 192.9.201.1 venus IN A 128.114.100.1 venus IN MX 10 venus.abc.aus.osf.com. veabc IN CNAME venus IN WKS 192.9.201.1 udp (tftp nameserver domain) IN WKS 192.9.201.1 tcp (echo telnet smtp discard uucp-path systat daytime netstat chargen ftp time whois finger hostnames domain) ; delimiter for WKS kronos IN A 192.9.201.2 krabc IN CNAME kronos hera IN A 192.9.201.5 IN A 128.114.100.5 robert IN A 192.9.201.6 ernie IN A 192.9.201.7 IN HINFO HP-800 OS1 robert.abc.aus.osf.com. IN MX 10 venus.abc.aus.osf.com. The named file for host allen is in the following file, called named.xyzdata: ;OWNER TTL CLASS TYPE RDATA ;local domain server is venus xyz.aus.osf.com. IN SOA venus.abc.aus.osf.com. bob.robe rt.abc.aus.osf.com. ( 1.1 ;serial 3600 ;refresh 600 ;retry 3600000 ;expire 86400) ;minimum xyz.aus.osf.com. IN NS venus.abc.aus.osf.com. IN NS kronos.abc.aus.osf.com. IN MX 10 venus.abc.aus.osf.com. ; address for local loopback localhost IN A 127.1 ; address of machines in the same domain allen IN A 128.114.100.3 allen IN MX 10 venus.abc.aus.osf.com. alxyz IN CNAME allen IN WKS 128.114.100.3 udp (tftp nameserver domain) IN WKS 128.114.100.3 tcp (echo telnet smtp discard uucp-path systat daytime netstat chargen ftp time whois finger hostnames domain) ; delimiter for WKS fred IN A 128.114.100.10 mike IN A 128.114.100.11 IN HINFO HP-800 OS1 The following is a sample named.local file that might appear on hosts in either of the sample domains: @ IN SOA venus.abc.aus.osf.com. gail.zeus.abc.aus.osf.com. ( 1.1 ;serial 3600 ;refresh 600 ;retry 3600000 ;expire 86400) ;minimum IN NS venus.abc.aus.osf.com. 1 IN PTR localhost. The following two files are sample entries from the named.rev files for hosts venus and allen. For this example, the files are called named.abcrev and named.xyzrev. The reverse file for host venus is in the following file, called named.abcrev: @ IN SOA venus.abc.aus.osf.com. bob.robert.abc.aus.osf.com. ( 1.1 ;serial 3600 ;refresh 600 ;retry 3600000 ;expire 86400) ;minimum 9.201.192.in-addr.arpa. IN NS venus.abc.aus.osf.com. IN NS kronos.abc.aus.osf.com. IN PTR hera.abc.aus.osf.com. ;ABC.AUS.OSF.COM Hosts 1.201.9.192.in-addr.arpa. IN PTR venus.abc.aus.osf.com. 2.201.9.192.in-addr.arpa. IN PTR kronos.abc.aus.osf.com. 5.201.9.192.in-addr.arpa. IN PTR hera.abc.aus.osf.com. 6.201.9.192.in-addr.arpa. IN PTR robert.abc.aus.osf.com. 7.201.9.192.in-addr.arpa. IN PTR ernie.abc.aus.osf.com. The reverse file for host allen is in the following file, called named.xyzrev: @ IN SOA venus.abc.aus.osf.com. bob.robert.abc.aus.osf.com. ( 1.1 ;serial 3600 ;refresh 600 ;retry 3600000 ;expire 86400) ;minimum 100.114.128.in-addr.arpa. IN NS venus.abc.aus.osf.com. IN NS kronos.abc.aus.osf.com. IN PTR hera.abc.aus.osf.com. ;XYZ.AUS.OSF.COM Hosts 3.100.114.128.in-addr.arpa. IN PTR allen.abc.aus.osf.com. 10.100.114.128.in-addr.arpa. IN PTR fred.abc.aus.osf.com. 11.100.114.128.in-addr.arpa. IN PTR mike.abc.aus.osf.com. ;ABC.AUS.OSF.COM Hosts 1.100.114.128.in-addr.arpa. IN PTR venus.abc.aus.osf.com. 5.100.114.128.in- addr.arpa. IN PTR hera.abc.aus.osf.com. RELATED INFORMATION
Daemon: named(8). delim off named.star(4)
All times are GMT -4. The time now is 09:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy