12-23-2010
Need help filling in ranges
I have a list of about 200,000 lines in a text file that look like this:
1 1 120
1 80 200
1 150 270
5 50 170
5 100 220
5 300 420
The first column is an identifier, the next 2 columns are a range (always 120 value range)
I'm trying fill in the values of those ranges, and remove duplicate values (the ranges overlap in some cases) and a final format that looks like this:
1:1
1:2
1:3
...
1:270
5:50
5:51
5:52
...
5:420
Thanks for any help!
10 More Discussions You Might Find Interesting
1. HP-UX
Hi ,
I am using adduser in hp-ux to create users in Hp-ux.
i would like to know what are the valid values for uids and gids in hp-ux
what are the rannges for the valid uids .
How to check what are the used uids in Hp-ux .
Thanks
Narendra babu C (7 Replies)
Discussion started by: naren_chella
7 Replies
2. Shell Programming and Scripting
Hi,
Please anyone help to achive this using perl or unix scripting .
This is date in my table 20090224,based on the date need to check the files,If file exist for that date then increment by 1 for that date and check till max date 'i.e.20090301 and push those files .
files1_20090224... (2 Replies)
Discussion started by: akil
2 Replies
3. Shell Programming and Scripting
Hi All,
Is there a way to save a range in variable for later printing?
for example write somthing like this:
awk '
/pattern1/,/pattern2/{f=range}
/pattern3/{print f}
'
I don't know excatly what "range" could be but is there a way to do this? (8 Replies)
Discussion started by: ghoda2_10
8 Replies
4. HP-UX
We have recently merged 2 old systems onto a newer Itanium platform. As part of this work we merged the password files and assigned new UID's beginning from 1000. I have a user add script that admins can use to add a user, however this assigns the next available UIB (in the low 100's) rather than... (3 Replies)
Discussion started by: fulhamfcboy
3 Replies
5. Shell Programming and Scripting
I have a problem that I cant figure out what to do in this function i need it to count multiple ranges like 0 10, 5 10, 1 100. I know that my counter needs to be outside the function and that it needs to be set to the lowest numbered positional parameter but thats were I am having trouble if... (6 Replies)
Discussion started by: Emin_Em
6 Replies
6. UNIX for Dummies Questions & Answers
Good day to everyone!
So, let's start :)
I have a file with a numbers in some ranges
for example:
1 10
49 72
...
and this file need to transform to:
1
2
3
4 (14 Replies)
Discussion started by: shizik
14 Replies
7. Shell Programming and Scripting
Hi,
I have two files
file1 chr1_22450_22500
chr2_12300_12350
chr1_34500_34550
file2 11000_13000
15000_19000
33000_44000
If the file 1 ranges fall between file2 ranges then assign the value of file2 in column 2 to file1
output:
chr2_12300_12350 11000_13000
chr1_34500_34550 ... (7 Replies)
Discussion started by: Diya123
7 Replies
8. IP Networking
Greetings folks,
I have a rather lengthy list of banned IP ranges in iptables. Initially it was constructed as a rather ad-hoc affair, then later I discovered a site which had IP Block By Country lists, and imported several into iptables.
If possible, I'd like to be able to verify if the list... (0 Replies)
Discussion started by: putter1900
0 Replies
9. Shell Programming and Scripting
Hi, I have a list.txt file with number ranges and want to print/save new all.txt file with all the numbers and between the numbers.
== list.txt ==
65936
65938
65942 && 65943
65945 ... (7 Replies)
Discussion started by: AK47
7 Replies
10. Shell Programming and Scripting
Dear Unix gurus,
I have sample data organised like this and containing 6 columns (with headers):
label c2 c3 c4 c5 c6
where c2 to c6 are numeric values in columns c2 to 6.
I am trying to create a simple output in a new file containing 3 columns:
label max(c2 c3) max(c4 c5 c6)
... (4 Replies)
Discussion started by: ksennin
4 Replies
LEARN ABOUT PHP
ps_makespotcolor
PS_MAKESPOTCOLOR(3) 1 PS_MAKESPOTCOLOR(3)
ps_makespotcolor - Create spot color
SYNOPSIS
int ps_makespotcolor (resource $psdoc, string $name, [int $reserved])
DESCRIPTION
Creates a spot color from the current fill color. The fill color must be defined in rgb, cmyk or gray colorspace. The spot color name can
be an arbitrary name. A spot color can be set as any color with ps_setcolor(3). When the document is not printed but displayed by an post-
script viewer the given color in the specified color space is use.
PARAMETERS
o $psdoc
- Resource identifier of the postscript file as returned by ps_new(3).
o $name
- Name of the spot color, e.g. Pantone 5565.
RETURN VALUES
The id of the new spot color or 0 in case of an error.
EXAMPLES
Example #1
Creating and using a spot color
<?php
$ps = ps_new();
if (!ps_open_file($ps, "spotcolor.ps")) {
print "Cannot open PostScript file
";
exit;
}
ps_set_info($ps, "Creator", "spotcolor.php");
ps_set_info($ps, "Author", "Uwe Steinmann");
ps_set_info($ps, "Title", "Spot color example");
ps_begin_page($ps, 596, 842);
ps_setcolor($ps, "fill", "cmyk", 0.37, 0.0, 0.34, 0.34);
$spotcolor = ps_makespotcolor($ps, "PANTONE 5565 C", 0);
ps_setcolor($ps, "fill", "spot", $spotcolor, 0.5, 0.0, 0.0);
ps_moveto($ps, 100, 100);
ps_lineto($ps, 100, 200);
ps_lineto($ps, 200, 200);
ps_lineto($ps, 200, 100);
ps_lineto($ps, 100, 100);
ps_fill($ps);
ps_end_page($ps);
ps_delete($ps);
?>
This example creates the spot color "PANTONE 5565 C" which is a darker green (olive) and fills a rectangle with 50% intensity.
SEE ALSO
ps_setcolor(3).
PHP Documentation Group PS_MAKESPOTCOLOR(3)