Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: sort and split file by 2 cols (1 col after the other)
Top Forums Shell Programming and Scripting sort and split file by 2 cols (1 col after the other) Post 302338254 by danmero on Monday 27th of July 2009 11:11:19 AM
Old 07-27-2009
Code:
# cat file
76576.867188 6232.454102 1.944000 0.000000 1
76576.867188 6232.454102 2.549000 0.000000 2
76576.867188 6232.454102 3.517000 0.000000 3
76576.867188 6232.454102 4.976000 0.000000 4
76576.867188 6232.454102 0.792961 55.000000 2
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 3.226928 65.000000 4
76576.867188 6232.454102 2.180096 100.000000 4
66576.867188 4232.454102 2.944000 0.000000 1
66576.867188 4232.454102 3.549000 0.000000 2
66576.867188 4232.454102 4.517000 0.000000 3
66576.867188 4232.454102 5.976000 0.000000 4
66576.867188 4232.454102 0.855956 55.000000 2
66576.867188 4232.454102 2.104038 55.000000 3
66576.867188 4232.454102 3.737020 55.000000 4
66576.867188 4232.454102 1.608926 65.000000 3
66576.867188 4232.454102 3.319681 65.000000 4
66576.867188 4232.454102 2.234251 100.000000 4
86576.867188 5232.454102 3.944000 0.000000 1
86576.867188 5232.454102 3.549000 0.000000 2
86576.867188 5232.454102 4.537932 0.000000 3
86576.867188 5232.454102 6.022880 0.000000 4
86576.867188 5232.454102 0.705243 55.000000 2
86576.867188 5232.454102 1.563464 55.000000 3
86576.867188 5232.454102 3.311949 55.000000 4
86576.867188 5232.454102 1.635146 65.000000 3
86576.867188 5232.454102 3.370348 65.000000 4
86576.867188 5232.454102 2.266589 100.000000 4

# sort -nk4 file | awk '{newfile=$NF".txt";print >  newfile}'

# cat 1.txt
66576.867188 4232.454102 2.944000 0.000000 1
76576.867188 6232.454102 1.944000 0.000000 1
86576.867188 5232.454102 3.944000 0.000000 1

# cat 2.txt
66576.867188 4232.454102 3.549000 0.000000 2
76576.867188 6232.454102 2.549000 0.000000 2
86576.867188 5232.454102 3.549000 0.000000 2
66576.867188 4232.454102 0.855956 55.000000 2
76576.867188 6232.454102 0.792961 55.000000 2
86576.867188 5232.454102 0.705243 55.000000 2

# cat 3.txt
66576.867188 4232.454102 4.517000 0.000000 3
76576.867188 6232.454102 3.517000 0.000000 3
86576.867188 5232.454102 4.537932 0.000000 3
66576.867188 4232.454102 2.104038 55.000000 3
76576.867188 6232.454102 2.008904 55.000000 3
86576.867188 5232.454102 1.563464 55.000000 3
66576.867188 4232.454102 1.608926 65.000000 3
76576.867188 6232.454102 1.555146 65.000000 3
86576.867188 5232.454102 1.635146 65.000000 3

# cat 4.txt
66576.867188 4232.454102 5.976000 0.000000 4
76576.867188 6232.454102 4.976000 0.000000 4
86576.867188 5232.454102 6.022880 0.000000 4
66576.867188 4232.454102 3.737020 55.000000 4
76576.867188 6232.454102 3.607231 55.000000 4
86576.867188 5232.454102 3.311949 55.000000 4
66576.867188 4232.454102 3.319681 65.000000 4
76576.867188 6232.454102 3.226928 65.000000 4
86576.867188 5232.454102 3.370348 65.000000 4
66576.867188 4232.454102 2.234251 100.000000 4
76576.867188 6232.454102 2.180096 100.000000 4
86576.867188 5232.454102 2.266589 100.000000 4

That's what you want Smilie
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

join cols from multi files into one file

Hi Fields in Files 1,2,3,4 are pipe"|" separated. Say I want to grep col1 from File1 col3 from File2 col4 from File3 and print to File4 in the following order: col3|col1|col4 what is the best way of doing this? Thanks (2 Replies)
Discussion started by: vbshuru
2 Replies

2. Shell Programming and Scripting

