01-22-2008
SED Replace String Help
I have to replace date in Control file every day i run the script
control file looks like this
$cat pharma.ctl
LOAD DATA
INFILE '/usr/bin/sqlscripts/SQL.PharmID.20071206.txt'
INTO TABLE uname.TEMP_TABLE
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(col_names)
i tried
$sed -e s/SQL.PharmID.[0-9]*.txt/SQL.PharmID.`date +%Y%m%d`.txt pharma.ctl>pharma.ctl
Command Garbled
can someone give me the right command
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i want to replace two phrases in text file
originalstringA.1.
blah blah....
originalstringB.1.
got this code so far:
#variables
IP=$1
NO=$2
FS=$3
IS=$4
NN=1
#echo variables
echo ''
echo $IP
echo $NO
echo $FS
echo $IS (1 Reply)
Discussion started by: tuathan
1 Replies
2. Shell Programming and Scripting
Hi
I have an XML file with strings XABCD, XEFGHX and XIJKLX. I would like to replace XABCDX with "This is the first string", XEFGHX with "This is the second string" and XIJKLX with "This is the third string".
What is the best way to implement this? Should I have a file with the data that is... (4 Replies)
Discussion started by: zmfcat1
4 Replies
3. Shell Programming and Scripting
Hi,
i call my shell like:
my_shell "my project name"
my script:
#!/bin/bash -vx
projectname=$1
sed s/'PROJECT_NAME ='/'PROJECT_NAME = '$projectname/ <test_config_doxy >temp
cp temp test_config_doxy
the following error occurres:
sed s/'PROJECT_NAME ... (2 Replies)
Discussion started by: vivelafete
2 Replies
4. Shell Programming and Scripting
How do i replace a string using sed into the same file without creating a intermediate file? (7 Replies)
Discussion started by: gomes1333
7 Replies
5. Shell Programming and Scripting
Can someone tell me how I can do this?
e.g:
a=$(echo -e wert trewt ertert ertert ertert erttert
erterte
rterter
tertertert
ert)
How do i replace the STRING with $a?
I try this:
sed -i 's/STRING/'"$a"'/g' filename.ext
but this don' t work (2 Replies)
Discussion started by: jforce
2 Replies
6. Shell Programming and Scripting
here is what i want to achieve... consider a file contains below contents. the file size is large about 60mb
cat dump.sql
INSERT INTO `table1` (`id`, `action`, `date`, `descrip`, `lastModified`) VALUES (1,'Change','2011-05-05 00:00:00','Account Updated','2012-02-10... (10 Replies)
Discussion started by: vivek d r
10 Replies
7. Shell Programming and Scripting
I have this file and variable on my machine
$cat /tmp/disk.tmp
check_disk.pl -H localhost -D ARG1 -w 75 -c 90
$echo $_ARG1
/,/opt,/tmp,/usr,/var,/boot,/dev/shm
how do I replace the string ARG1 in my file (disk.tmp) with the value of my variable _ARG1 and placing them inside quotes while... (4 Replies)
Discussion started by: thursday_g0ne
4 Replies
8. Shell Programming and Scripting
Sorry for the long/weird title but I'm stuck on a problem I have. I have this XML file:
</member>
<member>
<name>TransactionID</name>
<value><string>123456789123456</string></value>
</member>
<member>
<name>Number</name>
... (9 Replies)
Discussion started by: cozzin
9 Replies
9. Shell Programming and Scripting
Hello guys,
I'm working in a cellular company and i'm trying to do a script to run some commands automaticlly.
I'm using Solaris version :SunOS pk-ercuas4 5.10 in my work. I've a file that creates by script named test1.mos that that look like:
confb+
gsg+
lt all
$date = `date... (1 Reply)
Discussion started by: oferg
1 Replies
10. Shell Programming and Scripting
Hi Team,
I have a file and need to replace string. Out of 20 rows, there is one row given below
$Paramsoqlfilter=Systemmodstamp > 1900-01-01T00:00:00.000Z
in a Shell Script, I have a variable
HIST_DATE="1900-01-01T00:00:00.000Z"
INC_DATE="2018-10-04T09:18:43.000Z"
Now I need to... (14 Replies)
Discussion started by: ace_friends22
14 Replies
LOAD(7) SQL Commands LOAD(7)
NAME
LOAD - load a shared library file
SYNOPSIS
LOAD 'filename'
DESCRIPTION
This command loads a shared library file into the PostgreSQL server's address space. If the file has been loaded already, the command does
nothing. Shared library files that contain C functions are automatically loaded whenever one of their functions is called. Therefore, an
explicit LOAD is usually only needed to load a library that modifies the server's behavior through ``hooks'' rather than providing a set of
functions.
The file name is specified in the same way as for shared library names in CREATE FUNCTION [create_function(7)]; in particular, one can rely
on a search path and automatic addition of the system's standard shared library file name extension. See in the documentation for more
information on this topic.
Non-superusers can only apply LOAD to library files located in $libdir/plugins/ -- the specified filename must begin with exactly that
string. (It is the database administrator's responsibility to ensure that only ``safe'' libraries are installed there.)
COMPATIBILITY
LOAD is a PostgreSQL extension.
SEE ALSO
CREATE FUNCTION [create_function(7)]
SQL - Language Statements 2010-05-14 LOAD(7)