Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Can anyone find the mistake in this script file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Can anyone find the mistake in this script file
# 15  
Old 10-12-2011
ygemici code is working for me .. R u on the right track ..?
Code:
$ echo $a
ACK_PARTY_NAME BUS_EVENT_SEQ_NBR ---------------------------------------- ----------------- MOVE_USAGE_DAEMON1 3969413
$ echo $a | sed 's/.*\([^ ]1*\) \([^ ]*\)/\1 \2/'
1 3969413

# 16  
Old 10-12-2011
Quote:
Originally Posted by jayan_jay
ygemici code is working for me .. R u on the right track ..?
Code:
$ echo $a
ACK_PARTY_NAME BUS_EVENT_SEQ_NBR ---------------------------------------- ----------------- MOVE_USAGE_DAEMON1 3969413
$ echo $a | sed 's/.*\([^ ]1*\) \([^ ]*\)/\1 \2/'
1 3969413

yes @jayan_jay,it also must work at @rkrish script
This User Gave Thanks to ygemici For This Post:
rkrish
# 17  
Old 10-12-2011
try this one

Code:
a=`sqlplus -s $db_user/$db_pwd@$db_sid << EOF
set pagesize 0 feedback off verify off heading off echo off
select   ACK_PARTY_NAME,bus_event_seq_nbr  from bus_event where  ack_party_name like 'MOVE_USAGE_DAEMON%'  and bus_event_seq_nbr='3969094';
exit;
EOF`

echo $a | sed 's/.*\([^ ]1*\) \([^ ]*\)/\1 \2/'

This User Gave Thanks to jville For This Post:
rkrish
# 18  
Old 10-13-2011
Quote:
Originally Posted by jayan_jay
ygemici code is working for me .. R u on the right track ..?
Code:
$ echo $a
ACK_PARTY_NAME BUS_EVENT_SEQ_NBR ---------------------------------------- ----------------- MOVE_USAGE_DAEMON1 3969413
$ echo $a | sed 's/.*\([^ ]1*\) \([^ ]*\)/\1 \2/'
1 3969413

It worked with the below code:
Code:
a=`sqlplus -s $db_user/$db_pwd@$db_sid << EOF
set pagesize 0 feedback off verify off heading off echo off
select   ACK_PARTY_NAME,bus_event_seq_nbr  from bus_event where  ack_party_name like 'MOVE_USAGE_DAEMON%'  and bus_event_seq_nbr='3969094';
exit;
EOF`
echo $a | sed 's/.*\([^ ]1*\) \([^ ]*\)/\1 \2/'

Thanks for the effort :-)
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

Archive script spot a mistake?

#!/bin/bash source=/to_be_archived dest=/archived echo "is this archive for an audio tar press (t) or an audio directory press (d)" read option case $option in d) cd "$source" echo "please specify full path to directory you want to be... (6 Replies)
Discussion started by: robertkwild
6 Replies

2. Shell Programming and Scripting

Perl script to read string from file#1 and find/replace in file#2

Hello Forum. I have a file called abc.sed with the following commands; s/1/one/g s/2/two/g ... I also have a second file called abc.dat and would like to substitute all occurrences of "1 with one", "2 with two", etc and create a new file called abc_new.dat sed -f abc.sed abc.dat >... (10 Replies)
Discussion started by: pchang
10 Replies

3. UNIX for Dummies Questions & Answers

Can anyone help me to spot my mistake?

Hi there can anyone help me to spot my mistake and please explain why it appears My code : #!/usr/bin/gawk -f BEGIN { bytes =0} { temp=$(grep "datafeed\.php" | cut -d" " -f8) bytes += temp} END { printf "Number of bytes: %d\n", bytes } when I am running ./q411 an411 an411: ... (6 Replies)
Discussion started by: FUTURE_EINSTEIN
6 Replies

4. Shell Programming and Scripting

Do not find the mistake in a small routine!!!

Have a textfile (regular updated) with informations about datafiles . Each line is describing a datafile. Now I am trying to delete several specific lines in this textfile, which are defined before in a kind of removal list. Can not find the mistake I have done in the script because in the... (5 Replies)
Discussion started by: jurgen
5 Replies

5. UNIX for Dummies Questions & Answers

Probably some stupid mistake...

Hi everyone ! I have a file wich look like this : >Sis01 > Sis02 ... >Sis44 I want to separe each paragraphe in a different file, so I decide to use the "FOR" loop + sed. for f in {01..44} do (5 Replies)
Discussion started by: sluvah
5 Replies

6. Shell Programming and Scripting

Is there any mistake in this code:

cat $1 | sort -n | uniq | $1 in other words, I sort the content of the file and put the ouput in the same file, is there any mistakes in this cshell code ??? (4 Replies)
Discussion started by: Takeeshe
4 Replies

7. Shell Programming and Scripting

Removing rows based on a different file (ignore my earlier post - there was a mistake).

Sorry I made a mistake in my last post (output is suppose to be the opposite). Here is a revised post. Hi, I am not sure if this has already been asked (I tried the search but the search was too broad). Basically I want to remove rows based on another file. So file1 looks like this (tab... (3 Replies)
Discussion started by: kylle345
3 Replies

8. Shell Programming and Scripting

Can't find the mistake in sed expression

Hi there, Can anyone help me find the correct expression for sed. I want to repace iface eth0 inet wathever with iface eth0 inet static Thanks for your help Santiago (5 Replies)
Discussion started by: chebarbudo
5 Replies

9. AIX

Did a Mistake with HACMP

Hi, I needed space on a FS, and when I've added the space on the filesystem, I did it trough the regular smitty fs inteface and not with smitty cl_lvm. Can someone help me to repair the situat before a faileover happen ? Thanks for your help,:mad: (13 Replies)
Discussion started by: azzed27
13 Replies

10. Shell Programming and Scripting

how to find Script file location inside script

I have to find out the file system location of the script file inside script. for example a script "abc.sh" placed anywhere in the file system when executed shold tell by itself the location of it. example #pwd / #./abc this is / #cd /root #./abc this is /root #cd / #/root/abc this... (10 Replies)
Discussion started by: asami
10 Replies
Login or Register to Ask a Question