Sponsored Content
Top Forums Shell Programming and Scripting Convert rows into columns using awk or perl Post 302744237 by Skrynesaver on Friday 14th of December 2012 04:59:08 AM
Old 12-14-2012
Code:
#!/usr/bin/perl

$complete=0;
while(<DATA>){
    push @{$data{$1}},$2 if /^([\w-]+)\s=\s(.+)$/;
    push @headers,$1 if (! $complete);
    $complete++ if/^\*+$/;
}
print join("\t\t",@headers),"\n";
for $index (0..$complete){
    for $field (@headers){
        print "$data{$field}->[$index]\t\t";
    }
    print "\n";
}
__DATA__
Package-Name = dev-freetype.

Old-Version = 2.4.8

New-Version = 2.4.10

Patches-removed = freetype-2.4.8-cross-compile.patch freetype-2.4.8-opentype.patch freetype-2.4.8-yahoo-widget.patch

Patches-added = freetype-2.4.10-cross-compile.patch freetype-2.4.10-opentype.patch freetype-2.4.10-yahoo-widget.patch
*****

Package-Name = dev-glib.

Old-Version = 2.24.2

New-Version = 2.32.0

Patches-removed = glib-patch1.patch

Patches-added =  glib-patch2.patch
*****

Package-Name = host-elfutils.

Old-Version = 0.130

New-Version = 0.152

Patches-removed = elfutils-strip-copy-symtab.patch elfutils-portability.patch elfutils-robustify.patch elfutils-0.130-fixes.patch elfutils-0.130-fix-libelf-off64_t.patch
elfutils-0.130-sigfpe-fix.patch

Patches-added = elfutils-%{version}-portability.patch elfutils-%{version}-robustify.patch
*****

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to convert columns to rows

Hi, I need a shell script for below requirement Input file P1 - 173310 P2 - 173476 P3 - 173230 P4 - 172737 P1 - 173546 P2 - 173765 P3 - 173876 P4 - 172989 Out put file P1 173310 173546 P2 173476 173765 P3 173230 173876 P4 172737 172989 Suresh (6 Replies)
Discussion started by: suresh3566
6 Replies

2. UNIX for Dummies Questions & Answers

Convert rows to columns using AWK

Hi , I am struck while coding AWK script. Need your help to convert rows into columns. I should copy only those rows which are marked to Y in a file and ignore N rows. Please help me find a solution. input file 1|abc|Y 2|cdf|Y 3|efg|N 4|xyz|Y my output should be something like this... (2 Replies)
Discussion started by: rashmisb
2 Replies

3. Shell Programming and Scripting

Convert columns to rows in perl script

Hi All I want to have a Perl script which convert columns to rows. The Perl should should read the data from input file. Suppose the input file is 7215484 date to date 173.3 A 1.50 2.23 8.45 10.14 2.00 4.50 2.50 31.32 7216154 month to month (3 Replies)
Discussion started by: parthmittal2007
3 Replies

4. Shell Programming and Scripting

Convert few columns to rows

Hi! Does anybody help me in converting following data: INPUT looks like this: 20. 100. 30 200. 40. 400. 50. 100. 60. 200. 70. 400. 80. 200. 150. 210. 30. 100. OUTPUT should look like this: 20. 100. 30 200. 40. 400. 50. 100. 60. 200. 70.... (5 Replies)
Discussion started by: lovelinux
5 Replies

5. Shell Programming and Scripting

How to Convert rows in to columns?

Hi Gurus, How to convert rows in to columns using linux shell scripting Input is like (sample.txt) ABC DEF GHI JKL MNO PQR STU VWX YZA BCD output should be (sampleoutput.csv) ABC,DEF,GHI,JKL,MNO PQR,STU,VWX,YZA,BCD (2 Replies)
Discussion started by: infasriniit
2 Replies

6. UNIX for Dummies Questions & Answers

Awk: convert rows to columns every n lines

Hi guys! I use AWK commands under GAMS to predispose the data files to be read by GAMS. I have a file which contains groups of data I need. Unfortunately I have the data spread in 3 rows for each subject. Here's an example (the file is really long) 1 0 2.0956 100.00 250.00 100.00 2.0956... (4 Replies)
Discussion started by: Pintug
4 Replies

7. Shell Programming and Scripting

Convert Rows to Columns

Hi Everyone, Could someone shed some lights on how to convert the records in rows form into column basis. 172.29.59.12 IBM,8255-E8B 102691P 8 65536 MB 6100-04-11-1140 172.29.59.15 IBM,8255-E8B 102698P 4 45056 MB 6100-04-11-1140 IP SYS MODEL ... (6 Replies)
Discussion started by: ckwan
6 Replies

8. Shell Programming and Scripting

Convert rows to columns

I am looking to print the data in columns and after every 3 words it should be a new row. cat example.out | awk 'END { for (i = 0; ++i < m;) print _;print _ }{ _ = _ x ? _ OFS $1 : $1}' m=1| grep -i INNER I am looking to print in a new line after every 3 words. ... (2 Replies)
Discussion started by: lazydev
2 Replies

9. Shell Programming and Scripting

Convert rows to columns

hi folks, I have a sample data like what is shown below: 1,ID=1000 1,Org=CedarparkHospital 1,cn=john 1,sn=doe 1,uid=User001 2,uid=User002 2,ID=2000 2,cn=steve 2,sn=jobs 2,Org=Providence I would like to convert it into the below format: 1,1000,CedarparkHospital,john,doe,User001... (11 Replies)
Discussion started by: vskr72
11 Replies

10. Shell Programming and Scripting

Convert rows into columns and create table with awk

Hello I've four fields . They are First Name, Last Name, Age, Country. So when I run a Unix command, I get below output with these fields comes every time in different order as you can see. Some times first name is the first row and other time last name is first row in the output and etc etc..... (9 Replies)
Discussion started by: rprpr
9 Replies
COLORDIFF(1)															      COLORDIFF(1)

NAME
colordiff - a tool to colorize diff output SYNOPSIS
colordiff [diff options] [colordiff options] {file1} {file2} DESCRIPTION
colordiff is a wrapper for diff and produces the same output as diff but with coloured syntax highlighting at the command line to improve readability. The output is similar to how a diff-generated patch might appear in Vim or Emacs with the appropriate syntax highlighting options enabled. The colour schemes can be read from a central configuration file or from a local user ~/.colordiffrc file. colordiff makes use of ANSI colours and as such will only work when ANSI colours can be used - typical examples are xterms and Eterms, as well as console sessions. colordiff has been tested on various flavours of Linux and under OpenBSD, but should be broadly portable to other systems. USAGE
Use colordiff wherever you would normally use diff, or pipe output to colordiff: For example: $ colordiff file1 file2 $ diff -u file1 file2 | colordiff You can pipe the output to 'less', using the '-R' option (some systems or terminal types may get better results using '-r' instead), which keeps the colour escape sequences, otherwise displayed incorrectly or discarded by 'less': $ diff -u file1 file2 | colordiff | less -R If you have wdiff installed, colordiff will correctly colourise the added and removed text, provided that the '-n' option is given to wdiff: $ wdiff -n file1 file2 | colordiff You may find it useful to make diff automatically call colordiff. Add the following line to ~/.bashrc (or equivalent): alias diff=colordiff Any options passed to colordiff are passed through to diff except for the colordiff-specific option 'difftype', e.g. colordiff --difftype=debdiff file1 file2 Valid values for 'difftype' are: diff, diffc, diffu, diffy, wdiff, debdiff; these correspond to plain diffs, context diffs, unified diffs, side-by-side diffs, wdiff output and debdiff output respectively. Use these overrides when colordiff is not able to determine the diff-type automatically. Alternatively, a construct such as 'cvs diff SOMETHING | colordiff' can be included in ~/.bashrc as follows: function cvsdiff () { cvs diff $@ | colordiff; } Or, combining the idea above using 'less': function cvsdiff () { cvs diff $@ | colordiff |less -R; } Note that the function name, cvsdiff, can be customized. FILES
/etc/colordiffrc Central configuration file. User-specific settings can be enabled by copying this file to ~/.colordiffrc and making the appropriate changes. colordiffrc-lightbg Alternate configuration template for use with terminals having light backgrounds. Copy this to /etc/colordiffrc or ~/.colordiffrc and customize. BUGS
Bug reports and suggestions/patches to <davee@sungate.co.uk> please. AUTHOR
colordiff is written and maintained by Dave Ewart <davee@sungate.co.uk>. This manual page and the source XML was written by Graham Wilson <graham@mknod.org> for Debian and is maintained by the author. Dave Ewart maintains the Debian package. 01/25/2009 COLORDIFF(1)
All times are GMT -4. The time now is 12:57 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy