Welcome to forums, could you please try following and let me know if this helps you.
Code:
sed -n '/SQL ID\:\ '"${vSQL_ID}"'/!b;:a;/\*\*\*\*\*\*\*\*\*\*\*\*/!{$!{N;ba}};{/*/p}' Input_file
OR
sed -n "/SQL ID\:\ ${vSQL_ID}/!b;:a;/\*\*\*\*\*\*\*\*\*\*\*\*/!{$!{N;ba}};{/*/p}" Input_file
As sample(test) Input_file was not provided so couldn't test it.
Hi ,
Seen some of wonderful posts. Please have look at my problem.
I have a text file ketkee.txt , which look like below.
GATES := apple mango banana
XMLCHECK := red blue green pink
My requiement is to find the line that has XMLCHECK in it. and append two variables followed by a space... (2 Replies)
I want to instert Category:XXXXX into the 2. line
something like this should work, but I have somewhere the wrong sytanx. something with the linebreak goes wrong:
sed "2i\\${n}Category:$cat\n"
Sample:
Titel Blahh Blahh abllk sdhsd sjdhf
Blahh Blah Blahh
Blahh
Should look like... (2 Replies)
I know this script is crummy, but I was just messing around.. how do I get sed's insert command to allow variable expansion to show the filename?
#!/bin/bash
filename=`echo $0`
/usr/bin/sed '/#include/ {
i\
the filename is `$filename`
}' $1
exit 0 (8 Replies)
Hi,
I am trying to do the following thing
var='date'
$var
Above command substitutes date for and in turn runs the date command and i am getting the todays date value.
I am trying to do the same thing as following, but facing some problems,
unique_host_pro="sed -e ' /#/d'... (3 Replies)
I have file File1.txt in which i have to replace a text using sed command
File1.txt contents
EURAMOUNTTOBEREPLACED
I have a AIX shell script for replacing the text AMOUNTTOBEREPLACED
Contents of the shell script
sum=27
sed 's/AMOUNTTOBEREPLACED/"$sum"/g' File1.txt >> temp
mv temp... (5 Replies)
Hi,
I want to insert some text in the begning of each line. But issue is the text that i want to insert is stored into one variable. so my command look like
constr="`date | awk '{print $3"-"$2"-"$6}'`",MXGBTST1" "
sed 's/^/\$constr/g' alert_temp.csv
but sed command instead of taking... (3 Replies)
Hi All,
Can I use a variable (using this variable as a counter) in sed cmd?
something like below
sed -n '${COUNT}p'
But it's not working. Pls help.
Thanks.
Regards,
Amee
export COUNT=1
export COUNTER=`cat ${BINPATH}/$ALLOC_FILE.clean_1 | wc -l | tr -d " "`
while ... (3 Replies)
I am using a shell script in fedora linux. While calling to the shell I am also passing an argument (var1=0.77) like shown below
sh gossip.sh var1=0.77
in the shell following command is written (which doesn't work)
sed - i -e 's@prob=@prob="$var1";//@g' file.txt
Actually i want the... (7 Replies)
Hi All,
How can i use a variable in a sed command ? I cant seem to get it to work as at present its just printing $i at the start of every line rather than the variable $1.
sed -e "s/^/\$i,|/"
Any help would be appreciated. (3 Replies)
Hi All,
Please help me with the below problem
if
then
$a=" "
fi
echo "ABC1abc" | sed 's/a/'$a'/'
The required output is : ABC abc
But I am getting the below error:
sed: -e expression #1, char 4: unterminated `s' command
Please help. (6 Replies)
Discussion started by: rahulsk
6 Replies
LEARN ABOUT DEBIAN
sql::translator::producer::sqlserver
SQL::Translator::Producer::SQLServer(3pm) User Contributed Perl Documentation SQL::Translator::Producer::SQLServer(3pm)NAME
SQL::Translator::Producer::SQLServer - MS SQLServer producer for SQL::Translator
SYNOPSIS
use SQL::Translator;
my $t = SQL::Translator->new( parser => '...', producer => 'SQLServer' );
$t->translate;
DESCRIPTION
This is currently a thin wrapper around the nextgen SQL::Translator::Generator::DDL::SQLServer DDL maker.
Extra Attributes
field.list
List of values for an enum field.
TODO
* !! Write some tests !!
* Reserved words list needs updating to SQLServer.
* Triggers, Procedures and Views DO NOT WORK
# Text of view is already a 'create view' statement so no need to
# be fancy
foreach ( $schema->get_views ) {
my $name = $_->name();
$output .= "
";
$output .= "--
-- View: $name
--
" unless $no_comments;
my $text = $_->sql();
$text =~ s/
//g;
$output .= "$text
GO
";
}
# Text of procedure already has the 'create procedure' stuff
# so there is no need to do anything fancy. However, we should
# think about doing fancy stuff with granting permissions and
# so on.
foreach ( $schema->get_procedures ) {
my $name = $_->name();
$output .= "
";
$output .= "--
-- Procedure: $name
--
" unless $no_comments;
my $text = $_->sql();
$text =~ s/
//g;
$output .= "$text
GO
";
}
SEE ALSO
SQL::Translator
AUTHORS
See the included AUTHORS file: http://search.cpan.org/dist/SQL-Translator/AUTHORS <http://search.cpan.org/dist/SQL-Translator/AUTHORS>
COPYRIGHT
Copyright (c) 2012 the SQL::Translator "AUTHORS" as listed above.
LICENSE
This code is free software and may be distributed under the same terms as Perl itself.
perl v5.14.2 2012-05-10 SQL::Translator::Producer::SQLServer(3pm)