Shell Programming and Scripting

thanks for responding, one thing i missed out,

CON Controllers Department
R abcuser usernamedesc1
R defuser usernamedesc2
R ghiuser usernamedesc3
R jkluser usernamedesc4
ADMIN Administration Division
R abcuser usernamedesc1
R defuser usernamedesc2
R ghiuser usernamedesc3
R jkluser usernamedesc4

result should be:
CON|Controllers Department|abcuser|usernamedesc1
CON|Controllers Department|defuser|usernamedesc2
CON|Controllers Department|ghiuser|usernamedesc3
CON|Controllers Department|jkluser|usernamedesc4
ADMIN|Administration Division|abcuser|usernamedesc1
ADMIN|Administration Division|defuser|usernamedesc2
ADMIN|Administration Division|ghiuser|usernamedesc3
ADMIN|Administration Division|jkluser|usernamedesc4

You can use the same logic given above. Add the row num for for the "ADMIN Administration Division" line or any other similar line in the if condition.

Code:

if ( NR == 1 || NR==6 )

the different implementations provided will work with slight modification ...

so what have you tried from your end ?

Try this......

awk 'BEGIN{
flag=0;}
{
if(flag==0 || $1~/ADMIN/){
flag=1;
ff=$1;sf=$2;tf=$3;
}
else
print(ff "|" sf" "tf "|" $2 "|" $3);
}' sample


regards
Apoorva Kumar

The following script gives the the required result :

Code:

awk -v OFS='|' '
$1 == "R" {
   $1 = Prefix;
   print;
   next;
}
{
   sub(FS,OFS);
   Prefix = $0;
} 
' sample

Jean-Pierre.

exactly what I need! bunch of thanks!! btw aigles, can you direct me to a good reference site wrt 'awk/nawk' ....

O'REILLY Sed & AWK by Dale Dougherty & Arnold Robbins

Effective AWK Programming - A User's Guide for GNU Awk

AWK links