Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Content merging at a specific location in a file Content merging at a specific location in a file
Forums Search Forums Register Forum RulesMan PagesAlbums FAQ Members Calendar Search Today's Posts Mark Forums Read


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

Reply    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 01-04-2013
Registered User
  
Join Date: Dec 2012
Posts: 16
Thanks: 7
Thanked 0 Times in 0 Posts
Linux Content merging at a specific location in a file
Hi,

This is a bit lengthy problem, i will try to keep explaining it simple.

I have got a file say file1 that contains the following in it,


Code:
------------------------------------------------------------------------ r201463 | ngupta@gmail.com | 2012-06-19 22:02:20 +0530 (Tue, 19 Jun 2012) | 1 line Changed paths: M /client/mb/MBF.java  we press enter key in keypad ------------------------------------------------------------------------ r201464 | ngupta@gmail.com | 2012-06-19 22:04:05 +0530 (Tue, 19 Jun 2012) | 1 line Changed paths: M /client/cvcui/FTC.java M /client/cvcui/RC.java M /client/cvcui/TC.java Screen is cut from above ------------------------------------------------------------------------ r201500 | ssank@gmail.com | 2012-06-20 17:23:33 +0530 (Wed, 20 Jun 2012) | 1 line Changed paths: M /client/mb.ven Cv/mb.ven ------------------------------------------------------------------------ r201535 | asaini@gmail.com | 2012-06-21 05:00:01 +0530 (Thu, 21 Jun 2012) | 1 line Changed paths: M /client/db/RL.java  b3410 ------------------------------------------------------------------------ r201572 | ngupta@gmail.com | 2012-06-21 22:27:37 +0530 (Thu, 21 Jun 2012) | 1 line Changed paths: M /client/mb/res.xml  invalid pin. ------------------------------------------------------------------------ r201575 | ngupta@gmail.com | 2012-06-21 22:45:06 +0530 (Thu, 21 Jun 2012) | 1 line Changed paths: M /client/mb/MBSF.java  UI changes ------------------------------------------------------------------------

Now i have another file say file2

Code:
URL1 xyz/cdd/ddf/client/mb/MBF.java
URL2 xyz/cdd/ddf/client/cvcui/FTC.java
URl3 xyz/cdd/ddf/client/cvcui/RC.java
URL4 xyz/cdd/ddf/client/cvcui/TC.java
URL5 xyz/cdd/ddf/client/mb.ven
URL6 xyz/cdd/ddf/client/db/RL.java
URL7 xyz/cdd/ddf/client/mb/res.xml
URL8 xyz/cdd/ddf/client/mb/MBSF.java

The problem i am facing is i want the links of file 2 to be placed next to the corresponding paths of file1.

The final output i need is as below,

Code:
------------------------------------------------------------------------ r201463 | ngupta@gmail.com | 2012-06-19 22:02:20 +0530 (Tue, 19 Jun 2012) | 1 line Changed paths: M /client/mb/MBF.java URL1 xyz/cdd/ddf/client/mb/MBF.java we press enter key in keypad ------------------------------------------------------------------------ r201464 | ngupta@gmail.com | 2012-06-19 22:04:05 +0530 (Tue, 19 Jun 2012) | 1 line Changed paths: M /client/cvcui/FTC.java URL2 xyz/cdd/ddf/client/cvcui/FTC.java M /client/cvcui/RC.java URl3 xyz/cdd/ddf/client/cvcui/RC.java M /client/cvcui/TC.java URL4 xyz/cdd/ddf/client/cvcui/TC.java Screen is cut from above ------------------------------------------------------------------------ r201500 | ssank@gmail.com | 2012-06-20 17:23:33 +0530 (Wed, 20 Jun 2012) | 1 line Changed paths: M /client/mb.ven URL5 xyz/cdd/ddf/client/mb.ven Cv/mb.ven ------------------------------------------------------------------------ r201535 | asaini@gmail.com | 2012-06-21 05:00:01 +0530 (Thu, 21 Jun 2012) | 1 line Changed paths: M /client/db/RL.java URL6 xyz/cdd/ddf/client/db/RL.java  b3410 ------------------------------------------------------------------------ r201572 | ngupta@gmail.com | 2012-06-21 22:27:37 +0530 (Thu, 21 Jun 2012) | 1 line Changed paths: M /client/mb/res.xml URL7 xyz/cdd/ddf/client/mb/res.xml invalid pin. ------------------------------------------------------------------------ r201575 | ngupta@gmail.com | 2012-06-21 22:45:06 +0530 (Thu, 21 Jun 2012) | 1 line Changed paths: M /client/mb/MBSF.java URL8 xyz/cdd/ddf/client/mb/MBSF.java UI changes ------------------------------------------------------------------------


I hope i have explained the problem.
Please do help me to accomplish this task as i am a newbie to unix.
Thanks,
Manju.
Sponsored Links
    #2  
Old 01-04-2013
RudiC RudiC is offline Forum Advisor  
Registered User
  
Join Date: Jul 2012
Location: Aachen, Germany
Posts: 1,908
Thanks: 25
Thanked 439 Times in 424 Posts
As you did not specify how to identify the part-URL from file1 in file2,I based it on char position. This may need to be corrected/adapted:
Code:
$ awk 'NR==FNR{Ar[$0]++;next} {for (x in Ar) gsub (substr(x,18), substr(x, 18)" "x)}1' file2 file1

Pls test and come back with results.
Sponsored Links
    #3  
Old 01-04-2013
Registered User
  
Join Date: Dec 2012
Posts: 16
Thanks: 7
Thanked 0 Times in 0 Posts
Hi rudic,
Thanks for the reply.
There is no change in the output,
I mean its not inserting the URLs' .
    #4  
Old 01-05-2013
RudiC RudiC is offline Forum Advisor  
Registered User
  
Join Date: Jul 2012
Location: Aachen, Germany
Posts: 1,908
Thanks: 25
Thanked 439 Times in 424 Posts
It does on my linux/nawk system, I compared it to your desired output and it fitted. What system are you on? You may need to run a different version of awk.
Sponsored Links
Reply

Tags
sathyaonunix

« awk to remove last two -*-* | Help with if-then-else bash script »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
merging of 2 consecutive lines in a file for a specific pattern novice_man Shell Programming and Scripting 1 12-15-2010 12:47 AM
Bash copy file contents into an existing file at a specific location gshepherd7 Shell Programming and Scripting 6 03-11-2009 09:26 AM
Insert 2 lines in a file at a specific location potro Shell Programming and Scripting 2 05-08-2008 07:38 PM
Remove duplicates from File from specific location gopikgunda Shell Programming and Scripting 1 04-09-2008 02:16 AM
Insert lines at specific location in file hcclnoodles Shell Programming and Scripting 17 03-28-2007 08:00 AM



All times are GMT -4. The time now is 03:05 PM.

The UNIX and Linux Forums - Where There is a Shell There is a Way RSS Feeds - Contact Us - The UNIX and Linux Forums - Where There is a Shell There is a Way - Archive - Botnik - Top
SEO by vBSEO
The UNIX and Linux Forums Content Copyright ©1993-2013. All Rights Reserved.
Forum Operations by The UNIX and Linux Forums
Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.