Shell Programming and Scripting

How did you try ? which is you bash ?

Hi Askshay ,

Below is my code:

Code:

#!/bin/sh
#
SortOutput $OutputCSV $abc

function SortOutput
{
 awk -F, '$6 < 60 {exit}1' <(sort -t, -nk3,3 $1)  >>$2
}

function should be called after defining it

Code:

Code:

#!/bin/sh


function SortOutput()
{
 awk -F, '$6 < 60 {exit}1' <(sort -t, -nk3,3 $1)  >>$2
}
SortOutput $OutputCSV $abc

() was missing

a) your sample did not have 6 fields, so don't expect anything to be printed with above proposal.
b) SHOULD your input have 6 fields or more, and $6 being the relevant one, you should also make it the sort key: -k6,6

Thanks for your help on this. Now i have a new requirement as mentioned below:

I have a CSV with below values

Code:

name,city,2,country
name,city,15,country
abc,wq,10,afdfd,
qeqe,ewqre,1,wqew
abd, we,2,qwqe

I need to sort them in ascending order based on the value of column 3 and then , pick the rows with values less than 10 and be able to display the columns in that row. Also if the column 3 values are same , I need to print only one row:

for eg:
Only one of the row needs to printed.

Code:

name,city,2,country 
abd, we,2,qwqe

Moderator's Comments:

Please mark code, sample input, and sample output with CODE tags; not your entire message.