Converting Pivot file to flat file

vskr72 · #1 (**permalink**) 10-18-2005

I have a file in this format.
P1 P2 P3.........................
A001 v11 v21 v31......................
A002 v12 v22 v32............................
A003 v13 v23 v33..........................
A004 v14 v24 v34..............................
.
.
.
A00n

This has to be flattened in this format

A001 P1 v11
A001 P2 v21
A001 P3 v31
A001 P4 v41
...
...
...

Please let me know if ther is a easy way in awk to do it?

Kumar

Perderabo · #2 (**permalink**) 10-18-2005

Maybe...

Code:

#! /usr/bin/ksh

read one
while read field line ; do
        echo "$field ${one%% *} $line"
        one=${one#* }
done
exit 0

vgersh99 · #3 (**permalink**) 10-18-2005

or with awk:

nawk -f vs.awk myFile.txt

vs.awk:

Code:

FNR == 1 { n=split("1 " $0, arr, FS); next }
{
  for(i=2; i <= n; i++)
    print $1, arr[i], $i
}

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Flat file	Krishnaramjis	Shell Programming and Scripting	9	05-08-2008 10:28 PM
Converting .ps file to .pdf file from where it is broken	sunitachoudhury	UNIX for Advanced & Expert Users	5	04-07-2008 11:13 AM
Pivot variable record length file and change delimiter	thomasr	Shell Programming and Scripting	3	10-08-2007 08:40 PM
Converting a Delimited File to Fixed width file	raghavan.aero	Shell Programming and Scripting	2	06-06-2007 02:44 PM
Converting a text file to a csv file	primowalker	Shell Programming and Scripting	4	12-06-2005 05:02 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: