shell script command

lg123 · #1 (**permalink**) 04-11-2008

Hi

I have a text file named information.txt which contains information about Oracle Instances, I want to fetch data's from that text file and want to display an output using shell script.
i.e. when I execute that shell script ,it should read all data's from information.txt and display an output like below.
I willl try explain with an example...
Say i have a file "file" containing..
Instance : DB1,windows
Instance : DB2,unix
Instance : DB3,solaris
Instance : DB4,unix
;;;;;;;;etc

so... my shell script should read the file and display output as
DB1,windows,OK
DB2,unix,OK
DB3,solaris,OK
DB4,unix, OK
;;;;; etc

How do I write this script? Can you tell me ..which command wud be appropriate?

Yogesh Sawant · #2 (**permalink**) 04-11-2008

check if this is what you want:

Code:

awk '{ print $3 ",OK" }' information.txt

era · #3 (**permalink**) 04-11-2008

Does the value "OK" depend on some calculation, or do you just want to wipe the first field and add "OK" at the end on all lines?

Code:

sed -e 's/^Instance : //' -e 's/$/,OK/' file

matrixmadhan · #4 (**permalink**) 04-11-2008

Quote:

Originally Posted by Yogesh Sawant

check if this is what you want:

Code:

awk '{ print $3 ",OK" }' information.txt

Slight modification needed to your command,

check out the last line in the input file

Code:

awk 'length($3) { print $3, "OK" }' filename

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Use ftp command in shell script	infyanurag	Shell Programming and Scripting	3	02-05-2008 08:06 AM
cd command is not working in my shell script	amitrajvarma	Shell Programming and Scripting	3	10-03-2007 05:04 AM
how to use cd command in shell script	LAKSHMI NARAYAN	Shell Programming and Scripting	3	09-09-2007 06:04 AM
vi command in shell script	bryan	UNIX for Dummies Questions & Answers	2	05-23-2006 07:51 PM
Shell script command	dipanrc	Shell Programming and Scripting	7	11-29-2005 11:15 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by