Filtering first file columns based on second file column

Hello All,

I have a .CSV file where I expect all numeric data in all the columns other than column headers. But sometimes I get the files (result of statistics computation by other persons) like below( sample data)

Code: SNO,Data1,Data2,Data3 1,2,3,4 2,3,4,SOME STRING 3,4,Inf,5 4,5,4,4 I want to remove the columns where ever character strings( I cannot provide the complete list as it is

Dear All,

I have a data file input.csv like below.

I need to read a text file that contain columns of data, i need to read 1st column as a function to call, and others are the data i need to get into a ksh script.

I am quite new to ksh scripting, i am not very sure how to read each row line by line and the data in each columns of that line, set them as variables into my ksh script.

example:

Code: add        data1&nbsp

Code: data1 1 0.01 3 5 1 0.6  2 1   data2 2 0.02 3 5 2 0.3 2 1   data3 3 0.01 3 5 3 0.01 2 1   output   1 0.01 data1 2 0.02 data2 3 0.01 data3 3 0.01 data3 I want to print 1st, 2nd column and the filename when second column is less than 5.

I have tried

Code: for i in data1 data2 data3 gawk '{if ($2 < 0.05) print $1, $2, ${i}}' > ${i} done   cat da

Hi all,

Here is my problem:

I'm testing a login script for our mac Machines.

I have a two files, file A and B, which have 5 columns, and each 5 columns are made up of random numbers, that means, numbers are all different.

dear friends,

attached are two sorted files. I want to merge them using key column: Column #2 in first file and column #1 in the second file. I want to show all columns in the merged output file.

File will have two columns key column and second column which is pipe separated and that need to be sorted.

Below is input file.

Code:

1, D|B|A|C 2, C|A|B 3, E|A|F|G|H|D|B|C 4, A|B|D|C|F Output should be

Code:

1, A|B|C|D 2, A|B|C 3, A|B|C|D|E|F|G|H 4, A|B|D|C|F Thanks in advance and I appreciate your help

hi i have two data sets one(data1) containing

Code: 3 8 2 1 5 7 9 9 2 2 5 7 7 10 3 6 6 6 6 and other(data2) containing

Code: 5 1 10 5 20 7 30 6 40 9 50 now i want my program to search the values 1 5 7 9 from (data1) in data 2 column 1 and then take the average of the corresoinding values in column 2, for example for first line of data1 the avg of (1 5 7 9) will be

Code: (10+