Search & Replace


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Search & Replace
# 1  
Old 12-21-2015
Search & Replace

Hi Gurus,

I have two files. I want to read sessoin_name from the file1 and replace $Param4 & $Param5 in file2 with connection_name in specified in file1.
The file1 will have data in following format

File 1
Code:
session_name,connection_name
s_abcd,Listener_2
s_def,Listener_1

source file 2 will have the workflow informatoin as below.
Code:
[ABCD_ABC.WF:wf_abcd.ST:s_abcd]
$Param1=s_abcd.log
$Param2=connection_I
$Param3=connection_.O
$Param4=Listener_1
$Param5=Listener_1
 
[ABCD_DEF.WF:wf_def.ST:s_def]
$Param1=s_def.log
$Param2=connection_I
$Param3=connection_.O
$Param4=Listener_2
$Param5=Listener_2

[ABCD_GHI.WF:wf_ghi.ST:s_ghi]
$Param1=s_ghi.log
$Param2=connection_I
$Param3=connection_.O
$Param4=Listener_3
$Param5=Listener_3

Output should be

Code:
ABCD_ABC.WF:wf_abcd.ST:s_abcd]
$Param1=s_abcd.log
$Param2=connection_I
$Param3=connection_.O
$Param4=Listener_2
$Param5=Listener_2
 
[ABCD_DEF.WF:wf_def.ST:s_def]
$Param1=s_def.log
$Param2=connection_I
$Param3=connection_.O
$Param4=Listener_1
$Param5=Listener_1

[ABCD_GHI.WF:wf_ghi.ST:s_ghi]
$Param1=s_ghi.log
$Param2=connection_I
$Param3=connection_.O
$Param4=Listener_3
$Param5=Listener_3


Moderator's Comments:
Mod Comment Please use

code tags

for code and data

Please do NOT use icode tags for multiline code...

Last edited by Scrutinizer; 12-21-2015 at 02:35 AM.. Reason: Changed all ICODE tags to CODE tags
# 2  
Old 12-21-2015
What have you tried to solve this problem?

What operating system and shell are you using?
# 3  
Old 12-21-2015
Operating system
HTML Code:
Linux iapp218.devin1.ms.com 2.6.18-402.el5 #1 SMP Thu Jan 8 06:22:34 EST 2015 x86_64 x86_64 x86_64 GNU/Linux
and the shell im using is
HTML Code:
/bin/ksh
# 4  
Old 12-21-2015
And Don Cragun's first question?
# 5  
Old 12-21-2015
Yet trying on how to substitute the values

Code:
 grep -A 5 "\:s_abc" file2 | awk 'FNR==6 || FNR==5 {print}'

# 6  
Old 12-21-2015
grep can't do substitutions; sed or awk (amongst others) can. Actually, you don't need grep at all. Try
Code:
awk '
FNR==NR         {R[$1".log"]=$2
                 next
                }

$2 in R         {REP = R[$2]
                }
$1 == "$Param4" {if (REP) $2 = REP
                }
$1 == "$Param5" {if (REP) $2 = REP
                 REP = ""
                }
1
' FS="," file1 FS="=" OFS="=" file2
[ABCD_ABC.WF:wf_abcd.ST:s_abcd]
$Param1=s_abcd.log
$Param2=connection_I
$Param3=connection_.O
$Param4=Listener_2
$Param5=Listener_2
 
[ABCD_DEF.WF:wf_def.ST:s_def]
$Param1=s_def.log
$Param2=connection_I
$Param3=connection_.O
$Param4=Listener_1
$Param5=Listener_1

[ABCD_GHI.WF:wf_ghi.ST:s_ghi]
$Param1=s_ghi.log
$Param2=connection_I
$Param3=connection_.O
$Param4=Listener_3
$Param5=Listener_3

This User Gave Thanks to RudiC For This Post:
# 7  
Old 12-22-2015
Thanks A lot Rudy ! can you please explain this bit as what it does

$1 == "$Param5" {if (REP) $2 = REP
REP = ""
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Search & Replace

Hi all Please can you help me with a script to check several files for the following string: encoding=""and replace it with: encoding="UTF-8"I did the following, : #!/bin/sh string1="encoding=""" string2="encoding="UTF-8" sed 's/'"$string1"'/'"$string2"'/g'but does not work. Please can... (18 Replies)
Discussion started by: fretagi
18 Replies

2. Shell Programming and Scripting

search & replace pattern

Hi, My problem is that I have to search a changing pattern and replace it with the wild card char "*" i/p: 99_*_YYYYMMDD_SRC.txt.tar.gz o/p: 99_*_*_SRC.txt.tar.gz The problem is that YYYYMMDD pattern is not static. It could be YYYYMMDDHHMI or could be YYYYMMDDHHMISS. Can... (10 Replies)
Discussion started by: dips_ag
10 Replies

3. Shell Programming and Scripting

Search & Replace question

Hi all, I have one question that hopefully isn't too complicated for the more advanced users here. In one of the Solaris KSH scripts I'm working on, is it possible to script the following: - If there "is" an empty blank line "at the end" of /tmp/text.txt, then remove only that one empty... (3 Replies)
Discussion started by: chatguy
3 Replies

4. Shell Programming and Scripting

Stuck with Search & Replace

Hi I'm trying to replace a string in the files ending with *.txt Unable to get the sed to do the job. any help would be appreciated :) I'm on SunOS #!/bin/bash startdirectory={$HOME}/pp_test searchterm="change" replaceterm="CHANGE" echo $searchterm echo $replaceterm for file in... (4 Replies)
Discussion started by: mqueue
4 Replies

5. UNIX for Dummies Questions & Answers

Search & Replace

Hi , I ahve a text file which has several instances of the text such as run_time: 09:30 I need to add double quotes before and after the time value i.e: run_time: "09:30" Any suggestions on how to go about the same (4 Replies)
Discussion started by: jobbyjoseph
4 Replies

6. Shell Programming and Scripting

Need help with search & replace

I have a file that has some accent characters in it when viewed in some text editors, but when viewed in vi they come in as ~R and ~U. I need to make a script to remove these characters from the file, but have been unsuccessful. I am not sure how sed or awk, or something similar is viewing them,... (8 Replies)
Discussion started by: tcovert
8 Replies

7. UNIX for Dummies Questions & Answers

String Search & Replace

Hey, I want to have a C program which, for an existing file supplied by the command line argument (E.g. File1.txt) replaces all the occurrences of the words: "We” or “we” by “I” “a” by “the” “A” by “The”. Then print the replaced file. All other characters of the file are to be left... (1 Reply)
Discussion started by: IwishIknewC
1 Replies

8. Shell Programming and Scripting

search & replace in variable

Can I use search & replace in any variable? Suppose I have one variable named var1 which holds value "abcabc" I need to search 'a' in var1 and want to replace with 'x' like 'xbcxbc'. Is it possible? Can you provide me an example? Malay (3 Replies)
Discussion started by: malaymaru
3 Replies

9. Shell Programming and Scripting

Search & replace

Is there any way we can achieve search & replace with awk? I could achieve the same with sed in following way - sed 's/A/B/g' file1 > file2 But the same regex if I try with using awk following way, awk 's/A/B/g' file1 > file2 it gives me Syntax error. I strongly believe I am... (1 Reply)
Discussion started by: videsh77
1 Replies

10. UNIX for Advanced & Expert Users

vi search & replace functions

I'm trying to do a global search and replace in vi. I am trying to replace a string, call it "BOB" with a carriage return and can't seem to find a reference to it. Command syntax s%/BOB/???/g What would I substitute the "???" with? (7 Replies)
Discussion started by: barnettdk
7 Replies
Login or Register to Ask a Question