Data Handling in Script

[Rahulbatra]

I have a text file which has millions of data of employees present in it. I have my last field of these employees as my userid which is currently left as NULL for all records in the text file. I want to give write a script so that all the data’s present in the text file is appended at the last with my name. Kindly suggest a way for achieving this.

[Hélio de Araújo Estrêla]

Try, it is awk code:

awk -v my_userid="your_userid" -v my_name="your name"  '{ 

   vrec=$0;
   vstart = length(vrec) - ( length(my_userid) * 2 );
   if ( vstart < 0 ) vstart = 1;

   vtmp_string=substr(vrec, vstart);

   if ( index(vtmp_string, my_userid) > 0 ) { 
    
     print vrec my_name
   
   }
   else  {
    print vrec
   }  
  
}' your_text_file.txt