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?

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

However when I tried executing it says cannot execute.

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,

Now is my script right?

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