: !/bin/sh


#RecordNo,Surname__________________,Firstname______,#Extn__,^Section_______________________________________,^College_______________________________________,^2Title_________________________________________,^2Location____________,^2]#Telephone___,^4GroupID_,^4ParentID,^3]#Fax_Number__,^4]#Emp_ID,^4]Equip_,^3]#Mobile______,^4]Site,^3[#Access_Pager,[3#Email______________________________,Picture,Document,Msg1,Msg2,Msg3,Msg4,Msg5,Msg6,Msg7,Msg8,Msg9

# insert temp/casual after field 12 (was 29 now 30 cols)

awk -F ',' '{ temp_casual = (NR == 1) ? "^3]TempCasual" : ""; \
print $1 "," $2 "," $3 "," $4 "," $5 "," $6 "," $7 "," $8 "," $9 "," $10 "," $11 "," $12 "," temp_casual "," $13 "," $14 "," $15 "," $16 "," $17 "," $18 "," $19 "," $20 "," $21 "," $22 "," $23 "," $24 "," $25 "," $26 "," $27 "," $28 "," $29 }' \
< TF202xopdir.csv >TF202aopdir.csv