split a file based on column value awk / sed?
 

I have a file with some data and one of it is a long integer value say column $4, I want to sort that column and based on a range split the file.

EX:- 100 - 5000 (where x = 100 and y = 5000)
Next file is like

X= 5001 and y=10000

Can someone please help?

Thanks in advance

It'd be a bit easier if you showed few lines of the file and also explain a bit more about how you want it split.
For a sort numeric on field 4 try
http://linux.die.net/man/1/sort

Thanks Chris.

Below is the data.

t1,e1,l1,r1,t2,s1
137,597,LG1,520000,Group 1-1,true
1370,8,JBC,40000,Group 1-1,false
137,597,LG1,2110000,Group 1-1,true
1370,8,JBC,800000,Group 1-1,false
137,597,LG1,210000,Group 1-1,true
1370,8,JBC,2000,Group 1-1,false
137,597,LG1,20800,Group 1-1,true
1370,8,JBC,2808000,Group 1-1,false
137,597,LG1,20700,Group 1-1,true
1370,8,JBC,2803000,Group 1-1,false
137,597,LG1,20400,Group 1-1,true
1370,8,JBC,28010,Group 1-1,false

say if I have 4th column sorted and want to split based on every 5 lines from that number

sed 1d test.csv | sort -k4 -n

1370,8,JBC,2000,Group 1-1,false
1370,8,JBC,28010,Group 1-1,false
1370,8,JBC,2803000,Group 1-1,false
1370,8,JBC,2808000,Group 1-1,false
1370,8,JBC,40000,Group 1-1,false
1370,8,JBC,800000,Group 1-1,false
137,597,LG1,20400,Group 1-1,true
137,597,LG1,20700,Group 1-1,true
137,597,LG1,20800,Group 1-1,true
137,597,LG1,210000,Group 1-1,true
137,597,LG1,2110000,Group 1-1,true
137,597,LG1,520000,Group 1-1,true

Split? Into files? Into arrays? With a gap in the output?

so you want to sort column 4 and then have a new file for every 6 lines?

This might be a coincidence , but looking at your sorted data.. I see a pattern
Would you want new files based on fields 1, 2 and 3?

edit:
this would do that
No wait, that data is *not* sorted by column 4..

here is is correctly sorted


will give you files containing 5 lines

But I'm not certain that is what you want