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 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
.......

I want to a bash script to sort and split the file using the 4th column and then further split each resulting file by the 5th column.

I tried:

#!/bin/bash

sort $1 | awk '{ file=substr($0,35,5)".tmp"; print >> file }'

for i in 'ls *.tmp'
do
awk '{ file=substr($0,44,1)".txt"; print >> file }'
done

but it is not working at all.

Could someone please point me in the right direction?

Thanks.

What is the desired output?

To keep the forums high quality for all users, please take the time to format your posts correctly.

Use Code Tags when you post any code or data samples so others can easily read your code. You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags [code] and [/code] by hand.)

You don't need a full script

Code:

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

To Franklin52 and All,

Sorry for not making myself clear in my earlier post.

I want output files like:

55.000 3.txt
76576.867188 6232.454102 2.008904 55.000000 3
...................................................55.000000 3

55.000 4.txt
76576.867188 6232.454102 3.607231 55.000000 4
...................................................55.000000 4

65.000000 3.txt
76576.867188 6232.454102 1.555146 65.000000 3
...................................................65.000000 3

65.000000 4.txt
76576.867188 6232.454102 3.226928 65.000000 4
...................................................65.000000 4

etc.

I am however trying out danmero's sugggestion.

Thanks

---------- Post updated at 11:20 AM ---------- Previous update was at 09:52 AM ----------

Hi All

If I keep the 4th field at the same length as below:

76576.867188 6232.454102 2.008904 55.00 3
76576.867188 6232.454102 3.607231 55.00 4
76576.867188 6232.454102 1.555146 65.00 3
76576.867188 6232.454102 3.226928 65.00 4
76576.867188 6232.454102 2.180096 100.0 4
66576.867188 4232.454102 2.944000 0.000 1
66576.867188 4232.454102 3.549000 0.000 2
66576.867188 4232.454102 4.517000 0.000 3

then this:

Code:

sort -nk4 myfile | awk '{ file=substr($0,35,7)".txt"; print >> file }'

works.

But I cannot figure it out for variable 4th field length.

danmero,

I get this error with your code:

".txt' <No such file or directory>n't redirect to '1"

Avoid spaces in file names, try this:

Code:

sort -nk4 myfile | awk '{ print > $4 "_" $5 ".txt" }'

The question is why you need the 4th field length to archive your goal?
Take a closer look at my and Franklin52 solutions.

Franklin
I get an error message similar to danmero's with your code:

danmero

I don't need the length of the 4th field per se.
I focused on it out of fustration I guess.

I am still trying to get your code or franklin52's to work.