1

awk based script to ignore all columns from a file which contains character strings

view story
linux-howto

http://www.unix.com – 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 unknown) appear in any row of a column. So the output will be like this Code: SNo,Data1 1,2 2,3 3,4 4,5 I have 10000 columns in my file, so manually deleting all these columns taking lot of time (HowTos)