Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Sample output
Top Forums Shell Programming and Scripting Sample output Post 302884607 by Akshay Hegde on Tuesday 21st of January 2014 05:27:32 AM
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 06:36 AM.. Reason: Formatting....
 

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

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

LEARN ABOUT OSF1

xmaddtabgroup

XmAddTabGroup(3X)														 XmAddTabGroup(3X)

NAME

       XmAddTabGroup - A function that adds a manager or a primitive widget to the list of tab groups

SYNOPSIS

       #include <Xm/Xm.h>

       void XmAddTabGroup (tab_group)
	       Widget tab_group;

DESCRIPTION

       This  function  is  obsolete and its behavior is replaced by setting XmNnavigationType to XmEXCLUSIVE_TAB_GROUP. When using the keyboard to
       traverse through a widget hierarchy, primitive or manager widgets are grouped together into what are known as tab groups.  Any  manager	or
       primitive  widget  can be a tab group.  Within a tab group, move the focus to the next widget within the tab group by using the arrow keys.
       To move to another tab group, use KNextField or KPrevField.

       Tab groups are ordinarily specified by the XmNnavigationType resource. XmAddTabGroup is called to control the order  of	traversal  of  tab
       groups.	The widget specified by tab_group is appended to the list of tab groups to be traversed, and the widget's XmNnavigationType is set
       to XmEXCLUSIVE_TAB_GROUP.  Specifies the manager or primitive widget ID.

SEE ALSO

       XmManager(3X), XmGetTabGroup(3X), XmPrimitive(3X), XmRemoveTabGroup(3X)

																 XmAddTabGroup(3X)
All times are GMT -4. The time now is 06:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy