[sed]: Substitute a string with a multiline value


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
# 1  
[sed]: Substitute a string with a multiline value

Dear all,

I try to replace a string of characters in a file (MyFile.txt) by a multiline value of the variable "Myvar":

Code:
[x004191a@xsnl11p317a TEST_DAE]$ cat MyFile.txt
DESCRIPTION '@TargetTable SCHEMA'
(
 @InputFlowDef
);
[x004191a@xsnl11p317a TEST_DAE]$

The content of Myvar:

Code:
[x004191a@xsnl11p317a TEST_DAE]$ echo "$Myvar"
col1
, col2
, col3
[x004191a@xsnl11p317a TEST_DAE]$


Using sed command in the following way, I got the error:

Code:
[x004191a@xsnl11p317a TEST_DAE]$ sed "s/@InputFlowDef/$Myvar/" MyFile.txt
sed: -e expression #1, char 20: unterminated `s' command
[x004191a@xsnl11p317a TEST_DAE]$


My aim is to get the following result:

Code:
[x004191a@xsnl11p317a TEST_DAE]$ cat MyFileResult.txt
DESCRIPTION '@TargetTable SCHEMA'
(
col1
, col2
, col3
);
[x004191a@xsnl11p317a TEST_DAE]$

Any help would be greatly appreciated,

Didier.



Moderator's Comments:
Mod Comment Please use code tags as required by forum rules!

Last edited by RudiC; 08-02-2016 at 03:36 PM.. Reason: Added code tags.
# 2  
Code:
while read line
do
   if [ "$line" = "@InputFlowDef" ]
   then
     echo "$Myvar"
   else
     echo "$line"
   fi
done < MyFile.txt

This User Gave Thanks to rdrtx1 For This Post:
# 3  
I don't think you can do this with sed and a shell variable. Create a temp file and use that:
Code:
echo "$Myvar" >/tmp/XX
sed -e'/@InputFlowDef/ {r/tmp/XX' -e';d}' file
DESCRIPTION '@TargetTable SCHEMA'
(
col1
, col2
, col3
);


Or use e.g. awk...
This User Gave Thanks to RudiC For This Post:
# 4  
rdrtx1 & RudiC, thanks a lot for your answers !

RudiC, you mentioned in your answer awk would be useful to carry out that kind of operation.

If you have few minutes, would you like to share the syntax ?
# 5  
Using awk:-
Code:
awk -v S="$Myvar" '/@InputFlowDef/{$0=S}1' MyFile.txt

This User Gave Thanks to Yoda For This Post:
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #76
Difficulty: Easy
Richard Stallman's GNU project was also started in response to AT&T's increasingly restrictive Unix software licensing terms.
True or False?

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed multiline problem

I'm trying to replicate the sed output on p.108 of Sed&Awk,by Doughery & Robbins, 2nd edition. I'm on a Windows 10 Surface Pro, running Cygwin for 64-bit versions of Windows. Input text saved in text file called data_p108.txt: Consult Section 3.1 in the Owner and Operator Guide for a... (9 Replies)
Discussion started by: prooney
9 Replies

2. Shell Programming and Scripting

Multiline sed

Hi guys, I am fairly comfortable with using the sed command if the string to be replaced is all on a single line. I was wondering is it possible to use sed command in a multiline way ? Say for example I have the below string on 2 different lines: { "key": "brandNameA", ... (3 Replies)
Discussion started by: Junaid Subhani
3 Replies

3. UNIX for Dummies Questions & Answers

Need Multiline sed help!!

Hey everyone, I'm new to sed and I need to create a script for inserting one line of code at the beginning of every method in a Xcode project (over 6,000 methods). Each method Structure is (+ or -) (Various declarations-- could span multiple lines) ({) I've tried for days, any guidance would be... (2 Replies)
Discussion started by: jimmyz
2 Replies

4. Shell Programming and Scripting

{bash scripting} Multiline initialisation of string variable

Hello, The task is quite simple. I need to initialise а string variable and assign to it a very long value. For the reason of readability I want to devide this long value into equal parts and place each part at a separate line. For instance, I have - ... (1 Reply)
Discussion started by: Pretoria
1 Replies

5. UNIX for Dummies Questions & Answers

sed multiline pattern match

How can I write a script that takes a cisco config file and outputs every occurrence of two, or more, pattern matches through the whole config file? For example, out of a config file, i want to print out every line with interface, description and ip address through the whole file, and disregard... (3 Replies)
Discussion started by: knownasthatguy
3 Replies

6. Shell Programming and Scripting

sed multiline substitution if a condition holds

Hi. I have the following text file (more precisely a Matlab script): dummy1 = 5; varx = 'false'; dummy2 = 6; % ... some general commands % ... dummy3 = 7; vary = 'option1'; dummy4 = 8; Using sed I want to do the following action: IF varx = 'false' vary='NEW_VALUE_1'... (11 Replies)
Discussion started by: plsrn
11 Replies

7. Shell Programming and Scripting

sed doubt - search and substitute string from variable.

hi, trying to learn more abt sed :( i want to substitute a variable(a) with other variable(b) appended. Read.txt contains: home/test2/abc home/test/root1 input.txt contains: make test "home/test1/none"version="1.3" wt's wrong test "home/test2/abc"version="1.0" make save... (9 Replies)
Discussion started by: dragon.1431
9 Replies

8. UNIX for Dummies Questions & Answers

Reading one line from a multiline string

Hi , I have a string which is of multiple line,I have to split the string by reading one line in each iteration and keep it in a string.I am keeping all the file names in side as string returned by the ls command ,I am stocked at the point of spliting the string to segragate each file. ... (4 Replies)
Discussion started by: Deekay.p
4 Replies

9. Shell Programming and Scripting

delete multiline string from file using sed.

Hi, I have file which has the following content... GOOD MORNING **********WARNING********** when it kicks from the kickstart, sshd daemon should start at last. (WHEN KICKING ITSELF, NOT AFTER KICKING). /etc/rc3.d/S55sshd ( run level specification for sshd is 55, now I would want to... (4 Replies)
Discussion started by: skmdu
4 Replies

Featured Tech Videos