Shell Programming and Scripting

hi,

how can i achieve this in awk

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

expected results:

CON|Controllers Department|abcuser|usernamedesc1
CON|Controllers Department|defuser|usernamedesc2
CON|Controllers Department|ghiuser|usernamedesc3
CON|Controllers Department|jkluser|usernamedesc4

Code:

cat awktest

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

Code:

awk 'BEGIN{OFS="|"}NR==1{string=$1"|"$2" "$3}NR>1{print string,$2,$3}' awktest

CON|Controllers Department|abcuser|usernamedesc1
CON|Controllers Department|defuser|usernamedesc2
CON|Controllers Department|ghiuser|usernamedesc3
CON|Controllers Department|jkluser|usernamedesc4

Dear vish_indian,

I was also trying a solution, with a different approch. I wrote this script

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

where sample is the input file. But this script is giving me error...

awk: syntax error near line 4
awk: bailing out near line 4

can you plese guide what is wrong with this??

regards
Apoorva Kumar

Hi,

There are couple of things.

You forgot the brackets around if-else block.
awk 'BEGIN {flag=1; ff=$1;sf=$2;tf=$3; } {
if ( flag == 1 )
flag=0;
else
print(ff "|" sf tf "|" $2 "|" $3);
}' filename

If you run this code, output is
It happens so because code in BEGIN block is executed before the file is read. Thus, $1,$2,$3 are all "blank". Thus, you need to define variables ff,ss,tf in another block and since it has to run only for 1st row, code would be like

Code:

NR==1{ ff=$1;sf=$2;tf=$3; }

or inside your if condition
if ( flag == 1 )
flag=0;
ff=$1;sf=$2;tf=$3;

Here's the code using your logic.

Code:

awk 'BEGIN {flag=1;
  }
 {if ( flag == 1 )
 {flag=0;ff=$1;sf=$2;tf=$3;}
 else
print(ff "|" sf,tf "|" $2 "|" $3);}
' awktest

Thanks a lot!! you have clearified the things!!

with warm regards
Apoorva Kumar

here is something more generic ..

Code:

awk 'BEGIN{val=""} { 
if(NR==1) { 
for( x=1; x<=NF; x++) { 
if(x == 1 ) {
val=val$x"|" 
}
else {
val=val" "$x
}
} 
val=val"|"
} 
else { 
final="" 
for(x=2;x<=NF;x++) { 
final=final$x"|" 
} 
print val""final
} 
}' data