|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
finding values in between
Post 302323198 by phil_heath on Friday 5th of June 2009 05:28:26 PM
06-05-2009
finding values in between
Hi,
I have been trying to find someone with this similar problem but I was out of luck.
So I have a file that has two columns that look like this (for example):
10 20
40 50
45 60
90 130
So column 1 is start and column 2 is stop but what I want to do is find whats not represented by the start and stop. Is there a way to print out whats not part of the start to stop.
So I want the file to look like this:
1 9
22 39
61 89
So basically it prints out whats in between the rows that do not overlap.
thanks
I have been trying to find someone with this similar problem but I was out of luck.
So I have a file that has two columns that look like this (for example):
10 20
40 50
45 60
90 130
So column 1 is start and column 2 is stop but what I want to do is find whats not represented by the start and stop. Is there a way to print out whats not part of the start to stop.
So I want the file to look like this:
1 9
22 39
61 89
So basically it prints out whats in between the rows that do not overlap.
thanks
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi everyone,
Can anyone guide me on how to search through a huge file and look on specific column and if it finds a discrepancy on that column that does not conform to the specified criteria,
ie
(1) Numeric and (3) alpha chars F123 or G333..etc, etc!
then idientify it and redirect... (3 Replies)
Discussion started by: Gerry405
3 Replies
2. UNIX for Dummies Questions & Answers
I have a list of people in a usage log and need to print the names and phone numbers of people with over 500 logins. I'd also like to display these names alphabetically.
I have their total logins set to a variable named total.
So far, I have very little in my awk script to do this:
FS=":"... (4 Replies)
Discussion started by: doubleminus
4 Replies
3. Shell Programming and Scripting
Hi All
I have a file.Below are few records of the file.
sample.txt
CPS,ES,843232910001,ESF81462,W N LINDSAY LTD,01674840629,09-FEB-2009,23-FEB-2009,CDR735,ALL CALLS,01674840629
CPS,ES,843232670001,ESF81462,W N LINDSAY LTD,01674840629,09-FEB-2009,23-FEB-2009,CDR734,ALL... (2 Replies)
Discussion started by: king007
2 Replies
4. Shell Programming and Scripting
Hi I am posting here for the first time. I am trying to write a script that reads a data file and tries to determine if any absolute values that are above 0.5
I was thinking it ought to be possible to do this with awk somehow. Are there any suggestions before I start reinventing the wheel?
... (4 Replies)
Discussion started by: jackygrahamez
4 Replies
5. Programming
I have an array containing distances in ascending order, for example:
distances = 100 120 150 170 200 280 300 ....
I have a number, let's say v = 170 and a variation value, let's say var = 100 . I want to return the array indexes for which the distances cover the range (v - var) to (v +... (3 Replies)
Discussion started by: kristinu
3 Replies
6. Shell Programming and Scripting
I have an array XOFFS of size N. I have VDISTMIN and VDISTMAX.
I want to find the beginning and and index in XOFFS such that values are within
Example
Let XOFFS = (10 20 30 40 50)
If VDISTMIN = -20 and VDISTMAX = 20
Then ISTR = 1 and IEND = 2 as XOFFS through XOFFS fall within the... (2 Replies)
Discussion started by: kristinu
2 Replies
7. Shell Programming and Scripting
I have an array
X = ( -100 -90 -80 -70 -60 -50 -40 30 40 50 60 70 80 90 100 )
I want to find the place where values change from negative to positive. (8 Replies)
Discussion started by: kristinu
8 Replies
8. UNIX for Advanced & Expert Users
I'm doing a little work on assessing and improving server stability. As part of that, we're reviewing the contents of /proc/slabinfo. We see that sometimes a certain metric-- say, buffer_head-- spike prior to server instability. We're interested in learning what contributes to that as we trace... (0 Replies)
Discussion started by: treesloth
0 Replies
9. Shell Programming and Scripting
Hi,
I have a hash with unique keys associated with some data.
my %FINALcontigs = (
'mira_rep_c765:119reads**', 'ctctactggaagactgac',
'mira_rep_c7454:54reads**', 'atggatactgcgctgttgctaactactgga',
'mira_rep_c6803:12reads**', 'atcgactggatgcagggttgtggtttcta',
... (2 Replies)
Discussion started by: jdilts
2 Replies
10. Shell Programming and Scripting
Hi there,
I have 2 files in following format
cat file_1
Storage Group Name: aaaa
HBA UID SP Name SPPort
------- ------- ------
0 21
Storage Group Name: bbbb
HBA UID... (2 Replies)
Discussion started by: jpkumar10
2 Replies
LEARN ABOUT DEBIAN
colrm
COLRM(1) BSD General Commands Manual COLRM(1) NAME
colrm -- remove columns from a file SYNOPSIS
colrm [start [stop]] DESCRIPTION
The colrm utility removes selected columns from the lines of a file. A column is defined as a single character in a line. Input is read from the standard input. Output is written to the standard output. If only the start column is specified, columns numbered less than the start column will be written. If both start and stop columns are spec- ified, columns numbered less than the start column or greater than the stop column will be written. Column numbering starts with one, not zero. Tab characters increment the column count to the next multiple of eight. Backspace characters decrement the column count by one. ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of colrm as described in environ(7). EXIT STATUS
The colrm utility exits 0 on success, and >0 if an error occurs. SEE ALSO
awk(1), column(1), cut(1), paste(1) HISTORY
The colrm command appeared in 3.0BSD. BSD
August 4, 2004 BSD