shell scripting


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting shell scripting
# 1  
Old 11-03-2010
shell scripting

Hai,
How to remove the repeated 'Chr's in different sequences. In the given example, Chr11 is repeated in two samples with the same number i.e. 100949523. How to remove one of the entry in any of the samples and to give the range for each Chr which is -20 for minimum range value and +120 for maximum range value. For Chr19 it will be displayed as
Chr19:52245903-5224546043 in output file (i.e., for Chr19, 52245923 given. So -20 from this value is min.range and +120 is max. range). No importance for the sign (+ or -before the number not taking into consideration) in the input data. The final output also given for easy understanding.
Input file:
Code:
sample1:1:1:1058:8130#0 5 830
Chr19 +52245923 1
Chr17 +69679873 1
Chr23 +52121254 1
Chr11 +100949523 1
Chr8 +28333267 1
sample1:1:1:1060:13599#0 1 1
Chr11 +100949523 1
Chr12 -19596251 2
sample1:1:1:1067:10266#0 5 284
Chr18 -52922341 0
Chr28 -25960086 0
Chr20 -19916978 0
Chr13 +3874326 0

Output is:
[code]Chr19:52245903-52246043
Chr17:69679853-69679993
Chr23:52121234-52121374
Chr11:100949503-100949643
Chr8:28333247-28333387
Chr12:19596231-19596371
Chr18:52922321-52922461
Chr28:25960066-25960206
Chr20:19916958-19917098
Chr13:3874306-3874446

Last edited by hravisankar; 11-03-2010 at 08:16 PM.. Reason: Code tags, PLEASE...
# 2  
Old 11-03-2010
If order is not important:

Code:
$ awk ' $0 !~ "^sample" { val[$1]=$2<0?-$2:$2; } END { for(i in val) print i":"val[i]-20"-"val[i]+120 }' inputfile
Chr28:25960066-25960206
Chr19:52245903-52246043
Chr8:28333247-28333387
Chr20:19916958-19917098
Chr11:100949503-100949643
Chr12:19596231-19596371
Chr13:3874306-3874446
Chr23:52121234-52121374
Chr17:69679853-69679993
Chr18:52922321-52922461

This User Gave Thanks to Chubler_XL For This Post:
# 3  
Old 11-04-2010
By the original order
Code:
awk '/^Chr/&&!a[$1]++ {sub(/[+-]/,"");print $1":"$2-20"-"$2+120}' infile

These 2 Users Gave Thanks to rdcwayx For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Shell script to read lines in a text file and filter user data Shell Programming and Scripting

sxsaaas (3 Replies)
Discussion started by: VikrantD
3 Replies

2. Shell Programming and Scripting

help me in Shell Scripting

Hi there please have a look at the code..i want to create Using a named pipe. Run a find in the background starting in the working directory While this is happening wait for input from the user to ask him which file to find. If the user does not enter any data in 10 seconds ask the user again.... (1 Reply)
Discussion started by: kattak1511
1 Replies

3. Shell Programming and Scripting

Shell scripting

Hi, if in a network there are lots of PCs connected with either windows or linux as operating system.Then what will be the shell script for the same and also if the PC has linux in it then we have to find if it is occupied or unoccupied. If the PC has windows in it then we have to find if it is... (6 Replies)
Discussion started by: akansha singh
6 Replies

4. UNIX for Dummies Questions & Answers

Shell Scripting

Hey I have a data in the file named as outputFile.txt. The data is in the format 123456,12345678912345,400,09/09/09,INACTIVE. I want this output without commas ie 12345612345678912345400090909INACTIVE. Please tell me what to do and clear explain all the terms, as I am new to it. (6 Replies)
Discussion started by: sampandey31
6 Replies

5. Web Development

Perl scripting or shell scripting?

i am going to study any one of the scripting languages mentioned above(shell 0r perl scripting) . Which is having more scope for a fresher? (1 Reply)
Discussion started by: Anna Hussie
1 Replies

6. What is on Your Mind?

Shell Scripting vs Perl scripting

Gents, I have been working in a Solaris/Unix environment for about 9 months. I took some linux classses online before getting the job. But, I am not very good at scripting. I want to learn how to script. Do you think that I should start with Shell scripting or Perl? I wanted to continue with... (2 Replies)
Discussion started by: Pouchie1
2 Replies

7. Android

Android Scripting Environment: Shell Scripting and Android

I just upgraded to Android 2.2 from 2.1. The GPS issue that was troublesome in 2.1 seems to have been fixed. Some of web browsing seems faster, but it could just be my connection is better today ;) Flash works in some browsers but not very good and it is too slow for Flash apps designed for... (0 Replies)
Discussion started by: Neo
0 Replies

8. What is on Your Mind?

Shell scripting vs Perl scripting

Hi all, I would like to start developping some good scripting skills. Do you think it would be best to start with shell scripting or Perl? I already got a fundation, really basics, in perl. but I am wondering what would be best to be good at first. Can you please help me determine which one to... (14 Replies)
Discussion started by: Pouchie1
14 Replies

9. Shell Programming and Scripting

Call Shell scripting from Perl Scripting.

Hi How to call a shell scripting through a Perl scripting? Actually I need some value from Shell scripting and passes in the Perl scripting. So how can i do this? (2 Replies)
Discussion started by: anupdas
2 Replies

10. Shell Programming and Scripting

difference between AIX shell scripting and Unix shell scripting.

please give the difference between AIX shell scripting and Unix shell scripting. (2 Replies)
Discussion started by: haroonec
2 Replies
Login or Register to Ask a Question