Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Modifying a file using SED

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Modifying a file using SED
# 1  
Old 09-03-2009
Modifying a file using SED
Dear Members,

I have a file which contains data as shown below:
Code:

LOAD DATA
APPEND
INTO TABLE xxap.test
( RAW_DATA char(3000) "replace(:raw_data,'*','|')",
  LOADING_SEQUENCE "xx_gl_bank_fee_s1.nextval",
  CREATION_DATE SYSDATE,
  LAST_UPDATE_DATE SYSDATE,
  ATTRIBUTE1 "DATE_STAMP",
  ATTRIBUTE2 "SOURCE")


I have a variable suppose var1 whose value is 20090903. I want to substitute "DATE_STAMP" with var1.

I am trying to use sed for this as below:

Code:
sed -e 's/DATE_STAMP/${var1}/g'  test.txt

If i do this its not substituting the value, rather its putting var1 as a value as shown below:


Code:
LOAD DATA
APPEND
INTO TABLE xxap.test
( RAW_DATA char(3000) "replace(:raw_data,'*','|')",
  LOADING_SEQUENCE "xx_gl_bank_fee_s1.nextval",
  CREATION_DATE SYSDATE,
  LAST_UPDATE_DATE SYSDATE,
  ATTRIBUTE1 "${var1}",
  ATTRIBUTE2 "SOURCE")

How can substitute the actual value of variable var1.

Thanks
Last edited by vgersh99; 09-03-2009 at 02:41 PM.. Reason: code tags, PLEASE!
# 2  
Old 09-03-2009
use double-quotes (") instead of the single-quotes (').
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Modifying listener file

Hi Pros, I'm writing a script to modify listener.ora file on multiple hosts. When I ssh to any server from a central server in our environment we are presented with menu to select the instance. I need to set my environment to listener which could be different number on every instance. How can I... (5 Replies)
Discussion started by: humble_learner
5 Replies

2. Shell Programming and Scripting

Modifying sed to only change last occurrence.

I'm using sed to switch integers (one or more digits) to the other side of the ':' colon. For example: "47593:23421" would then be "23421:47593". The way it functions right now, it is messing my settings file to use with gnuplot. The current command is: sed 's/\(*\):\(*\)/\2:\1/' out3 >... (3 Replies)
Discussion started by: D2K
3 Replies

3. Shell Programming and Scripting

Modifying file to 75 characters

I have a text file containing some notes and I want to limit the lines to 75 characters. Tried using fold, however fold will cut words. Need something in bash, sed or awk to do this. Find the blank space less than 75 ant cut from there (10 Replies)
Discussion started by: kristinu
10 Replies

4. Infrastructure Monitoring

modifying existing file using C

Hi all, I have a snmpd.conf file as below. in "SECTION: Trap Destinations" line I want to add "trap2dest <IP>:162 <com_str>" on a new line. For this I wrote following code #include <stdio.h> #include <stdlib.h> int main(void) { FILE *fp; ssize_t read_char_count = 0; ... (2 Replies)
Discussion started by: zing_foru
2 Replies

5. Shell Programming and Scripting

Modifying a file?

Hi, I want to convert a file that looks like this >joe XXXXXXXXXXXXXXXXXXX >man BBBBBBBBBBBBBBBBBBBBBSSSSSSSS to something that looks like this (where the spacing is tab seperated) joe XXXXXXXXXXXXXXXXXXX man BBBBBBBBBBBBBBBBBBBBBSSSSSSSS I am able to do the reverse but the other... (3 Replies)
Discussion started by: kylle345
3 Replies

6. Shell Programming and Scripting

modifying file using script

Hi, I am new to shell programming, and want to know is it possible to change the contents of file using script? for example, if want to search 2 words and want to replace these words with 2 new words. Regards, Manoj (4 Replies)
Discussion started by: manoj.solaris
4 Replies

7. Shell Programming and Scripting

modifying xml files using sed

Hello, I have lots of xml files in the same format and I need to modify a xml tag in these files. i loop over the files and apply sed to the files to make the modification but CPU goes to %100 while doing this. I think I'm doing something wrong. Here is my onliner: for f in $( find . -name... (1 Reply)
Discussion started by: xyzt
1 Replies

8. UNIX for Dummies Questions & Answers

Modifying a .ksh file

Hi, i have created a simple .ksh file in the following manner cat <<EOF >mfile #!/bin/ksh echo "hello world" EOF I have 2 questions 1. now i would like to add a second line after the first echo command e.g. echo "this is line 2" how can i do that ? 2. I would then like... (1 Reply)
Discussion started by: corbusier
1 Replies

9. Shell Programming and Scripting

Modifying file from outside

hi , I have a javascript file like this: function fnValidateId(){ var array_id = new Array("444","7888","6633","555","146562","3333","33332") var tmp_id = document.form1.id.value; var num=0; while(1) { if(tmp_id ==... (9 Replies)
Discussion started by: Sreejith_VK
9 Replies

10. Shell Programming and Scripting

can someone help me with modifying this file

Hi, I have a file which has data kind of like this. Apr 13 08:20:38 uslis10a sendmail: m3DDKSx3006432: usliss26.ca.com Apr 13 08:20:38 uslis10b sendmail: m3DDKSoK006433: usliss26.ca.com Apr 13 08:20:38 uslis10b sendmail: m3DDKcSo006442: usliss26.ca.com Apr 13 08:20:38 uslis10c... (2 Replies)
Discussion started by: eamani_sun
2 Replies
Login or Register to Ask a Question