Shell Programming and Scripting

This is the file am having:
"40","1G1AL55 ",30482,9000
"40","1G1ZT58 ",29098,10600
"40","1G1AL15 ",29222,9400
"46","1G6KD57 ",3083,28400
"46","1G6KD57 ",27909,25200
"49","1G1ZU57 ",16391,13900
"49","1G2ZG58 ",28856,12400

I want to display the output in three files namely:ss40.sh,ss46.sh,ss.409.sh which are created automatically using the script.

ss40.sh should contain the corresponding details of all records with the fist column as "40".Likewise for the other two files also.

How can i write script for this?Which command should i use?

The third filename is inconsistent. Is that a typo or is it actually like that? And do the quotes actually exist in the file?

Assuming ss.409.sh is a typo:

Code:

awk '{rec=$0;gsub(/"/,"",$1);print rec>("ss"$1".sh")}' FS="," filename

Use nawk or /usr/xpg4/bin/awk on Solaris.

Hi,
I test on my pc(solairs), it is ok.

Code:

nawk 'BEGIN{FS="\""}
{
	if (cur=="")
	{
		cur=$2
		system("touch "$2".txt")
		system("echo "$0" >>"$2".txt")
	}
	else
	{
		if ($2!=cur)
		{
			cur=$2
			system("touch "$2".txt")
			system("echo "$0" >>"$2".txt")			
		}
		else
		{
			system("echo "$0" >>"$2".txt")
		}
	}
}' filename

Wonderful. You are my idol. radoulov

Wonderfull!!!!!!!!

It is working.But I cant understand.Can you explain in detail?

ss.409.sh should be ss.49.sh.It was mistakenly typed as ss.409.sh.Anyway your answer is correct.You have given exactly what i expected.

Can i write this using using for loop and if loop?

What is rec and FS in your solution?