05-22-2008
Oh well , i just found the change working but don't know how to substitute in the file .
The code part that is working is
#!/bin/ksh
#####################################################
# use cut and awk to refine the view name
######################################################
cat dim_copy.20080516.sql | grep -i "create view" | grep -v OPSDM002 | while read f1 f2 f3 f4 f5 f6 f7 f8 f9
do
f3="OPSDM002.${f3}"
echo " $f3 "
done
How do I substitute the new values of $f3 in the file ??
Thanks
Last edited by capri_drm; 05-23-2008 at 12:33 PM..
Reason: thread closed
10 More Discussions You Might Find Interesting
1. Red Hat
I use CenOS Enterprise 5. I've removed existing apache2 then installed the latest apache2. Everything is fine except the original /etc/rc.d/init.d/httpd is now missing. Without this file I can't add httpd to service (commands like "service httpd start" does not work). I have tried to link... (2 Replies)
Discussion started by: aixlover
2 Replies
2. Shell Programming and Scripting
The below script gives error: Missing ]
#!/bin/csh
set MAX=15
set PATTERN='dtsession'
set NUM=`ps -eaf | grep -c $PATTERN`
echo "No of dtsession = "$NUM
if
then
echo 'Quota exceeded permissible limit'
echo 'sending mail...............'
mail hiten.r.chauhan@gmail.com<<EOF
... (2 Replies)
Discussion started by: hiten.r.chauhan
2 Replies
3. Shell Programming and Scripting
I just put together a script for work that will essentially automate the migration of our Windows fileserver to my newly created Debian based SAMBA server.
My script will create the necessary directories then copy the data over to my new server, after that it will set the ACL's by using... (3 Replies)
Discussion started by: binary-ninja
3 Replies
4. Shell Programming and Scripting
If file exists then do stuff else do nothing...
#! /bin/sh
if
then
rm /home/dudemgnt/public_html/fileserver/Checks/Daily/RefundChecksDaily.csv
cat /home/dudemgnt/public_html/fileserver/Checks/Daily/RefundChecksDaily*.txt|sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' >... (4 Replies)
Discussion started by: Astrocloud
4 Replies
5. Shell Programming and Scripting
I want to use case statement to find the range of missing sequence in my directory which it has some few ( dat & DAT ) files
my directory /home/arm/my_folder/20130428 contains :
f01_201304280000.DAT
f01_201304280001.DAT
f01_201304280003.DAT
f02_201304280000.dat
f02_201304280002.dat... (2 Replies)
Discussion started by: arm
2 Replies
6. SuSE
Hello,
This is a programming question as well as a suse question, so let me know if you think I should post this in programming.
I have an application that I compiled under opensuse 12.2 using g77-3.3/g++3.3. The program compiles and runs just fine. I gave the application to a colleague who... (2 Replies)
Discussion started by: LMHmedchem
2 Replies
7. Shell Programming and Scripting
Hello to all,
I have show below a file separated by commas. In first column has numbers where the last number is 13.
1,4
2,6
3,7
5,2
6,5
7,5
8,65
9,10
11,78
13,2
What I want to know is which numbers are missing from 1 to 13 (in this case 13 is last number in column 1). My real... (17 Replies)
Discussion started by: Ophiuchus
17 Replies
8. Red Hat
I am trying to install VirtualBox on RHEL 5 but I need the 32 bit version for 32 bit Windows. When I run yum I get the following:
sudo yum localinstall /auto/spvtg-it/spvss-migration/Software/VirtualBox-4.3-4.3.2_90405_el6-1.i686.rpm
Loaded plugins: fastestmirror
Setting up Local Package... (13 Replies)
Discussion started by: gw1500se
13 Replies
9. Shell Programming and Scripting
Gents,
Can you please help me to fix the following script in order to get complete data as desired. I am missing some data in output.
the complete input file is attached.
The script I am using is
awk '{\
status=substr($0,91,2)\
ind=substr($0,26,1);\
... (10 Replies)
Discussion started by: jiam912
10 Replies
10. UNIX for Beginners Questions & Answers
I have no idea how to write ksh script, but i'm really in need of help with this. I using fedora 30 and in attempt of runnig attached script i getting those errors, i solved first error by removing excess bracket, but i do not know what should i do with other. Pls sorry for trash post. (8 Replies)
Discussion started by: NullPtr
8 Replies
echo(1B) SunOS/BSD Compatibility Package Commands echo(1B)
NAME
echo - echo arguments to standard output
SYNOPSIS
/usr/ucb/echo [-n] [argument]
DESCRIPTION
echo writes its arguments, separated by BLANKs and terminated by a NEWLINE, to the standard output.
echo is useful for producing diagnostics in command files and for sending known data into a pipe, and for displaying the contents of envi-
ronment variables.
For example, you can use echo to determine how many subdirectories below the root directory (/) is your current directory, as follows:
o echo your current-working-directory's full pathname
o pipe the output through tr to translate the path's embedded slash-characters into space-characters
o pipe that output through wc -w for a count of the names in your path.
example% /usr/bin/echo "echo $PWD | tr '/' ' ' | wc -w"
See tr(1) and wc(1) for their functionality.
The shells csh(1), ksh(1), and sh(1), each have an echo built-in command, which, by default, will have precedence, and will be invoked if
the user calls echo without a full pathname. /usr/ucb/echo and csh's echo() have an -n option, but do not understand back-slashed escape
characters. sh's echo(), ksh's echo(), and /usr/bin/echo, on the other hand, understand the black-slashed escape characters, and ksh's
echo() also understands a as the audible bell character; however, these commands do not have an -n option.
OPTIONS
-n Do not add the NEWLINE to the output.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWscpu |
+-----------------------------+-----------------------------+
SEE ALSO
csh(1), echo(1), ksh(1), sh(1), tr(1), wc(1), attributes(5)
NOTES
The -n option is a transition aid for BSD applications, and may not be supported in future releases.
SunOS 5.10 3 Aug 1994 echo(1B)