Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Transpose few columns alone in a Text file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Transpose few columns alone in a Text file
# 1  
Old 06-20-2012
Transpose few columns alone in a Text file
Hi Friends,

I am Stuck up with a problem on transposing Rows to Coloumns.. Though there are many threads on this my problem is little difficult..

I have a tab separated file like Below,

Code:
computer  selling_loc  currency_type  manufacturer_name  salesweek-wk1 sales-wk2 ...wk-3 ..wk4  till ...sales-wk52   warraanty_number  warranty_date

Dell  US Dollar china_electonic 1 2 3 4 5 6  .....52   waanrnum123  26/10/1986
Samsung        US   Dollar  Japan_elec   1 3 4 5 6 7 8 9  ...52   SAMWATNUMBER   12/12/2014

I need to convert this pivot kind of data to a notmal file ...ie, i need to transpose only few coloumns
Code:
Dell  US    Dollar  China_elec   salesweek-wk-1   1  waanrnum123   26/10/1986
Dell  US    Dollar  China_elec   salesweek-wk2     2  waanrnum123   26/10/1986
Dell  US    Dollar  China_elec   salesweek-wk3     3  waanrnum123   26/10/1986

I have difficulty in taking header coloumn and printing while transposing and also printing other coloumns after transposing....

I tried below code by
Code:
awk -F\; 'END { for ( m = 0; ++m <= 3; ) printf "%s", h[m] FS for ( j = 3; ++j < n; )  for ( i = 1; ++i <= NR; )\ 
{  split( d[i], t )         print t[1], t[2], t[3], h[j], t[j], x  	     } } NR == 1 {  n = split( $0, h )\
 next    } {    d[NR] = $0    }' OFS=\; infile

i tried many ways...

I tried with perl also.. like puttting all 65 coloumn data into a hash.. but had difficulty in prining week1 week2 headers in every coloumn...

I have attached the input and Output format... pls help me on this...

Moderator's Comments:
Mod Comment Please use next time code tags for your code and data
Last edited by Scrutinizer; 06-22-2012 at 01:30 PM..
# 2  
Old 06-20-2012
Code:
$ awk '{ Z=1; for(N=5; N<(5+52); N++) print $1, $2, $3, $4, $N, Z++, $(NF-1), $NF }' data

Dell US Dollar China_elec waa-1 1 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-2 2 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-3 3 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-4 4 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-5 5 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-6 6 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-7 7 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-8 8 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-9 9 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-10 10 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-11 11 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-12 12 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-13 13 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-14 14 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-15 15 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-16 16 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-17 17 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-18 18 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-19 19 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-20 20 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-21 21 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-22 22 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-23 23 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-24 24 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-25 25 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-26 26 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-27 27 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-28 28 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-29 29 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-30 30 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-31 31 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-32 32 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-33 33 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-34 34 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-35 35 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-36 36 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-37 37 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-38 38 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-39 39 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-40 40 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-41 41 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-42 42 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-43 43 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-44 44 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-45 45 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-46 46 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-47 47 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-48 48 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-49 49 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-50 50 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-51 51 waanrnum123 26/10/1986
Dell US Dollar China_elec waa-52 52 waanrnum123 26/10/1986

$

# 3  
Old 06-21-2012
Hi Corona688 ..ThaANKS for ur help..
guess i was not clear on input and output .. 1,2,3,4 is not In order and it is a vale in File..


I have attched Input and output file../.Pls help ,..

Input
Code:
Computer_name    Location    Currency    Munufacturer    LocalCurrency    USD    Delivery_tye    Purhcase-type    26/12/1987    26/12/1988    26/12/1989    26/12/1990    26/12/1991    26/12/1992    26/12/1993    26/12/1994    26/12/1995    26/12/1996    26/12/1997    26/12/1998    26/12/1999    26/12/2000    26/12/2001    26/12/2002    26/12/2003    26/12/2004    26/12/2005    26/12/2006    26/12/2007    26/12/2008    26/12/2009    26/12/2010    26/12/2011    26/12/2012    26/12/2013    26/12/2014    26/12/2015    26/12/2016    26/12/2017    26/12/2018    26/12/2019    26/12/2020    26/12/2021    26/12/2022    26/12/2023    26/12/2024    26/12/2025    26/12/2026    26/12/2027    26/12/2028    26/12/2029    26/12/2030    26/12/2031    26/12/2032    26/12/2033    26/12/2034    26/12/2035    26/12/2036    26/12/2037    PURCHASE_NuMBER    Warranty date
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    100    89    100    100    100    43    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    100    A#12345    26/12/2014
Samsung    US    USD    Samsung_india    50000IN    100USD    DOOR    ONLINE    456    45    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    89    SSSS78799    12/12/2014

Output

Code:
Computer_name    Location    Currency    Munufacturer    LocalCurrency    USD    Delivery_tye    Purhcase-type    DATE    QTY    PURCHASE_NuMBER    Warranty date
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1987    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1988    89    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1989    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1990    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1991    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1992    43    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1993    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1994    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1995    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1996    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1997    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1998    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1999    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2000    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2001    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2002    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2003    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2004    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2005    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2006    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2007    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2008    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2009    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2010    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2011    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2012    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2013    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2014    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2015    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2016    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2017    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2018    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2019    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2020    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2021    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2022    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2023    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2024    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2025    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2026    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2027    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2028    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2029    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2030    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2031    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2032    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2033    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2034    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2035    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2036    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2037    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/2038    100    A#12345    26/12/2014

---------- Post updated at 09:21 AM ---------- Previous update was at 02:26 AM ----------

pls help.......
Last edited by Scrutinizer; 06-22-2012 at 01:22 PM.. Reason: code tags instead of table tags
# 4  
Old 06-21-2012
Bumping up posts or double posting is not permitted in these forums.

Please read the rules, which you agreed to when you registered, if you have not already done so.

You may receive an infraction for this. If so, don't worry, just try to follow the rules more carefully. The infraction will expire in the near future

Thank You.

The UNIX and Linux Forums.
# 5  
Old 06-21-2012
Code:
$ cat transp.awk
NR==1 { print $1, $2, $3, $4, $5, $6, $7, $8, "DATE", $(NF-2), $(NF-1), $NF
        for(N=9; N<(NF-2); N++) D[N]=$N
        next }

{
        for(N=9; N<(NF-2); N++)
                print $1, $2, $3, $4, $5, $6, $7, D[N], $(NF-2), $(NF-1), $NF
}

$ awk -f transp.awk data
Computer_name Location Currency Munufacturer LocalCurrency USD Delivery_tye Purhcase-type DATE PURCHASE_NuMBER Warranty date
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1987 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1988 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1989 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1990 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1991 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1992 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1993 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1994 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1995 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1996 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1997 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1998 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1999 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2000 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2001 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2002 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2003 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2004 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2005 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2006 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2007 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2008 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2009 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2010 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2011 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2012 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2013 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2014 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2015 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2016 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2017 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2018 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2019 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2020 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2021 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2022 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2023 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2024 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2025 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2026 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2027 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2028 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2029 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2030 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2031 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2032 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2033 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2034 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2035 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2036 100 A#12345 26/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1987 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1988 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1989 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1990 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1991 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1992 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1993 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1994 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1995 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1996 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1997 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1998 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1999 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2000 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2001 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2002 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2003 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2004 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2005 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2006 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2007 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2008 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2009 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2010 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2011 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2012 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2013 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2014 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2015 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2016 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2017 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2018 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2019 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2020 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2021 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2022 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2023 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2024 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2025 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2026 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2027 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2028 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2029 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2030 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2031 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2032 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2033 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2034 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2035 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2036 89 SSSS78799 12/12/2014

$

# 6  
Old 06-22-2012
Thanks for ur hlep Corona
Hi Corona,

Thanks a lot for ur help...i will always remember the rules as i was new .. and i read them now..

Regd the issue i think i was not clear..

If u can see input and output i pasted...

The qty is changing for everyday like below,
Code:
Computer_name    Location    Currency     Munufacturer    LocalCurrency    USD    Delivery_tye    Purhcase-type     26/12/1987    26/12/1988    26/12/1989    26/12/1990    26/12/1991     26/12/1992    26/12/1993    26/12/1994    26/12/1995    26/12/1996     26/12/1997    26/12/1998    26/12/1999    26/12/2000    26/12/2001     26/12/2002    26/12/2003    26/12/2004    26/12/2005    26/12/2006     26/12/2007    26/12/2008    26/12/2009    26/12/2010    26/12/2011     26/12/2012    26/12/2013    26/12/2014    26/12/2015    26/12/2016     26/12/2017    26/12/2018    26/12/2019    26/12/2020    26/12/2021     26/12/2022    26/12/2023    26/12/2024    26/12/2025    26/12/2026     26/12/2027    26/12/2028    26/12/2029    26/12/2030    26/12/2031     26/12/2032    26/12/2033    26/12/2034    26/12/2035    26/12/2036     26/12/2037    PURCHASE_NuMBER    Warranty date

Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    100    89    100    100    100    43 100    100    100    100    100    100    100    100    100    100     100    100    100    100    100    100    100    100    100    100     100    100    100    100    100    100    100    100    100    100     100    100    100    100    100    100    100    100    100    100     100    100    100    100    100    A#12345    26/12/2014

Code:
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1987    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1988    89    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1989    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1990    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1991    100    A#12345    26/12/2014
Dell    US    USD    Dell-chiNa    200YEN    100USD    DOOR    ONLINE    26/12/1992    43    A#12345    26/12/2014

i am thinking of like loading all data to a oracle table..and query... do u think it will be posible in i/p output format i posted in previous post...

Thanks again for ur help
Last edited by Scrutinizer; 06-22-2012 at 01:35 PM.. Reason: code tags instead of table tags + formatting
# 7  
Old 06-22-2012
One more try...
Code:
$ cat transp.awk
NR==1 { print $1, $2, $3, $4, $5, $6, $7, $8, "DATE", $(NF-2), $(NF-1), $NF
        for(N=9; N<(NF-2); N++) D[N]=$N
        next }

{
        for(N=9; N<(NF-2); N++)
                print $1, $2, $3, $4, $5, $6, $7, D[N], $N, $(NF-1), $NF
}

$ awk -f transp.awk data
Computer_name Location Currency Munufacturer LocalCurrency USD Delivery_tye Purhcase-type DATE PURCHASE_NuMBER Warranty date
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1987 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1988 89 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1989 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1990 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1991 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1992 43 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1993 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1994 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1995 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1996 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1997 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1998 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/1999 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2000 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2001 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2002 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2003 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2004 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2005 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2006 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2007 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2008 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2009 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2010 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2011 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2012 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2013 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2014 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2015 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2016 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2017 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2018 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2019 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2020 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2021 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2022 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2023 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2024 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2025 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2026 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2027 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2028 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2029 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2030 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2031 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2032 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2033 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2034 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2035 100 A#12345 26/12/2014
Dell US USD Dell-chiNa 200YEN 100USD DOOR 26/12/2036 100 A#12345 26/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1987 456 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1988 45 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1989 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1990 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1991 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1992 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1993 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1994 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1995 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1996 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1997 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1998 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/1999 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2000 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2001 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2002 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2003 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2004 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2005 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2006 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2007 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2008 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2009 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2010 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2011 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2012 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2013 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2014 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2015 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2016 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2017 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2018 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2019 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2020 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2021 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2022 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2023 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2024 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2025 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2026 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2027 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2028 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2029 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2030 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2031 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2032 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2033 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2034 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2035 89 SSSS78799 12/12/2014
Samsung US USD Samsung_india 50000IN 100USD DOOR 26/12/2036 89 SSSS78799 12/12/2014

$
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Transpose columns to row

Gents Using the attached file and using this code. awk '{print substr($0,4,2)}' input.txt | sort -k1n | awk '{a++}END{for(i in a) print i,a}' | sort -k1 > output i got the this output. 00 739 01 807 02 840 03 735 04 782 05 850 06 754 07 295 08 388 09 670 10 669 11 762 (8 Replies)
Discussion started by: jiam912
8 Replies

2. UNIX for Dummies Questions & Answers

Transpose matrix, and rearrange columns common with another file

This is my first post, I apologize if I have broken rules. Some assistance with the following will be very helpful. I have a couple of files, both should ultimately have common columns only, arranged in the same order. This file needs to be transposed, to bring the rows to columns ... (2 Replies)
Discussion started by: abh.kumar
2 Replies

3. Shell Programming and Scripting

To transpose columns + edit in a txt file

Hi, I have a txt file that looks like log2FoldChange Ontology_term 8.50624450251828 GO:0003700,GO:0003707,GO:0005634,GO:0006355,GO:0043401,GO:0003700,GO:0005634,GO:0006355,GO:0008270,GO:0043565 7.03936870356684 GO:0005515,GO:0008080 6.49606183738682 6.49525073909629 GO:0005515... (4 Replies)
Discussion started by: alisrpp
4 Replies

4. Shell Programming and Scripting

Transpose whole file and specific columns

Hi, I have a file like this a b c d e f g h i j k l Case1: I want to transpose the whole file Output1 a d g j b e h k c f i l Case2 Transpose a specific column - Say 3rd (6 Replies)
Discussion started by: jacobs.smith
6 Replies

5. UNIX for Dummies Questions & Answers

Removing columns from a text file that do not have any values in second and third columns

I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns: 4 0.04972604 KLHL28 4 0.0497332 CSTB 4 0.04979822 AIF1 4 0.04983331 DECR2 4 0.04990344 KATNB1 4 4 4 4 How can I remove the trailing... (3 Replies)
Discussion started by: evelibertine
3 Replies

6. Shell Programming and Scripting

Transpose a text file.

Hello, I have a text file which is like a matrix m rows and n columns. Now I want to convert it into n rows and m columns. Thanks for hint. (1 Reply)
Discussion started by: zhshqzyc
1 Replies

7. Shell Programming and Scripting

transpose rows to columns

Any tips on how I can awk the input data to display the desired output per below? Thanking you in advance. input test data: 2 2010-02-16 10:00:00 111111111111 bytes 99999999999 bytes 90% 4 2010-02-16 12:00:00 333333333333 bytes 77777777777 bytes 88% 5 2010-02-16 11:00:00... (4 Replies)
Discussion started by: ux4me
4 Replies

8. Shell Programming and Scripting

Transpose columns to Rows

I have a data A 1 B 2 C 3 D 4 E 5 i would like to change the data A B C D E 1 2 3 4 5 Pls suggest how we can do it in UNIX. Start using code tags, thanks. Also start reading your PM's you get from Mods as well read the Forum Rules. That might not do any harm. (24 Replies)
Discussion started by: aravindj80
24 Replies

9. Shell Programming and Scripting

Rows to Columns - File Transpose

Hi I have an input file and I want to transpose it but I need to take care that if any field is missing for a record it should be popoulated with space for that field - using a shell script INFILE ---------- emp=1 sal=2 loc=abc emp=2 sal=21 sal=22 loc=xyz emp=5 loc=abc OUTFILE... (10 Replies)
Discussion started by: 46019
10 Replies

10. Shell Programming and Scripting

Transpose an entire text file

Hello all, I want to transpose the rows of a file to the columns (every characters include spaces), i.e.: input: abcdefg 123 456 output: a1 b2 c3 d e4 f5 g6 I wrote a script: #!/bin/csh -f (15 Replies)
Discussion started by: heavenfish
15 Replies
Login or Register to Ask a Question