Sponsored Content
Operating Systems AIX Replace string with asterisk(*) in variable Post 302414188 by Vaddadi on Monday 19th of April 2010 11:47:35 AM
Old 04-19-2010
Replace string with asterisk(*) in variable

I was trying to replace a string ( for eg - @@asterisk@@ to * ) in variable using

Code:
cat $INFILE  | while read LINE
do
    stmt1=`echo $LINE | sed 's/@@asterisk@@/\*/g'`
    stmt=$stmt' '$stmt1
    stmt2=`echo $LINE`
    STATEMENT=$STATEMENT' '$stmt2
done
echo 'Statement with sed -- > ' $stmt 
echo 'Statement without sed -- > ' $STATEMENT

Output I am getting is
=================
Code:
Statement with sed -- >
Statement without sed -- >  INSERT INTO table1 SELECT @@ASTERISK@@ FROM table2

Seems sed is not working.. Appreciate if someone say what is wrong in this.

Thanks in advance

Last edited by Scott; 04-19-2010 at 01:29 PM.. Reason: Code tags, please...
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace string in a file w/ a variable value

I am trying to replace the default home page for several mac user accounts, I wrote a script that will hunt the files down and replace them with a pre-configured set. The problem I am having is that the download destination path for the browser is hard coded into a .plist (text config file) file... (5 Replies)
Discussion started by: tret
5 Replies

2. 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

3. Shell Programming and Scripting

Replace string in file with a variable value

Hi Fellows, I am new to shell, please help we me out in this.. i have file which some lines like this.. $$param1='12-jan-2011' $$param2='14-jan-2011' $$param3='30-jan-2011' . . .....so on.. I want to change $$param3 to '31-dec-2011'. i have variable which is storing(30-jan-2011 this... (1 Reply)
Discussion started by: victor369
1 Replies

4. 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

5. Shell Programming and Scripting

How to replace a string with a variable in a file using sed?

I have a file having some text like: PATH_ABC=/user/myLocation I have to replace "/user/myLocation" with a session variable say, $REPLACE_PATH, where $REPLACE_PATH=/user/myReplaceLocation The following sed command is not working. It is writing PATH_ABC=$REPLACE_PATH in the file ... (2 Replies)
Discussion started by: SKhan
2 Replies

6. Shell Programming and Scripting

How to replace a string to asterisk?

Hi, I would like to ask for you idea on how to convert a string to "*". say password and username. I have a shell script that will promt the user to enter username and password. This will be passed to sqlplus command. echo "Please enter user name" read USERNAME echo... (2 Replies)
Discussion started by: reignangel2003
2 Replies

7. Shell Programming and Scripting

Need to use asterisk in variable

Hi All, I am having a challange to pass the asterisk in the variable. Basically, I am writing a shell script to check if a marker file exists but when I am assigning the varialbe it cannot use the wildcard asterisk as expected, therefore, my program is always outputs "Marker file is not... (4 Replies)
Discussion started by: express14
4 Replies

8. UNIX for Dummies Questions & Answers

Replace variable string with text

Hi All, Hoping someone can help.... I am trying to work out how I can ammend a log file to remove variable strings in order to remove confidential information which I cant pass on. As an example I have used phone numbers. A large log file contains multiple lines containing something like the... (6 Replies)
Discussion started by: mutley2202
6 Replies

9. Shell Programming and Scripting

Replace substring from a string variable

Hi, Wish to remove "DR-" from the string variable (var). var="DR-SERVER1" var=`echo $var | sed -e 's/DR-//g'` echo "$var" Expected Output: However, I get the below error: Can you please suggest. (4 Replies)
Discussion started by: mohtashims
4 Replies

10. Shell Programming and Scripting

How to replace string in variable?

Hello, I have simple while and for loops in a shell script and I would like to replace some characters in COL2 when I run it. I am on ubuntu 14.04 while read COL1 COL2 COL3 COL4 do name=$COL2 #cat $name | sed -i "s|_| |g" $name for i in $COL3 $COL4 do some codes ...... run $i b="$name"... (11 Replies)
Discussion started by: baris35
11 Replies
MSSQL_FREE_STATEMENT(3) 												   MSSQL_FREE_STATEMENT(3)

mssql_free_statement - Free statement memory

SYNOPSIS
bool mssql_free_statement (resource $stmt) DESCRIPTION
mssql_free_statement(3) only needs to be called if you are worried about using too much memory while your script is running. All statement memory will automatically be freed when the script ends. You may call mssql_free_statement(3) with the statement identifier as an argument and the associated statement memory will be freed. PARAMETERS
o $stmt - Statement resource, obtained with mssql_init(3). RETURN VALUES
Returns TRUE on success or FALSE on failure. EXAMPLES
Example #1 mssql_free_statement(3) example <?php // Create a new statement $stmt = mssql_init('test'); // Bind values here and execute the statement // once we're done, we clear it from the memory // using mssql_free_statement like so: mssql_free_statement($stmt); ?> SEE ALSO
mssql_bind(3), mssql_execute(3), mssql_init(3), mssql_free_result(3). PHP Documentation Group MSSQL_FREE_STATEMENT(3)
All times are GMT -4. The time now is 01:06 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy