Shell Programming and Scripting

Hi i need to perform the following task
I have a file like this....
------------------------
HDR|FMFILL_269_20071206.txt|0712060212|FMFILL|md_ntserve|Susan Inns
ZHD|0009631099|D0269003|G|CAPG|X|NEEB|20071128114433||||OPER
MDD|138|20071130
OFT|9|19960401
THP|50|19960401
SMP|2.000|19960401
RCT|0|Constant
RCT|1|Day of Week 1
RCT|2|Day of Week 2
RCT|3|Day of Week 3
RCT|4|Day of Week 4
RCT|5|Noon Effective Temperature
RCT|6|Time of Sunset
RCT|7|(Time of Sunset)2
DYT|A1|Early August Bank Holiday
DYT|A2|Late August Bank Holiday
DYT|BD|Boxing Day
DYT|CD|Christmas Day
DYT|EM|Easter Monday
DYT|GF|Good Friday
DYT|J1|New Years Day
DYT|J2|New Year Bank Holiday
DYT|M1|1st May Bank Holiday
DYT|M2|2nd May Bank Holiday
DYT|ML|Millennium Bank
DYT|SA|Saturday
DYT|SD|Shoulder Day
DYT|SU|Sunday
DYT|WE|Weekday
DYT|X1|Adhoc National Holiday 1
DYT|X2|Adhoc National Holiday 2
DOW|1|Monday
DOW|2|Tuesday
DOW|3|Wednesday
DOW|4|Thursday
DOW|5|Friday
DOW|6|Saturday
DOW|7|Sunday
TRL|25
-------------------
what i need to do is..
cut the first two lines and the trailer (HDR,ZHD,TRL) and then i need to create 7 different file based on the first field.Ie if the first field is MDD the data should go to MDD.txt,if it is OFT the data should go to OFT.txt and so on.
CAn anyone please suggest something on this.

Code:

awk 'NR>3{print r>f}{r=$0}!x[$1]++{close(f);f=$1".txt"}' FS="|" filename

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

If your awk doesn't complain for too many open files:

Code:

awk 'NR>3{print r>f}{r=$0;f=$1".txt"}' FS="|" filename

hi radoulov..thanks for it..
but can it generate the files dynamically..i mean based on the fist field??
also that is the snapshot of the file and i also dnt know howmany different fields will be there ,,,,i mean it may b 7 it may be 10 may be 55 also...

Yes,
did you try it?
(the last version, I mean , my first post was wrong and it was corrected).

i am trying it now.

thanks a lot boss. its working at the initital level i mean creating the different files.
but tell me one thing..
just considder the following scenario

PER|7
COF|1.483086470|0
COF|0.000000000|1
COF|0.000000000|2
COF|0.000000000|3
COF|0.000000000|4
COF|-0.017649422|5
COF|0.000630192|6
COF|0.000005390|7
PER|8
COF|1.532905599|0
COF|0.000000000|1
COF|0.000000000|2
COF|0.000000000|3
COF|0.000000000|4
COF|-0.018495258|5
COF|0.000661940|6
COF|0.000006000|7
PER|9
COF|1.532905599|0
COF|0.000000000|1
COF|0.000000000|2
COF|0.000000000|3
COF|0.000000000|4
COF|-0.018495258|5
COF|0.000661940|6
COF|0.000006000|7
PER|10

where the first filed is coming in repeatative manner.so in that case what will happen? will it append to the files the new data or again new files will be created?? in the later case we will lose the data.
Please advice.

You can use something like this:

Code:

awk 'NR>3{print r>>f}{if(!x[$1]++)close(f);r=$0;f=$1".txt"}' FS="|" filename