Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
compare and select unmatched lines
Thanks feherke, it works. taupirho, i had tried with join commnand (join -a1 file1 file2) before. It works for small files, but fails with the number of lines is large. Is there any reason for that ? rk -
compare and select unmatched lines
Sorry PHV, it doesn't work. Could you please check the syntax again ? Thanks rk -
compare and select unmatched lines
Hi all, I have two files for which the first column of file1 contains all the first column entries of file2 and some more. I want to write another file from file1 whose first column entries are not present in the first column of file2. For example: file1: -------- 9375 63.511 76.900... -
-
binning of data
Hello, I have a ascii table that looks like this: 84.575 1.775 84.593 1.773 84.618 1.768 84.642 1.768 84.666 1.763 84.685 1.761 84.696 1.759 Th first column ranges from 0 to 120 and the second column from 0 to 4. I want to "bin" the first column (within 2 units) and calculate... -
-
Compare two files and delete
Hello, I have two files: File1 has two columns and File2 has four columns. They also have different no. of rows. I want to match column-1 of file1 with column-1 of file2 and column-2 of file1 with column-2 of file2. Then I want to print the matched records of file2 or write to file3. The... -
Compare and delete certain lines
Hi all, I have two files that look like: File 1: 20.076 -0.200 2.858 20.477 -0.200 2.869 20.878 -0.200 2.880 21.280 -0.200 2.890 21.681 -0.200 2.894 22.082 -0.200 2.892 File 2: 20.076 -0.200 0.000 20.477... -
Select every nth line
Thanks futurelet and olded. I tried with: sed -n '1~5p' infile > outfile and it worked. -
Select every nth line
Hi, I have a large ascii (3-column ) file ( > 2 Gb). So I want to resample it to select, for example, every 5th line. How to do this ? Thanks -
-
Change file names
Hi all, I have hundreds of files with names like this: 101-fd34.pics 102-fd35.pics 103-fd36.pics 104-fd37.pics and I want to rename them as: fd34.picks fd35.picks fd36.picks fd37.picks That means, I want to get rid of the characters before "fd" and add a k in "pics" to make it "picks"... -
-
Compare and merge two files
Hello all, I have two files: file1: 428165.27 5356169.59 128.20 41074 428071.74 5356209.69 128.10 41075 427978.10 5356239.79 128.00 41076 427885.32 5356279.88 127.90 41077 427790.93 5356309.99 127.80 41078 427696.68 5356350.10 127.60 41079...
