Script Output


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Script Output
# 1  
Old 01-20-2014
Script Output

hi Gurus,

Need help in getting the desired output.

The source file can have multiple occurrences of a plan. Need to get distinct instance along with other columns.

Please refer to attachment.

INPUT

Code:
P1,L1,XX,1,S1,Standard
P2,L2,XX,2,S2,Standard
P3,L3,XX,3,S3,Volume Discount
P3,L3,XX,3,S3,Volume Discount
P3,L3,XX,3,S3,Volume Discount
P4,L4,XX,4,S4,Standard


OUTPUT
Code:
P1,usd,1,1,0,Standard,L1
P2,usd,2,1,0,Standard,L2
P3,usd,3,1,0,Volume Discount,L3
P4,usd,4,1,0,Standard,L4


Last edited by Scrutinizer; 01-20-2014 at 02:33 PM.. Reason: code tags
# 2  
Old 01-20-2014
Something like this?
Code:
awk '!A[$0]++{print $1,"usd",$4,1,0,$6,$2}' FS=, OFS=, file

This User Gave Thanks to Scrutinizer For This Post:
# 3  
Old 01-20-2014
is that you just need to remove multiple occurrences or even you need to format your output ? to what i see in your output , your input has undergone a format change too ?

Just to remove duplicates you can use
Code:
awk '!x[$0]++' file

Solution provide by @Scrutinizer is perfect for format change and duplicates removal

Thanks
# 4  
Old 01-20-2014
Quote:
hi Gurus,

Need help in getting the desired output.

The source file can have multiple occurrences of a plan. Need to get distinct instance along with other columns.

Please refer to attachment.

INPUT


Code:
P1,L1,XX,1,S1,StandardP2,L2,XX,2,S2,StandardP3,L3,XX,3,S3,Volume DiscountP3,L3,XX,3,S3,Volume DiscountP3,L3,XX,3,S3,Volume DiscountP4,L4,XX,4,S4,Standard


OUTPUT


Code:
P1,usd,1,1,0,Standard,L1P2,usd,2,1,0,Standard,L2P3,usd,3,1,0,Volume Discount,L3P4,usd,4,1,0,Standard,L4
Hello,

One more approach for same.

Code:
awk -F"," ' {$(NF+1)=$2} {$2="usd"} {$3=$4} {$4=1} {$5=0} !a[$0]++' OFS=, file_name


Output will be as follows.

Code:
P1,usd,1,1,0,Standard,L1
P2,usd,2,1,0,Standard,L2
P3,usd,3,1,0,Volume Discount,L3
P4,usd,4,1,0,Standard,L4



Thanks,
R. Singh
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Shell script to call and sort awk script and output

I'm trying to create a shell script that takes a awk script that I wrote and a filename as an argument. I was able to get that done but I'm having trouble figuring out how to keep the header of the output at the top but sort the rest of the rows alphabetically. This is what I have now but it is... (1 Reply)
Discussion started by: Eric7giants
1 Replies

2. Shell Programming and Scripting

A shell script to run a script which don't get terminated and send a pattern from the output by mail

Hi Guys, I am very new to shell script and I need your help here to write a script. Actually, I have a script abc.sh which don't get terminated itself. So I need to design a script to run this script, save the output to a file, search for a given string in the output and if it exists send those... (11 Replies)
Discussion started by: Sambit Sahu
11 Replies

3. Shell Programming and Scripting

Shell Script function to use script name for log file output

Hi Team - I"m very new to Shell Scripting so I have a rather novice question. My forte is Windows Batch Scripting so I was just wondering what the Shell Script equivalent is to the DOS command %~n? %~n is a DOS variable that dispayed the script name. For instance (in DOS): REM... (11 Replies)
Discussion started by: SIMMS7400
11 Replies

4. Shell Programming and Scripting

Need output of script on screen and file with correct return status of the called script.

Hi, I am trying to capture logs of the script in the file as well as on the screen. I have used exec and tee command for this. While using exec command I am getting the correct output in the file but, script output is not getting displayed on the screen as it get executed. Below is my sample... (14 Replies)
Discussion started by: Prathmesh
14 Replies

5. Shell Programming and Scripting

Redirect script output to a file and mail the output

Hi Guys, I want to redirect the output of 3 scripts to a file and then mail the output of those three scripts. I used below but it is not working: OFILE=/home/home1/report1 echo "report1 details" > $OFILE =/home/home1/1.sh > $OFILE echo... (7 Replies)
Discussion started by: Vivekit82
7 Replies

6. Shell Programming and Scripting

script to mail monitoring output if required or redirect output to log file

Below script perfectly works, giving below mail output. BUT, I want to make the script mail only if there are any D-Defined/T-Transition/B-Broken State WPARs and also to copy the output generated during monitoring to a temporary log file, which gets cleaned up every week. Need suggestions. ... (4 Replies)
Discussion started by: aix_admin_007
4 Replies

7. Shell Programming and Scripting

Need bash script to ping the servers and rename the output file each time the script is ran

HI, I have a file serverlist in that all host names are placed. i have written a small script #./testping #! /bin/bash for i in `cat serverlist` do ping $i >> output.txt done so now it creates a file output.txt till here fine.. now each time i run this script the output file... (4 Replies)
Discussion started by: madhudeva
4 Replies

8. Shell Programming and Scripting

Awk script to run a sql and print the output to an output file

Hi All, I have around 900 Select Sql's which I would like to run in an awk script and print the output of those sql's in an txt file. Can you anyone pls let me know how do I do it and execute the awk script? Thanks. (4 Replies)
Discussion started by: adept
4 Replies

9. Red Hat

Cron task output is 0, script output is OK

I have the following cron task set to run every 15 minutes to ascertain how many users are in the system and append the result to the log. /home/pronto/cus/whoisinc >> /home/pronto/cus/whoisin.log This is the whoisinc script date +"%d-%m-%Y,%k:%M,Pronto Users,`prowho -s | grep -v... (1 Reply)
Discussion started by: scottm
1 Replies

10. Shell Programming and Scripting

Running a script in system() call and want the script's output

Hi All, I have a script(sample.sh) displaying the output of "dd" command. Now i am using this script in system() call as, system("sh sample.sh") in an application file. I want the output of system("sh sample.sh") in the application file itself. How can i get it? Many thnaks.... (9 Replies)
Discussion started by: amio
9 Replies
Login or Register to Ask a Question