Sed to Insert a Value after specific line

Question

Rewriting the whole question Again.

Hi,

I have data in a file (db_config.txt) in below format

export ORACLE_HOME=/oracle_client/instantclient_19_11
export LD_LIBRARY_PATH="$ORACLE_HOME"
ORACLE_SID=TESTDB.locahost.com; export ORACLE_SID
export PATH="$ORACLE_HOME:$PATH" 
nohup sqlplus ABCSDC/Pfgrtjf#dtt@TESTDB << EOF

Now, I capture the data in a variable

 db_connection=`cat db_config.txt`

Echo is resulting in correct data.

I am trying to insert this data into another file starting 4th line.

sed  "4 i $db_connection" test1.sh

I get following error

sed: -e expression #1, char 98: unknown command: `O'

What I understand it is not able to copy $ORACLE_HOME . I tried escaping $ with /$ in the source file but that also didn't help.

Regards.

Could you please check this link https://stackoverflow.com/questions/6537490/insert-a-line-at-specific-line-number-with-sed-or-awk/6537587 if this helps you. — RavinderSingh13, Jun 08 '21 at 08:27
If I use that option .. It just replace with db_connection instead of value .. If I do double quote sed I get error . — user2854333, Jun 08 '21 at 08:31
`sed "4 i $db_connection" Input_file` has worked for me fine(removed -i option to avoid inplace save). — RavinderSingh13, Jun 08 '21 at 08:34
sed: -e expression #1, char 97: unknown command: `O' .. I keep getting this error . — user2854333, Jun 08 '21 at 08:48
It's not clear what you are trying to do. Please show a representative 5 line file before and after your desired changes. Thank you. — Mark Setchell, Jun 08 '21 at 09:37

anubhava · Accepted Answer · 2021-06-08T15:25:20.660

1

Based on your edited question following sed should work:

sed -i.bak '4 r db_config.txt' test1.sh

On OSX sed you may use this sed command:

sed "4 i\\
$db_connection
" test1.sh

To save changes inline:

sed -i.bak "4 i\\
$db_connection
" test1.sh

edited Jun 08 '21 at 15:25

answered Jun 08 '21 at 10:35

anubhava

761,203
64
569
643

Sed to Insert a Value after specific line

1 Answers1