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
XmTabListInsertTabs(library call)										 XmTabListInsertTabs(library call)

NAME
XmTabListInsertTabs -- A convenience function that inserts tabs into a tab list SYNOPSIS
#include <Xm/Xm.h> XmTabList XmTabListInsertTabs( XmTabList oldlist, XmTab *tabs, Cardinal tab_count, int position); DESCRIPTION
XmTabListInsertTabs creates a new tab list that includes the tabs in oldlist. This function copies specified tabs to the tab list at the given position. The first tab_count tabs of the tabs array are added to the tab list. If oldlist is NULL, XmTabListInsertTabs creates a new tab list containing only the tabs specified. oldlist Specifies the tab list to add the tabs to. The function deallocates oldlist after extracting the required information. tabs Specifies a pointer to the tabs to be added to the tab list. It is the caller's responsibility to free the tabs in tabs by using XmTabFree. tab_count Specifies the number of tabs in tabs. position Specifies the position of the first new tab in the tab list. A value of 0 (zero) makes the first new tab the first tab in the tab list, a value of 1 makes it the second tab, and so on. If position is greater than the number of tabs in oldlist, then the tabs will be inserted at the end. If position is negative, the count will be backwards from the end. A value of -1 makes the first new tab the last tab, and so on. RETURN
If tabs is NULL or tab_count is 0 (zero), this function returns oldlist. Otherwise, it returns a new tab list. The function allocates space to hold the returned tab list. The application is responsible for managing the allocated space. The application can recover the allocated space by calling XmTabListFree. RELATED
XmTabList(3) and XmTabListFree(3). XmTabListInsertTabs(library call)
All times are GMT -4. The time now is 09:24 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy