Visit Our UNIX and Linux User Community


Sample output


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Sample output
# 1  
Old 01-21-2014
Sample output

hi gurus ,

i want the command to get the output in the desired format .

basically to convert columns to rows.
please refer to the attachment.
# 2  
Old 01-21-2014
If your input is tab separated text file then try, if xls then convert it to tab and then use

Code:
$ awk 'NR==1{for(i=5;i<=NF;i++){gsub(/\(|\)/,OFS,$i);A[i]=$i}}NR>1{s=$1 OFS $2 OFS $3 OFS $4;for(i=5;i<=NF;i++)print s,A[i],$3,$4,$i}' FS='\t' OFS='\t' file

Code:
S1    P1    1          DISTI   USD         1        265.2
S1    P1    1          MSRP    USD         1        312
S1    P1    1          DIST    EUR         1        195.5
S1    P1    1          MSRP    EUR         1        230
.....
.....
S2    P2    3    4     DISTI   GBP        3    4    648.55
S2    P2    3    4     MSRP    GBP        3    4    763


Last edited by Akshay Hegde; 01-21-2014 at 07:36 AM.. Reason: Formatting....
# 3  
Old 01-21-2014
Thanks for the reply .. i just need to tweakur your query .. can u plz explain a bit how looping works in your command
# 4  
Old 01-21-2014
Duplicate here

Urgent ! | Unix Linux Forums | Shell Programming and Scripting

I will not answer you, here all are volunteer, none of them get paid if they answer you. but still they are spending their time to help others try to understand. You are member since 2009, what you have tried so far ? what you could learn from forum ?

If you have enough forum bits post in Emergency UNIX and Linux Support Forum, or else wait for sometime.

Previous Thread | Next Thread
Test Your Knowledge in Computers #228
Difficulty: Easy
According to NetMarketShare, in September 2019 Linux had a 5% global market share of the desktop / laptop computer market.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sample Script

Below is the code. Its the 1st line of a file. How can I remove the bracket and display like below. 123 web int 1 09:30:45 2013 I dont want to use AWK or SED or PERL. I need to use only the bash shell scripting commands to do it. (3 Replies)
Discussion started by: ghosh_tanmoy
3 Replies

2. Shell Programming and Scripting

Programm not working on all sample

Hi all I am using following code and input to duplicate entries till next row but out is cutting some words in this sample can anybody check on his system is there any error? awk ' { if($2 !~ /^ *$/) { a=substr($0,length($1)+1,index($0,$NF)-length($NF)); b=$NF; } print $1, a, b } ' file... (1 Reply)
Discussion started by: Priyanka Chopra
1 Replies

3. Shell Programming and Scripting

AWK sample variance

I would like to calculate 1/n In awk, I wrote the following line for the sigma summation: { summ+=($1-average)^2 } Full code: BEGIN { Print "This script calculate error estimates"; sum=0 } { sum+=$1; n++ } END { average = sum/n } BEGIN { summ=0 } { summ+=($1-average)^2 } END { print... (8 Replies)
Discussion started by: chrisjorg
8 Replies

4. UNIX for Advanced & Expert Users

Can someone help me with creating RPM sample i need ?

i know there are tons n tons of documentation out there to help me out to understand this.. but wen i read it, its to confusing for me.. i would really wish a kind hearted person on this forum can come out with a sample spec file for the example steps that i need for the RPM. This will make me... (0 Replies)
Discussion started by: bladez
0 Replies

5. Shell Programming and Scripting

Sample Practical

Hello Today I had a beautiful test to write some commands using Ubuntu, now I want to make sure of my answers to be reassured, if I had a mistake please correct me List all files details under ubuntu Desktop. my answer: cd Desktop |ls -l Navigate to your Desktop directory and... (7 Replies)
Discussion started by: S4K
7 Replies

6. UNIX for Dummies Questions & Answers

Sample scripts

Hi All' I'm a newbe, and just is started to learn unix. Where can I find a complete sample scripts? I looking for a sample scripts which log in at another unix host and and execute another script server side. Any input welcome (5 Replies)
Discussion started by: ioniCoder
5 Replies

7. Shell Programming and Scripting

How do I do this: -$: sample.sh <INPUT>

I apologize for the confusing title .. What I want to do is write a script that pulls specific input from the command line (after the script name) rather than from within the script. Example: -$: howfarbetween.sh Montreal Chicago Where the script would run based on the inputs of the two... (3 Replies)
Discussion started by: jmvbxx
3 Replies

8. Programming

Help need a sample program

Hi all, Can some one provide me a sample program which measures the performance (both latency and throughput) of TCP and UDP protocol (2 Replies)
Discussion started by: magnetpest2k7
2 Replies

9. Shell Programming and Scripting

Sample FOR loop question

This sample script should obtain a list of files in my home directory: #!/bin/bash # Manipulate files and copy to my home directory # for FILE in $HOME/.bash* do cp $FILE ${HOME}/public_html chmod a+r ${HOME}/public_html/${FILE} done Unfortunately it only produces an error: ... (4 Replies)
Discussion started by: kp400sf
4 Replies

10. Shell Programming and Scripting

Sorting problem "sort -k 16,29 sample.txt > output.txt"

Hi all, Iam trying to sort the contents of the file based on the position of the file. Example: $cat sample.txt 0101020060731 ## Header record 1c1 Berger Awc ANP20070201301 4000.50 1c2 Bose W G ANP20070201609 6000.70 1c2 Andy CK ANP20070201230 28000.00... (3 Replies)
Discussion started by: ganapati
3 Replies

Featured Tech Videos