Sort & Split records in a file

Hi, I am new to scripting. I need a script to sort and the records in a file and then split them into different files. For example, the file is: H1...................... H2...................... D2.................... D2.................... H1........................... (15 Replies)
Discussion started by: Sunitha_edi82
15 Replies

3. Shell Programming and Scripting

How to find number of Cols in a file ?

Hi I have a requirement wherein the file is comma separated. Each records seems to have different number of columns, how I can detect like a row index wise, how many columns are present ? Thanks in advance. (2 Replies)
Discussion started by: videsh77
2 Replies

4. Ubuntu

Match col 1 of File 1 with col 1 File 2 and create a 3rd file

Hello, I have a 1.6 GB file that I would like to modify by matching some ids in col1 with the ids in col 1 of file2.txt and save the results into a 3rd file. For example: File 1 has 1411 rows, I ignore how many columns it has (thousands) File 2 has 311 rows, 1 column Would like to... (7 Replies)
Discussion started by: sogi
7 Replies

5. UNIX for Advanced & Expert Users

Print line based on highest value of col (B) and repetion of values in col (A)

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

6. Shell Programming and Scripting

how to Insert values in multiple lines(records) within a pipe delimited text file in specific cols

this is Korn shell unix. The scenario is I have a pipe delimited text file which needs to be customized. say for example,I have a pipe delimited text file with 15 columns(| delimited) and 200 rows. currently the 11th and 12th column has null values for all the records(there are other null columns... (4 Replies)
Discussion started by: vasan2815
4 Replies

7. Shell Programming and Scripting

Printing from col x to end of line, except last col

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

Modifying col values based on another col

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

9. Shell Programming and Scripting

Sort and Split file with header and custom name

Hi, I am using SUN SOLARIS (SunOS sun4v sparc SUNW, T5240). I have a huge data file with header and trailer. This file gets used into an ETL process. ETL skips the header record (which is the first record of the file) and loads the rest of the record. The file can be delimited (comma,... (5 Replies)
Discussion started by: Saanvi1
5 Replies

10. UNIX for Beginners Questions & Answers

Sort files to the split second

I need a similar sort, I need to sort the directory by time, but time needs to be to the second or smaller. Using ls -lt but that is only to the minute. (3 Replies)
Discussion started by: mwlaursen
3 Replies

LEARN ABOUT PLAN9

config.guess

CONFIG.GUESS(1) 						   User Commands						   CONFIG.GUESS(1)

NAME

       config.guess - guess the build system triplet

SYNOPSIS

       config.guess [OPTION]

DESCRIPTION

       The GNU build system distinguishes three types of machines, the `build' machine on which the compilers are run, the `host' machine on which
       the package being built will run, and, exclusively when you build a compiler, assembler etc., the `target' machine, for which the  compiler
       being built will produce code.

       This script will guess the type of the `build' machine.

       Output the configuration name of the system `config.guess' is run on.

   Operation modes:
       -h, --help
	      print this help, then exit

       -t, --time-stamp
	      print date of last modification, then exit

       -v, --version
	      print version number, then exit

ENVIRONMENT VARIABLES

       config.guess  might  need  to  compile  and  run  C  code,  hence it needs a compiler for the `build' machine: use the environment variable
       `CC_FOR_BUILD' to specify the compiler for the build machine.  If `CC_FOR_BUILD' is not specified, `CC' will be used.  Be sure  to  specify
       `CC_FOR_BUILD' is `CC' is a cross-compiler to the `host' machine.

	 CC_FOR_BUILD	 a native C compiler, defaults to `cc'
	 CC		 a native C compiler, the previous variable is preferred

REPORTING BUGS

       Report bugs and patches to <config-patches@gnu.org>.

       Originally written by Per Bothner.
       Copyright 1992-2016 Free Software Foundation, Inc.

       This is free software; see the source for copying conditions.  There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU-
       LAR PURPOSE.

SEE ALSO

       autoconf(1), automake(1), autoreconf(1), autoupdate(1), autoheader(1), autoscan(1), config.guess(1), config.sub(1), ifnames(1), libtool(1).

GNU Autoconf 2.69						    August 2017 						   CONFIG.GUESS(1)
All times are GMT -4. The time now is 02:12 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy