Shell Programming and Scripting

hi
i have file with the format as below. header and associated company details

company,accno,accname,amount
abc,123,checking,100
abc,234,saving,200
company,accno,accname,amount
def,678,checking,100
def,222,saving,200
company,accno,accname,amount
dfdf,567,checking,100
dfdf,245,saving,200

and it goes on

my requirement is i need to split the file into multiple files based on company name and each file i split should have contents corresponding to that company as well as header. the splitted files compnay name as well.

file_abc.txt ( file name)

company,accno,accname,amount
abc,123,checking,100
abc,234,saving,200

file_def.txt (file name)

company,accno,accname,amount
def,678,checking,100
def,222,saving,200


file_dfdf.txt ( filename)
company,accno,accname,amount
dfdf,567,checking,100
dfdf,245,saving,200


thanks for the help

Is it always that format?
company line
detail line 1
detail line 2

and then repeat?
Could there ever be instances where more or less detail lines?

Hi

there would be instances where detailed level lines are not eqal and we might expect no detailed lines and just the header in some cases

Try this...

Code:

awk -F, '/company/{str=$0;next}{file="file_"$1".txt";if(str){print str>file;str=""}print $0>file}' input_file

--ahamed

Code:

awk -F, '/company/{str=$0;next}{print (a[$1]++)?$0:str RS $0 > "file_" $1 ".txt"}' infile