Conditonal file split 1

[stephenk1973]

I have a comma seperated file. How woudld i split the file based on a condition. eg If field 9 > field 10 go to greater.lis else lesser.lis.

Any help much appreciated.

Thanks

Stephen

 

[vgersh99]

nawk -f step.awk myFile.txt

BEGIN {
  FS=","
  less="lesser.lis"
  great="greater.lis"
}
{print $0 >> (($9 <= $10) ?  less : great) }

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[PHV]

Something like this ?
nawk -F',' '
{print>($9>$10?"great":"less")"er.lis"}
' /path/to/inputfile

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[stephenk1973]

Thanks for the prompt reply.

Have tried your code and it sort of works. We don't appear to have nawk on our system just awk, is nawk specific command for numbers?

Currently the fields where the values are the same are being split into one file and all others (greater or lesser) are going into the other. Slightly confused have tried removing the "=" and all values going into the greater file. Any ideas?

Thanks

Stephen

 

[vgersh99]

pls post your sample file.

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[stephenk1973]

Found out why. One of the fields was a curreny and prefixed with a hidden character, only picked up on it when looked through 'vi', now awking that out as well.

Thanks for all the help.

Stephen

 

[PHV]

nawk stands for new awk and is used mainly on Solaris where traditional awk is very old.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244