Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Awk script Problem
Top Forums Shell Programming and Scripting Awk script Problem Post 302497770 by jaita on Friday 18th of February 2011 02:50:21 AM
Old 02-18-2011
Network Awk script Problem
Hi ,

I am having two files FILE1 and FILE2 as shown below
I need to search each and every element of Coulumn1 in the FILE1 in FILE2 and Globally replace with the Corresponding element of the Column2 in the FILE2 , For example and1 which is the first element of COl 1 of the FILE1 should be searched in the FILE2 and should be replaced with the man which is a first element of the Column2 , Col1 should be replaced with Col2 in FILE2

Code:
 
FILE 1:
 
and1      man
nand2     nase 
nor3      cage
inv4      phase
buff5     daise
or6       matry


FILE2 :


Code:
 
NET .(and1) 
PPIN GATE2(and1)
POLYNATION .(A) .(B)=and1
 
NET .(nand2) 
PRIGHT GATE49(nand2)
POLYNATION18 .(A) .(B)=nand2
 
NET .(nor3) 
Pry GATE29(nor3)
POlo009 .(A) .(B)=nor3
 
NET .(inv4) 
PPIN8 GATE2(inv4)
POLYN90 .(A) .(B)=inv4
 
NET .(buff5) 
PPINMAS GATE2(buff5)
POLYNATION90 .(A) .(B)=buff5
 
NET .(or6) 
PPI GATE2(or6)
POLYTRY .(A) .(B)=or6

OUTPUT FILE

Code:
 
 NET .(man) 
PPIN GATE2(man)
POLYNATION .(A) .(B)=man
 
NET .(nase) 
PRIGHT GATE49(nase)
POLYNATION18 .(A) .(B)=nanse
 
NET .(cage) 
Pry GATE29(cage)
POlo009 .(A) .(B)=cage
 
NET .(phase) 
PPIN8 GATE2(phase)
POLYN90 .(A) .(B)=phase
 
NET .(daise) 
PPINMAS GATE2(daise)
POLYNATION90 .(A) .(B)=daise
 
NET .(matry) 
PPI GATE2(matry)
POLYTRY .(A) .(B)=matry


I tried to use the VI Editor Record option but Global replacement for one element at two to three instances are not possible it seems
I tried to use the awk but comparing two files and searching element and globally replacing it was bit of taks for me ... new to Awk

Please help me out for this issue
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk script Problem

I wrote a awk but doesnt work as expected. The Input File attached input file My awk Script /^.......*EXEC CICS /,/END-EXEC/ { if ( $0 ~ / LINK / ) { tsflag=1 } if ( $0 ~ /EXEC CICS/ && tsflag == 1 ) ... (6 Replies)
Discussion started by: pbsrinivas
6 Replies

2. Shell Programming and Scripting

Problem with one awk script

Hi , I am having a file having the contents like this file1 ##################### kite kshitij jolly admire in the wing and tell me the secret behind opus 123 and the right of the track ######################### I have to write one awk script to substitue some values with other... (6 Replies)
Discussion started by: kshitij
6 Replies

3. Shell Programming and Scripting

Problem with awk script

Hi Can anyone help me in this Problem File1 ######################### HOLI 123 AND ONE TWO THREE AMITABH SAMSUNG POLI AND TWO SENSE CRYING WING PPIN TBFLAG I B AND OROLE TB_HOT=" DCT" TB_CAT=" CAT" TC_NOT=" AND" +PIN TB=" HOT" TB_GATE=" KOT" TB_LATE=" MAT" TC=LOT MAT DAT SAT... (5 Replies)
Discussion started by: kshitij
5 Replies

4. Shell Programming and Scripting

Problem with a AWK Script

Hi I am having some contents in my file like this file1 ########################## pin (PIN1) { direction : input ; capacitance : 121 ; max_transition : 231 ; } pin (PIN2) { direction : input ; capacitance : 124 ; max_transition : 421 ;... (8 Replies)
Discussion started by: kshitij
8 Replies

5. Shell Programming and Scripting

awk script problem

Hi All, I have the following input data: That I'd like to look like this ($2 is the column I'd like it to appear in) where the entries are grouped by date: The code I have at present is: awk 'BEGIN {} { dt = $1 if (dt == dt_prev) { pp = $3 ... (7 Replies)
Discussion started by: pondlife
7 Replies

6. Shell Programming and Scripting

Problem with an awk Script

hello, first, yes i searched the forum , google and read many tutorials but still have a problem with my script. I have great Problems, because i haven't worked with regular expressions before and never had anything to do with shellscripts. i am a complete Newby in this sort of theme. I have... (8 Replies)
Discussion started by: Crashvogel
8 Replies

7. Shell Programming and Scripting

Problem with awk script

Hi, I have one csv file with 3 fileds like tmp1.csv 2079|2010Aug|cardilogy 2349|2010Aug|numerology 2213|2010Aug|immunlogy another csv file with code for those specialities spec.csv cardiology|CRD numerology|NMY immunology|IMY i want to replace the contents of file 1 with codes... (2 Replies)
Discussion started by: Man83Nagesh
2 Replies

8. Shell Programming and Scripting

problem with awk script

Hi, I have two files Hi, I have two files file1 :> Code: val="10" port="localhost:8080"httpadd="http:\\192.168.0.239" file2 :> Code: val=${val} val="pdssx" port=${port}port="1324"httpadd=${httpadd}httpadd="raamraav"fileloc=${fileloc} file3(or file2) should have following... (1 Reply)
Discussion started by: nitin.pathak
1 Replies

9. Shell Programming and Scripting

Awk Script Problem

Can someone please explain to me what is wrong with this awk script? echo 74 85 | awk '{ if ( $1 > $2 ) PRESULTS = ( $1 - $2 ); print $0,"=>","P"PRESULTS ; else if ( $1 > $2 ) NRESULTS = ( $2 - $1... (3 Replies)
Discussion started by: SkySmart
3 Replies

10. Shell Programming and Scripting

awk script problem

Hello guys i have following problem. I'm trying to copy content of one file and paste this content in all .txt files in directory, but at line 15. My script copy the content at first line, not 15. I'm confused how to do this. Thank you in advance for your help! This is my script: ARGS=2 ... (9 Replies)
Discussion started by: r00ty
9 Replies

LEARN ABOUT DEBIAN

meld

MELD(1) 						      General Commands Manual							   MELD(1)

NAME

       meld - Visual diff and merge tool for the GNOME Desktop

SYNOPSIS

       meld [options]
       meld [options] FILE1
       meld [options] DIR1
       meld [options] FILE1 FILE2 [FILE3]
       meld [options] DIR1 DIR2 [DIR3]

DESCRIPTION

       Meld  is  a  graphical diff viewer and merge application for the Gnome desktop.	It supports 2 and 3-file diffs, recursive directory diffs,
       diffing of directories under version control (Arch, Bazaar, Codeville, CVS, Darcs, Git, Mercurial, Monotone, RCS), as well as  the  ability
       to manually and automatically merge file differences.

OPTIONS

       --auto-compare, -a
	      Automatically compare all differing files on startup.

       --diff FILE1|DIR1 FILE2|DIR2 [FILE3|DIR3]
	      Create a diff tab for the given files or directories.  Note that "meld --diff FILE1 FILE2" is functionally equivalent to "meld FILE1
	      FILE2".  However, the --diff argument can be given multiple times for one invocation of meld which allows the user to  automatically
	      initiate multiple diffs when meld starts.  See examples below.

       --help, -h
	      Print application help and usage.

       --LABEL=<label>, -L <label>
	      Set application window title to <label>.

       --version
	      Print application version and exit.

EXAMPLES

       meld
	      Run meld without initiating a diff.

       meld FILE1
	      Initiate a diff between FILE1 and the version-controlled copy of FILE1.

       meld DIR1
	      Initiate a recursive diff between DIR1 and the version-controlled copy of DIR1.

       meld FILE1 FILE2
	      Initiate a diff between FILE1 and FILE2.

       meld FILE1 FILE2 FILE3
	      Initiate a 3-way diff between FILE1, FILE2, and FILE3.

       meld DIR1 DIR2
	      Initiate a recursive diff between directory DIR1 and DIR2.

       meld DIR1 DIR2 DIR3
	      Initiate a recursive 3-way diff between directory DIR1, DIR2, and DIR3.

       meld --diff FILE1 FILE2 --diff FILE3 FILE4
	      Initiate a diff between FILE1 and FILE2, and a separate diff between FILE3 and FILE4.

BUGS

       If  you	find  a  bug,  please report it at https://bugzilla.gnome.org/buglist.cgi?product=meld or mail a description of the issue to meld-
       list@gnome.org.

AUTHORS

       See the AUTHORS text file in meld's source code (http://git.gnome.org/browse/meld/tree/AUTHORS).

								   26 Sept 2010 							   MELD(1)
All times are GMT -4. The time now is 09:02 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy