05-06-2005
doing a sed with variables
Hi,
I'm trying to do the following , I have certain variables in a file and then I want to check for these variables in a certain cobol file to see if they contain a certain package if so replace them with value 1 but but that last line is giving problems:
# for each variable in SQL file
for var in `strings $file.vars`
do
# Set char /int patterns
pat_int="^.*$var.*PIC.*9.*$"
if grep "$pat_int" $cobol_file > /dev/null 2>&1
then
value="1"
# substitute variable in SQL file
sed s/:$var/$value/g $file.out > $file.varsub
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I'm trying to do the following , I have certain variables in a file and then I want to check for these variables in a certain cobol file to see if they contain a certain package if so replace them with value 1 but but that last line is giving problems:
# for each variable in SQL file
... (1 Reply)
Discussion started by: seaten
1 Replies
2. UNIX for Dummies Questions & Answers
Hi guys,
I want to replace certain values with the number 1.
But it is also replacing other values which contain the value I want to replace. e.g.:
I want to replace ID-INTERNAL with 1, that's no problem but it will also replace ID-INTERNAL-NON-REM with 1-NON-REM
I don't want to... (10 Replies)
Discussion started by: seaten
10 Replies
3. Shell Programming and Scripting
when i do something like substituting a particular thing with a system variable, i am unable to do that expect the varible name getting into that.
for ex.. i tried,
sed -e 's/date/`date`/g' <if >of
but i got date replaced with "`date`" and not with the actual date ..
same case happened... (5 Replies)
Discussion started by: sskb
5 Replies
4. Shell Programming and Scripting
Hi,
I'm trying to use sed to delete the last three lines of a file. I currently have:
# get the amount of lines in the file
foldernum=`wc -l File_In.txt | cut -c1-8`
# remove the lines in the file
sed "${foldernum}-3,${foldernum}d" File_In.txt > File_Out.txt
I get the error - sed:... (5 Replies)
Discussion started by: Mr_Plow
5 Replies
5. Shell Programming and Scripting
HELP!!!
I'm keep getting "sed: Function s/PETS/dog cannot be parsed."
I have 2 files that list...
# cat FILE1.txt
dog
cat
mouse
# cat FILE2.txt
my pets are
PETS
I put this into a variable...
# A=`cat FILE1.txt`
# sed "s/PETS/$A" FILE2.txt > FILE3.txt (5 Replies)
Discussion started by: Zenwork
5 Replies
6. Shell Programming and Scripting
I'm trying to get sed to cut and replace using variables, but it doesnt seem to work, when I run this the mod time of the file does get updated. Is my syntax incorrect in the sed command?
Thanks
#!/usr/bin/ksh
#Modify header
set -x
HEAD=$(cat PBN2CPR1.TXT | awk 'BEGIN { FS = ","... (1 Reply)
Discussion started by: ddurden7
1 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I am able to use sed if I hardcode the find and replace values in a shell script.
This works:
sed -e 's/123v/4567/g' /path/aaa.txt
> /path/aaa.txt.tmp
If I use a variable, I am not able to use sed command. why?
This doesnot work:
i=abc
j=bk${i}
sed -e 's/${i}/${j}/g'... (5 Replies)
Discussion started by: new_learner
5 Replies
8. Shell Programming and Scripting
Is it possible to place a variable in a sed command as such?
sed 's/ret_Priv()/$var/' <filename>
I am doing this under Bourne. (5 Replies)
Discussion started by: plslakewood
5 Replies
9. Shell Programming and Scripting
All
I am trying to produce the following in /etc/ssh/sshd_config,
# IPv4 only
#ListenAddress 0.0.0.0
# IPv4 & IPv6
ListenAddress ::
to
# IPv4 only
ListenAddress <user-entry>
ListenAddress <user-entry>
# IPv4 & IPv6
#ListenAddress ::
The number of user entries can vary.
... (1 Reply)
Discussion started by: miyoung999
1 Replies
10. Shell Programming and Scripting
Im trying to use sed to print value that matches the value in variable and all lines after that.
grep "Something" test.txt | sed -e '/{$variable}/,$b' -e 'd'
I cant get it work, if I replace the $variable with the value it contains, it works fine... (10 Replies)
Discussion started by: olkkis
10 Replies
LEARN ABOUT DEBIAN
sql::translator::producer::ttschema
SQL::Translator::Producer::TTSchema(3pm) User Contributed Perl Documentation SQL::Translator::Producer::TTSchema(3pm)
NAME
SQL::Translator::Producer::TTSchema -
Produces output using the Template Toolkit from a SQL schema
SYNOPSIS
use SQL::Translator;
my $translator = SQL::Translator->new(
from => 'MySQL',
filename => 'foo_schema.sql',
to => 'TTSchema',
producer_args => {
ttfile => 'foo_template.tt', # Template file to use
# Extra template variables
ttargs => {
author => "Mr Foo",
},
# Template config options
ttargs => {
INCLUDE_PATH => '/foo/templates',
},
},
);
print $translator->translate;
DESCRIPTION
Produces schema output using a given Template Tookit template.
It needs one additional producer_arg of "ttfile" which is the file name of the template to use. This template will be passed a variable
called "schema", which is the "SQL::Translator::Producer::Schema" object created by the parser. You can then use it to walk the schema via
the methods documented in that module.
Here's a brief example of what the template could look like:
database: [% schema.database %]
tables:
[% FOREACH table = schema.get_tables %]
[% table.name %]
================
[% FOREACH field = table.get_fields %]
[% field.name %] [% field.data_type %]([% field.size %])
[% END -%]
[% END %]
See t/data/template/basic.tt for a more complete example.
The template will also get the set of extra variables given as a hashref via the "tt_vars" producer arg.
You can set any of the options used to initiallize the Template object by adding a tt_conf producer_arg. See Template Toolkit docs for
details of the options. (Note that the old style of passing this config directly in the producer args has been deprecated).
$translator = SQL::Translator->new(
to => 'TT',
producer_args => {
ttfile => 'foo_template.tt',
ttargs => {},
tt_conf = {
INCLUDE_PATH => '/foo/templates/tt',
INTERPOLATE => 1,
}
},
);
You can use this producer to create any type of text output you like, even using it to create your own versions of what the other producers
make. For example, you could create a template that translates the schema into MySQL's syntax, your own HTML documentation, your own
Class::DBI classes (or some other code) -- the opportunities are limitless!
Producer Args
ttfile
The template file to generate the output with.
tt_vars
A hash ref of extra variables you want to add to the template.
tt_conf
A hash ref of configuration options to pass to the Template object's constructor.
AUTHOR
Mark Addison <grommit@users.sourceforge.net>.
TODO
More template vars? e.g. [% tables %] as a shortcut for [% schema.get_tables %].
SEE ALSO
SQL::Translator.
perl v5.14.2 2012-01-18 SQL::Translator::Producer::TTSchema(3pm)