small script correction


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting small script correction
# 1  
Old 12-13-2010
small script correction

input
Code:
cz1	87942437    	87952030    	M_001144992	0   	+   	87942537	87949664    	0   	3   	710,114,2506,   0,2725,7087,

script
Code:
awk '{
 n11 = split($11, t11, ",")
 n12 = split($12, t12, ",")
 for (i = 0; ++i < n11;) {
       s12 = $2 + t12[i]
   print $4"_xon"i, "\t",$4"_xon"i,"\t", $1, "\t",  $6, "\t", s12, "\t", s12 + t11[i], "\t",$7,"\t"$8,"\t"$10,"\t"$11,"\t",$12
       }
 }' input

output
Code:
M_001144992_xon1 	 M_001144992_xon1 	 cz1 	 + 	 87942437 	 87943147 	 87942537 	87949664 	3 	710,114,2506, 	 0,2725,7087,
M_001144992_xon2 	 M_001144992_xon2 	 cz1 	 + 	 87945162 	 87945276 	 87942537 	87949664 	3 	710,114,2506, 	 0,2725,7087,
M_001144992_xon3 	 M_001144992_xon3 	 cz1 	 + 	 87949524 	 87952030 	 87942537 	87949664 	3 	710,114,2506, 	 0,2725,7087,

Needed output
output
Code:
M_001144992_xon1 	 M_001144992_xon1 	 cz1 	 + 	 87942437 	 87943147 	 87942537 	87949664 	1 	710,	 0,
M_001144992_xon2 	 M_001144992_xon2 	 cz1 	 + 	 87945162 	 87945276 	 87942537 	87949664 	1 	114, 	 2725,
M_001144992_xon3 	 M_001144992_xon3 	 cz1 	 + 	 87949524 	 87952030 	 87942537 	87949664 	1 	2506, 	 7087,

# 2  
Old 12-13-2010
Try:
Code:
awk '{
 n11 = split($11, t11, ",")
 n12 = split($12, t12, ",")
 for (i = 1; i<n11; i++) {
       s12 = $2 + t12[i]
   print $4"_xon"i, "\t",$4"_Exon"i,"\t", $1, "\t",  $6, "\t", s12, "\t", s12 + t11[i], "\t",$7,"\t"$8,"\t"$10,"\t"t11[i],"\t",t12[i]
       }
 }' input

This User Gave Thanks to Scrutinizer For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help to understand this small script

Hi Guys, I need to understand below scipt:- -bash-3.00$ cat rsync-copy.ksh #!/usr/5bin/ksh batch <<%EOF% echo "/usr/local/bin/rsync --rsync-path=/usr/local/bin/rsync -a --stats /usr/openv/ /OpenvBCK" > openv.LOG # CG /usr/local/bin/rsync ... (6 Replies)
Discussion started by: manalisharmabe
6 Replies

2. Shell Programming and Scripting

Perl Script date correction

Need assistance for the below script. Little details: based on the hours specified it calculates future or past date,time. This script works absolutely great . But at one point when i wante specify future date with hours at 1682 hours ...1 hours skips .Dont know why the calculation misses 1... (2 Replies)
Discussion started by: ajayram_arya
2 Replies

3. UNIX for Dummies Questions & Answers

need help with small script

Hi I have the below file Name=abc Yr=2011 Mon=05 My script should be in such a way that whenever I run it then Month should increment by 1 and if the month is 12 then when I run the script then year should incremented by 1 and month Should become 01(I.e jan) Thanks for the help in... (6 Replies)
Discussion started by: kishu
6 Replies

4. UNIX for Dummies Questions & Answers

A small script required!!

Hi All, I am using korn shell sun solaris 10 What i need is i have to grep one file and if there are any finding then i have set one flag. otherwise continue Please help Regards Arun (9 Replies)
Discussion started by: annyarun
9 Replies

5. AIX

Need help in a small script

Hello all, could somebody help..? I have following 6 files (with white spaces in their names) This is file This is file1 This is file2 This is file3 This is file4 This is file5 This is file6 I tried to run the below script, and it did not give me desired ouput.. $ for i in `ls -1` >... (7 Replies)
Discussion started by: gsabarinath
7 Replies

6. Shell Programming and Scripting

need a small script

Hello all, i have a batmail process running on my machine(java process). i just need a script we should detect whether the batchnail is running or not.If not it should restart it. Can anyone assist me on this? (1 Reply)
Discussion started by: Rayzone
1 Replies

7. Shell Programming and Scripting

small script help

#!/bin/ksh for i in *.log* do ls $i|sed 's/\.log$//g' | while read file do echo "file $file is Running" >> lls.txt echo "***************">> lls.txt done done ------------------------------------------------------------------ the output is : file AdapterCCProvisioningInterface... (9 Replies)
Discussion started by: ali560045
9 Replies

8. Shell Programming and Scripting

small script

Hi, I am new to unix shell scripting. I just want a little script to check the no. of processes are equal to 8, then echo a successful message otherwise echo a unsuccessful message. Please help. Thanks. (3 Replies)
Discussion started by: everurs789
3 Replies

9. Shell Programming and Scripting

small script help

here is a small script: if ; then echo please enter an argument fi if [ "$1" = "tom"; then a=$1 echo $a fi here is my question. if the script name is j.sh and I run it : j.sh from shell prompt: without a parameter: it prints please enter an argument but if I go with . j.sh (current... (1 Reply)
Discussion started by: rkl1
1 Replies

10. Shell Programming and Scripting

Need help in a small script

Hi all, I have a file of the following format - EXPRPT:SCN:1.1706E+10:SEQ_START:121652:SEQ_END:121664:0 ( This file name is variable and changes daily) Now in the same directory I have another set of files of the format - EXPRPT.log.0001.0000121669 Now what I am trying to do is to ... (2 Replies)
Discussion started by: super_duper_guy
2 Replies
Login or Register to Ask a Question