06-30-2009
Fastest way is syncsort but i dont know if you would have that....
then try grep. dont use awk.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I have an file which looks like
country address phone amount
sweden |address |phone | 10 |
Singapo |address |phone | 20 |
Italy-N |address |phone | 30 |
denmar |address |phone | 40 |
Here i need to do the sum(amount), how to do this in shell scripting
Thanks
Babu (11 Replies)
Discussion started by: ksmbabu
11 Replies
2. Shell Programming and Scripting
Dear All,
I am a newbie to shell scripting so this one is really over my head.
I have a text file with five fields as below:
76576.867188 6232.454102 2.008904 55.000000 3
76576.867188 6232.454102 3.607231 55.000000 4
76576.867188 6232.454102 1.555146 65.000000 3
76576.867188 6232.454102... (19 Replies)
Discussion started by: Ghetz
19 Replies
3. Shell Programming and Scripting
Hi,
I have two different files, one has two columns and other has only one column. I would like to compare the first column in the first file with the data in the second file and write a third file with the data that is not present is not common to them.
First file:... (26 Replies)
Discussion started by: swame_sp
26 Replies
4. Shell Programming and Scripting
Hi,
My first file has
592155 9 rs16916098 1
592156 19 rs7249604 1
592157 4 rs885156 1
592158 5 rs350067 12nd file has
9 rs16916098 0 113228129 2 4
19 rs7249604 0 58709070 4 2
2 rs17042833 0 113558750 4 2... (2 Replies)
Discussion started by: genehunter
2 Replies
5. Shell Programming and Scripting
Hi, Experts,
I have a requirement as following:
my source file:
a
a
a
b
b
c
c
c
c
I need add one more colume as following:
1 a
2 a
3 a
1 b
2 b
1 c
2 c (4 Replies)
Discussion started by: ken002
4 Replies
6. UNIX for Advanced & Expert Users
Hello everyone,
I am writing a script to process data from the ATP world tour.
I have a file which contains:
t=540 y=2011 r=1 p=N409
t=540 y=2011 r=2 p=N409
t=540 y=2011 r=3 p=N409
t=540 y=2011 r=4 p=N409
t=520 y=2011 r=1 p=N409
t=520 y=2011 r=2 p=N409
t=520 y=2011 r=3 p=N409
The... (4 Replies)
Discussion started by: imahmoud
4 Replies
7. Shell Programming and Scripting
Hello,
I have some tab delimited data and I need to move the last col. I could hard code it,
awk '{ print $1,$NF,$2,$3,$4,etc }' infile > outfile
but it would be nice to know the syntax to print a range cols.
I know in cut you can do,
cut -f 1,4-8,11-
to print fields 1,... (8 Replies)
Discussion started by: LMHmedchem
8 Replies
8. Shell Programming and Scripting
Hi Friends,
This is the only solution to my task. So, any help is highly appreciated.
I have a file
cat input1.bed
chr1 100 200 abc
chr1 120 300 def
chr1 145 226 ghi
chr2 567 600 unix
Now, I have another file by name
input2.bed (This file is a binary file not readable by the... (7 Replies)
Discussion started by: jacobs.smith
7 Replies
9. Shell Programming and Scripting
Hi,
Please help with this.
I have several excel files (with and .xlsx format) with 10-15 columns each.
They all have the same type of data but the columns are not ordered in the same way.
Here is a 3 column example. What I want to do add the alphabet
from column 2 to column 3, provided... (9 Replies)
Discussion started by: newbie83
9 Replies
10. Shell Programming and Scripting
hello,
i have a undelimited file which contains 229 byte records. i want to change column 23 - 26 with a new value and also change the sign of the data in colulmn 30 - 70. i've tried SED for the first change, but nothing happens:
sed 's/\(^.\{22\}\).\{4\}\(.*\)/\0603\2/' inputfile
heres an... (8 Replies)
Discussion started by: blt123
8 Replies
LEARN ABOUT DEBIAN
ptrepack
PTREPACK(1) General Commands Manual PTREPACK(1)
NAME
ptrepack - Copy any PyTables Leaf, Group or complete subtree into another file.
SYNOPSIS
ptrepack -h -v -o -R start,stop,step --non-recursive --dest-title=title --dont-copyuser-attrs --overwrite-nodes --complevel=(0-9) --com-
plib=lib --shuffle=(0|1) --fletcher32=(0|1) --keep-source-filters --upgrade-flavors --dont-regenerate-old-indexes sourcefile:sourcegroup
destfile:destgroup
DESCRIPTION
Copy any Leaf, Group or complete subtree from a PyTables file into another file.
OPTIONS
A summary of options is included below.
-h Prints a help text.
-v Show more information.
-o Overwite destination file.
-R RANGE
Select a RANGE of rows in the form start,stop,step during the copy of all the leaves.
--non-recursive
Do not do a recursive copy. Default is to do it.
--dest-title=title
Title for the new file (if not specified, the source is copied).
--dont-copy-userattrs
Do not copy the user attrs (default is to do it).
--overwrite-nodes
Overwrite destination nodes if they exist. Default is not to overwrite them.
--complevel=(0-9)
Set a compression level (0 for no compression, which is the default).
--complib=lib
Set the compression library to be used during the copy. lib can be set to "zlib", "lzo", "ucl" or "bzip2". Defaults to "zlib".
--shuffle=(0|1)
Activate or not the shuffling filter (default is active if complevel>0).
--fletcher32=(0|1)
Whether to activate or not the fletcher32 filter (not active by default).
--keep-source-filters
Use the original filters in source files. The default is not doing that if any of --complevel, --complib, --shuffle or --fletcher32
option is specified.
--upgrade-flavors
When repacking PyTables 1.x files, the flavor of leaves will be unset. With this, such a leaves will be serialized as objects with
the internal flavor ("numpy" for 2.x series).
--dont-regenerate-old-indexes
Disable regenerating old indexes. The default is to regenerate old indexes as they are found.
SEE ALSO
ptdump(1).
These utilities are documented fully by PyTables user's manual.
AUTHOR
This manual page was written by Francesc Altet <faltet@carabos.com>.
July 7, 2007 PTREPACK(1)