Duplicate third column to every line

Shell Programming and Scripting
1

Dear All,

I have file input like this:

INP901 5173    4114
INP902 5227    
INP903 5284    
INP904 5346    
INP905 5400    
INP906 5456    
INP907 5511    
INP908 5572    
INP909 5622    
INP910 5678    
INP911 5739    
INP912 5796    
INP913 5845    
INP914 5910    
INP915 5965    
INP916 6027    
INP917 6082    
INP918 6129    
INP919 6182    
INP920 6235    
INP921 6290    
INP922 6357    
INP923 6406    
INP924 6466    
INP925 6521    
INP926 6572    
INP927 6637    
INP928 6697    
INP929 6757    
INP930 6812    
INP931 6856    
INP932 6909    
INP933 6962    
INP934 7011    
INP935 7071    
INP936 7131    
INP937 7195    
INP938 7243    
INP939 7298

Desired output:

INP901 5173    4114
INP902 5227    4114
INP903 5284    4114
INP904 5346    4114
INP905 5400    4114
INP906 5456    4114
INP907 5511    4114
INP908 5572    4114
INP909 5622    4114
INP910 5678    4114
INP911 5739    4114
INP912 5796    4114
INP913 5845    4114
INP914 5910    4114
INP915 5965    4114
INP916 6027    4114
INP917 6082    4114
INP918 6129    4114
INP919 6182    4114
INP920 6235    4114
INP921 6290    4114
INP922 6357    4114
INP923 6406    4114
INP924 6466    4114
INP925 6521    4114
INP926 6572    4114
INP927 6637    4114
INP928 6697    4114
INP929 6757    4114
INP930 6812    4114
INP931 6856    4114
INP932 6909    4114
INP933 6962    4114
INP934 7011    4114
INP935 7071    4114
INP936 7131    4114
INP937 7195    4114
INP938 7243    4114
INP939 7298    4114

Thanks for advance.

Attila

2

try

awk 'NR==1{S=$NF} NR>1{$(NF+1)=S}1' file
1 Like
3

I was getting some error with @pamu's solution. After some modification, it did worked for me:

awk 'NR==1{S=$NF;print}NR>1{print $0 S}' testFile

regards,
juzz4fun