Shell Programming and Scripting

Hello all

I have a file with below data, I need to add a third column as XXXX if the first coloumn (H180620081) last number is "1"
and YYYY if the first coloumn last number is "2"

Can it be done with AWK, I would appreciate if anyone could help me ou with this.


H180620081 31310
H180620082 33330

result

H180620081 31310 XXXX
H180620082 33330 YYYY

Thank you

Try this:

Code:

awk '
substr($1,length($1))=="1"{$(NF+1)="XXXX"}
substr($1,length($1))=="2"{$(NF+1)="YYYY"}1' file

Regards

Thanks a lot Franklin

Or(with nawk or /usr/xpg4/bin/awk on Solaris):

Code:

awk '($3=$1~/1$/?"XXXX":$1~/2$/?"YYYY":"")||1' file

And of course if you have only 2 values (1 and 2) this is sufficient:

Code:

awk '$3=$1~/1$/?"XXXX":"YYYY"' file

thanks radoulov,

what if I have a file like befow and select the line above H18062008(1) which is ccv01.fil.20080618134215.rep for 1 and output it to a new file and if it is 2 then selecting the line above it and sending it to another file.

==> ccv01.fil.20080618134215.rep <==
H180620081 31310


==> ccv01.fil.20080618134236.rep <==
H180620082 33330


Can I do that with AWK

Thanks again (Franklin and Radoulov)
UD

Code:

awk '$1 ~ /[12]$/ { print _ > ("file_" ($1 ~ /1$/ ? 1 : 2)) }
{ _ = $0 }' file

Thanks Radoulov

I am very new to AWK, can you please explain me the script, I have tried executing your script but get expected result may be I am doing something wrong.

Which file name should I give at "file_"

awk '$1 ~ /[12]$/ { print _ > ("file_" ($1 ~ /1$/ ? 1 : 2)) }
{ _ = $0 }' file

Thank you