Convert Column data values to rows Post: 302937329

Sponsored Content

Top Forums Shell Programming and Scripting Convert Column data values to rows Post 302937329 by RudiC on Thursday 5th of March 2015 05:19:32 AM

03-05-2015

Registered User

Any attempts from your side?

---------- Post updated at 11:19 ---------- Previous update was at 11:02 ----------

However, try

Code:

awk     '/[Ss]ection/   {print; next}
         NR==2          {for (i=NF; i>=NF-11; i--) {M[i]=$i; $i=""}; sub ("\|*$", "|Data")
                        }
         NR>4           {FN=NF  
                         for (i=FN; i>=FN-11; i--)      {D[i]=$i; $i=""}; sub ("\|*$", "")
                         for (i=FN-11; i<=FN; i++)      {$3=M[i]; $(FN-11)= D[i]  
                                                         print
                                                        }
                         next
                        }
         1
        ' FS="|" OFS="|" file
Header Section
employee|employee name||Job description|Job code|Unitcode|Account|geography|C1|C2|C3|C4|C5|C6|C7|C8|C9|Csource|Data
 
Data section 
8243651u7|juanalk|Oct|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|10
8243651u7|juanalk|Nov|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|20
8243651u7|juanalk|Dec|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|30
8243651u7|juanalk|Jan|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|40
8243651u7|juanalk|Feb|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|50
8243651u7|juanalk|Mar|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|0
8243651u7|juanalk|Apr|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|0
8243651u7|juanalk|May|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|0
8243651u7|juanalk|Jun|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|0
8243651u7|juanalk|Jul|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|0
8243651u7|juanalk|Aug|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|0
8243651u7|juanalk|Sep|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|0

RudiC

View Public Profile for RudiC

Find all posts by RudiC

10 More Discussions You Might Find Interesting

1. 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

2. Shell Programming and Scripting

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?

3. 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"

4. UNIX for Dummies Questions & Answers

Suggestion to convert data in rows to data in columns

Hello everyone! I have a huge dataset looking like this: nameX nameX 0 1 2 2 2 2 2 2 2 2 2 2 2 2 1 2 2 2 1 2 2 2 ............... nameY nameY 2 2 2 2 2 2 2 2 2 2 1 2 2 2 1 2 2 2 ..... nameB nameB 0 1 2 2 2 2 2 2 2 2 1 2 2 2 1 2 2 2 ..... (can be several thousands of codes) and I need...

5. Shell Programming and Scripting

Convert Column Values to a Range of Values

I have a list of columns with values that I need to transform into a row containing the range of each column. For example: "Column A" 1 2 3 4 10 12 14 15 16 17 18 "Column B" 1 4 5 6

6. Shell Programming and Scripting

How to convert values in a line to rows?

hi, I am basically running a sql that returns me values and I have stored them to a variable for example value of the variable will be: 123 124 345 now I want to write values stored in the variable into a file as 123 124 345 thanks in advance

7. 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...

8. 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 ...

9. Shell Programming and Scripting

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 : 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 ...

10. Programming

DB2 Query -Convert multi values from column to rows

Hi Team I am using DB2 artisan tool and struck to handle multi values present in columns that are comma(,) separated. I want to convert those column values in separate rows . For example : Column 1 Column2 Jan,Feb Hold,Sell,Buy Expected Result Column1 ...

LEARN ABOUT CENTOS

paps

PAPS(1) 						      General Commands Manual							   PAPS(1)

NAME

       paps - UTF-8 to PostScript converter using Pango

SYNOPSIS

       paps [options] files...

DESCRIPTION

       paps reads a UTF-8 encoded file and generates a PostScript language rendering of the file. The rendering is done by creating outline curves
       through the pango ft2 backend.

OPTIONS

       These programs follow the usual GNU command line syntax, with long options starting with  two  dashes  (`-').   A  summary  of  options	is
       included below.

       --landscape
	      Landscape output. Default is portrait.

       --columns=cl
	      Number of columns output. Default is 1.

       --font=desc
	      Set the font description. Default is Monospace 12.

       --rtl  Do rtl layout.

       --paper ps
	      Choose paper size. Known paper sizes are legal, letter, a4. Default is A4.

       --bottom-margin=bm
	      Set bottom margin in postscript points (1/72 inch). Default is 36.

       --top-margin=tm
	      Set top margin. Default is 36.

       --left-margin=lm
	      Set left margin. Default is 36.

       --right-margin=rm
	      Set right margin. Default is 36.

       --help Show summary of options.

       --header
	      Draw page header for each page.

       --markup
	      Interpret the text as pango markup.

       --encoding=ENCODING
	      Assume the documentation encoding is ENCODING.

       --lpi  Set the lines per inch. This determines the line spacing.

       --cpi  Set the characters per inch. This is an alternative method of specifying the font size.

       --stretch-chars
	      Indicates  that  characters  should be stretched in the y-direction to fill up their vertical space. This is similar to the texttops
	      behaviour.

AUTHOR

       paps was written by Dov Grobgeld <dov.grobgeld@gmail.com>.

       This manual page was written by Lior Kaplan <kaplan@debian.org>, for the Debian project (but may be used by others).

								  April  17, 2006							   PAPS(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

convert rows into column

Discussion started by: cdfd123

2. Shell Programming and Scripting

Convert Column to rows

Discussion started by: kaponeh

3. Shell Programming and Scripting

Convert rows into column groups

Discussion started by: selvanraj

4. UNIX for Dummies Questions & Answers

Suggestion to convert data in rows to data in columns

Discussion started by: kush