Below is the i/p of my file ,first read the 1st line of the file 'i.e:SET DBASE_TARGETTABLE TO 'XX_SW' and replace with
SET DBASE_TARGETTABLE TO 'XX_tW and read the last line 'i.e : .SET TARGETTABLE TO 'TABLE135044' and replce with i/p file name (If my i/p file name is mm_customer_info.txt ,replace with 'TABLE135044' TO 'customer_info').Any help should be appreciated
file.txt
======
.LOGON dn/up_load1,messwh08;
.SET DBASE_TARGETTABLE TO 'XX_SW';
.SET DBASE_WORKTABLE TO 'XX_SW';
.SET DBASE_ETTABLE TO 'XX_SW';
.SET DBASE_UVTABLE TO 'XX_SW';
.SET TARGETTABLE TO 'TABLE135044';
.BEGIN IMPORT MLOAD
Expecting o/p
.LOGON dn/up_load1,messwh08;
.SET DBASE_TARGETTABLE TO 'XX_tW';
.SET DBASE_WORKTABLE TO 'XX_SW';
.SET DBASE_ETTABLE TO 'XX_SW';
.SET DBASE_UVTABLE TO 'XX_SW';
.SET TARGETTABLE TO 'cutomer_info';
The last line which is highlighted is dynamic value ,i need to pass i/p files as parameter and replace that value with my i/p file (If my i/p file name is mm_customer_info.txt ,replace with 'TABLE135044' TO 'customer_info')
.SET TARGETTABLE TO 'TABLE135044';
The filename mm_customer_info.txt is passing as a parameter in your script but how do you get the names of the variables: TABLE135044 and customer_info?
You need to use double quotes around the sed script in order for the shell to interpolate the values of the variables $col and $col1; single quotes prevent interpolation. Anyhow, using awk to identify a replacement string for sed seems misdirected, when awk can do the replacement all by itself.
I'm new to utilities like socat and netcat and I'm not clear if they will do what I need.
I have a "compileDeployStartWebServer.sh" script and a "StartBrowser.sh" script that are started by emacs/elisp at the same time in two different processes.
I'm using Cygwin bash on Windows 10.
My... (3 Replies)
Hello all,
I am facing a weird issue while executing a code below -
#!/bin/bash
cd /wload/baot/home/baotasa0/sandboxes_finance/ext_ukba_bde/pset
sh UKBA_publish.sh UKBA 28082015 3
if
then
echo "Param file conversion for all the areas are completed, please check in your home directory"... (2 Replies)
I am trying to call a script(callingscript.sh) from a master script(masterscript.sh) to get string type value from calling script to master script. I have used scripts mentioned below.
#masterscript.sh
./callingscript.sh
echo $fileExist
#callingscript.sh
echo "The script is called"... (2 Replies)
I am using blow script :--
#!/bin/bash
FIND=$(ps -elf | grep "snmp_trap.sh" | grep -v grep) #check snmp_trap.sh is running or not
if
then
# echo "process found"
exit 0;
else
echo "process not found"
exec /home/Ketan_r /snmp_trap.sh 2>&1 & disown -h ... (1 Reply)
Hi guys
I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file.
#!/bin/sh
echo " $2 $3 $4 $5 $6 $7
isql -w400 -U$2 -S$5 -P$3 << xxx
use $4
go
print"**Changes to the table... (0 Replies)