Conditions with AWK

[udaybo]

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

 

[PHV]

What have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[udaybo]

Hi PH,

I was trying something like below
(I am a Business Objects Developer and I am very new to scripting)

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

Thanks again

 

[PHV]

A starting point:

awk '{print $0 ($1~/1$/ ? " XXXX" : ($1~/2$/ ? " YYYY" : ""))}' file

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[feherke]

Hi

And your bug ( so far ) is :

awk 'substr($1,length($1))=[red]=[/red]"1"{$(NF+1)="XXXX"}' file

Feherke.

http://rootshell.be/~feherke/

 

[udaybo]

Thank you

 

[udaybo]

Another script regarding the same file

Script:awk 'NR%3 == 1 {s = $0}
NR%3 == 2 {print s > ("file_" ($1 ~ /1$/ ? 1 : 2))}
' file

I have a file (A.txt) with below data (it's not sample, i will always have five lines of data)
but they are timestamps and the second and fifth lines (H180620081 & H180620082) will always have their last numbers as 1 and 2.

So if it is 1 I would like to select the line above H180620081 and copied it into a different output file and if it is H180620082 then copied it into another file.

ccv01.fil.20080618134215.rep
H180620081 31310
space
ccv01.fil.20080618134236.rep
H180620082 33330

 

[PHV]

And the problem is ?