Shell Programming and Scripting

Hi,

I am new to scripting. I need a script to sort and the records in a file and then split them into different files.
For example, the file is:

H1......................
H2......................
D2....................
D2....................

H1........................
H2........................

Etc.,

Here the file should be sorted and splitted in such a way that all H1 records will be put into one file. all H2 in other file and so on.

Pls help.

Regards,
Sunitha

Try this?

Code:

sort file | awk '{ file=substr($0,1,2); print >> file }'

Hi,

Thanks for the reply.

I have written the script something like this.

#!/usr/bin/ksh
#############################################################################
#----------------------------------------------------------------------------
#Check for the input files.
#----------------------------------------------------------------------------
cd /app/chdata/workflow/suppl/esoutput/spd/flatfile
sort /app/chdata/workflow/suppl/esoutput/spd/flatfile/testfile | awk '{ file=substr($0,1,2); print >> /app/chdata/workflow/suppl/esoutput/spd/flatfile/testfile1_out.txt }'

However when I tried executing it says cannot execute.

Also, is my script right?

If not pls correct me.

Regards,
Sunitha

Code:

#!/usr/bin/ksh
cd /app/chdata/workflow/suppl/esoutput/spd/flatfile
sort testfile |
 awk '{ file=substr($0,1,2)".txt"; print >> file }'

Make the file executable with:

Code:

chmod +x /path/to/scriptfile

Hi,

I tried executing the script.

I got the error saying:

syntax error The source line is 1.
The error context is
{ file=substr($0,1,2)".txt"; print >> >>> /app/chdata/workflow/suppl/esoutput/spd/flatfile/testfile1_out. <<< txt }
awk: The statement cannot be correctly parsed.
The source line is 1.

You should leave it as 'file', not replace it with the filename. The variable called 'file' contains the filename it will output to, which is created by taking the first two characters of the input record, and as you have done, adding ".txt" to the end.

Hi,

I tried running it. This time I didnt get any error.

I wrote it as

sort /app/chdata/workflow/suppl/esoutput/spd/flatfile/testfile1.txt | awk '{ file=substr($0,1,2)".txt"; print >> file }'


The script didnt throw any error.

However the output file is 0KB.