Sponsored Content
Full Discussion: SED Replace String Help
Top Forums Shell Programming and Scripting SED Replace String Help Post 302160723 by prash184u on Tuesday 22nd of January 2008 03:39:17 PM
Old 01-22-2008
Bug 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

Is it possible to replace more the 1 string with one SED?

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

sed: replace string with another string (with spaces)

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

Using sed to replace a string in file with a string in a variable that contains spaces

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 to use sed to replace the a string in the same file using sed?

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

replace (sed?) a string in file with multiple lines (string) from variable

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

sed or awk command to replace a string pattern with another string based on position of this string

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

sed String Replace

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

Replace string in XML file with awk/sed with string from another

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

Using sed to replace string

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

Replace String without using sed

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)
All times are GMT -4. The time now is 05:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy