Visit Our UNIX and Linux User Community

Read a file and replace a value- Bourne and Korn shell

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Read a file and replace a value- Bourne and Korn shell
# 1  
Old 09-19-2002
Question Read a file and replace a value- Bourne and Korn shell


I have a file called Delete and within the delete file I have the following statement:

delete from employee where employee_id = " "

how do I write a script that read from this file and replace:

employee_id = " " with employee_id is null

Please assist...greatly appreciate it.

# 2  
Old 09-20-2002
Re: Read a file and replace a value- Bourne and Korn shell


just type the below at $ prompt :

sed 's/employee_id = \" \"/employee_id is null/g' Delete >

then check file

# 3  
Old 09-20-2002
Re: Read a file and replace a value- Bourne and Korn shell

Try :

l_var=`sed -e 's/employee_id = " "/employee_id is null/p' <filename> | head -n 1`

l_var is your string variable
<filename> is the file that contains your sql statement

is that what you were looking for?

# 4  
Old 09-20-2002

Thank you everyone for your help.

This is very helpful to me. I will defintely try this.


Previous Thread | Next Thread
Test Your Knowledge in Computers #695
Difficulty: Easy
The Cathedral and the Bazaar: Musings on Linux and Open Source by an Accidental Revolutionary (abbreviated CatB) is an essay, and later a book, written by Alfred Hitchcock on software engineering methods.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Open a file from within a Bourne shell Script

I am suppose to make a program that cuts the extension off of a file. It uses that .ext to decide which program needs to be used to open the file. This only finds the name of the program from a list of programs I made. My problem is when it has the name of the program it needs to use, how can I... (3 Replies)
Discussion started by: dordrix
3 Replies

2. Shell Programming and Scripting

Bourne shell & Korn shell

Could some one tell me the difference btw Bourne shell and the Kshell? Which is more flexible and reliable in terms of portability and efficiency. When i type the following command .. $ echo $SHELL yields me /bin/sh Does this tells me that I am in Bourne shell. If yes, how can i get... (6 Replies)
Discussion started by: bobby1015
6 Replies

3. Shell Programming and Scripting

How to activate Korn Shell functionnalities in Bourne Shell

Hi All I have writing a Korn Shell script to execute it on many of our servers. But some servers don't have Korn Shell installed, they use Borne Shell. Some operations like calculation don't work : cat ${file1} | tail -$((${num1}-${num2})) > ${file2} Is it possible to activate Korn Shell... (3 Replies)
Discussion started by: madmat
3 Replies

4. Shell Programming and Scripting

read -p "prompt text" foo say "read: bad option(s)" in Bourne-Shell

Hallo, i need a Prompting read in my script: read -p "Enter your command: " command But i always get this Error: -p: is not an identifier When I run these in c-shell i get this error /usr/bin/read: read: bad option(s) How can I use a Prompt in the read command? (9 Replies)
Discussion started by: wiseguy
9 Replies

5. Shell Programming and Scripting

Differance between Bourne, Korn and C Shells

What is the differance between "C-Shell", "Korn-Shell" and "Bourne-Shell"? Please explain me! (3 Replies)
Discussion started by: Prathinidhi
3 Replies

6. UNIX for Dummies Questions & Answers

bourne shell or korn shell?

Hi, I have a script that uses "nohup" command to execute a korn shell script. Which one is the correct shell to use bourne shell or korn shell to execute a korn shell? and why? Thanks in advanced. (2 Replies)
Discussion started by: XZOR
2 Replies

7. UNIX for Dummies Questions & Answers

How do I test for the presence of a file in Bourne Shell

How do I test for the presence of a file in Bourne Shell (3 Replies)
Discussion started by: vins
3 Replies

8. Shell Programming and Scripting

Korn Shell Script - Read File & Search On Values

I am attempting to itterate through a file that has multiple lines and for each one read the entire line and use the value then to search in other files. The problem is that instead of an entire line I am getting each word in the file set as the value I am searching for. For example in File 1... (2 Replies)
Discussion started by: run_unx_novice
2 Replies

9. Shell Programming and Scripting

Read file - korn shell

Hello!! I'm want to read each line of a file. I'm doing a cut command, using \n - linefeed as delimeter and "list" as my file. cut -f1 -d"\n" -s < list Changing the file, putting spaces and doing cut -f1 -d" " -s < list it works, but with linefeed nothing is returned. Thanks... (5 Replies)
Discussion started by: alienET
5 Replies

10. UNIX for Dummies Questions & Answers

If file exists (bourne shell)

Im trying to code some logic into a test script to test for the existence of a file before recreating it. Im using the following line to test for this: if -r test.txt; However I get the error message ./ -r: not found Having read through the man pages im still not clear whats... (2 Replies)
Discussion started by: blakmk
2 Replies

Featured Tech Videos