05-07-2008
string manipulation in unix
Hi,
I have a question . I have script which gets info from db2 engine.
The script is
cat sample_substitute.sh
CNTR_NM=`db2 -x "select CONTAINER_NAME ,usable_pages from table( SNAPSHOT_CONTAINER('TST103',-1)) as SNAPSHOT_CONTAINER, syscat.tablespaces where
tablespace_name = tbspace and tbspacetype = 'D' and tbspace='TSOPS06'" `
echo ${CNTR_NM}
The output is like this
/dmpath/dmtiadm1/db2fs1p00/tsops06 2128
But I am trying to get the output like this
'/dmpath/dmtiadm1/db2fs1p00/tsops06' 2128
i.e. the string inside the single quote.
Thanks again in advance !
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, I have searched this long and hard and don't seem to see another post on this issue.
I have two strings each with the same characters but in a different order.
String1=”word”
String2=”dwor”
I want to test them to show their similarity. Unfortunately I can't do a sort so that they will... (9 Replies)
Discussion started by: Cactus Jack
9 Replies
2. Shell Programming and Scripting
i have a file that contains a pattern like this:
ajay 1234 newyork available
kumar 2345 denver
singh 2345 newyork
ajay 3456 denver
kumar 3456 newyork
singh 3456 delhi available
ajay 4567 miami
kumar 4567 miami
singh 4567 delhi
i want to search for each line... (5 Replies)
Discussion started by: ajay41aj
5 Replies
3. UNIX for Dummies Questions & Answers
Guy
I have this below report and I need someone help me formatting it
SID File Name Started Finished Backup
ABC XYZ.log 10Sep09-012857\n 10Sep09-020748 Successful
I need Started & Finished columns to be formatted as
... (1 Reply)
Discussion started by: anjum.suri
1 Replies
4. Shell Programming and Scripting
if I have two string variable, how do I add one to anther.
like
a= "a"
b="b"
c=$a+$b
but that doesn't work.
Is there anyway to solve it.http://www.qtl.co.il/img/copy.pnghttp://www.google.com/favicon.icohttp://www.babylon.com/favicon.icohttp://www.morfix.com/favicon.ico (2 Replies)
Discussion started by: programAngel
2 Replies
5. Homework & Coursework Questions
Write a shell program to display the position of the right - most character in a given input string.
Example :
Input : RAHUL
Output : L is in the 5th position
also tell me how to count length of string and how to find the position of specific character in left most side.
Homework... (0 Replies)
Discussion started by: shashwat2691
0 Replies
6. UNIX for Dummies Questions & Answers
Dear All,
I have a question.
I have files with the following pattern.>S8_SK1.chr01
NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
NNNNNNNNNNNNNNNNNNNCAGCATGCAATAAGGTGACATAGATATACCCACACACCACACCCTAACACTAACCCTAATCTAACCCTGGCCAACCTGTTT... (13 Replies)
Discussion started by: pawannoel
13 Replies
7. Shell Programming and Scripting
hi all,
i am new to shell scripting and need help.
i have a string that stores the month in Jan/Feb/Mar format. i need to convert it to number like 01 for jan, 12 for dec etc.
i am using the following sed command,
echo "Enter a Month eg. Jan/Feb : "
read MONTHEND
... (9 Replies)
Discussion started by: anupom2000
9 Replies
8. Shell Programming and Scripting
i have something like this...
echo "teCertificateId" | awk -F'Id' '{ print $1 }' | awk -F'te' '{ print $2 }'
Certifica
the awk should remove 'te' only if it is present at the start of the string.. anywhere else it should ignore it.
expected output is
Certificate (7 Replies)
Discussion started by: vivek d r
7 Replies
9. Shell Programming and Scripting
Hi ,
I am getting a string like
aaa,bbb,sdsdad,sdfsdf,sdfsdfdsf,rtyrtyr,45654654,ddfdfdfgdfg,dfgdfgdg...........
Now what I need is to format it.
So after each nth comma I need one newline. So the above will look like
when n=3
aaa,bbb,sdsdad,
sdfsdf,sdfsdfdsf,rtyrtyr,... (4 Replies)
Discussion started by: Anupam_Halder
4 Replies
10. Shell Programming and Scripting
I'm making a little game in Perl, and I am trying to remove the first instance of a character in an arbitrary string. For example, if the string is
"cupcakes"and the user enters another string that contains letters from "cupcake" e.g:
"sake"the original string will now look like this (below)... (3 Replies)
Discussion started by: whyte_rhyno
3 Replies
LEARN ABOUT DEBIAN
mysql::diff
MySQL::Diff(3pm) User Contributed Perl Documentation MySQL::Diff(3pm)
NAME
MySQL::Diff - Generates a database upgrade instruction set
SYNOPSIS
use MySQL::Diff;
my $md = MySQL::Diff->new( %options );
my $db1 = $md->register_db($ARGV[0], 1);
my $db2 = $md->register_db($ARGV[1], 2);
my $diffs = $md->diff();
DESCRIPTION
Generates the SQL instructions required to upgrade the first database to match the second.
METHODS
Constructor
new( %options )
Instantiate the objects, providing the command line options for database access and process requirements.
Public Methods
Fuller documentation will appear here in time :)
o register_db($name,$inx)
Reference the database, and setup a connection. The name can be an already existing 'MySQL::Diff::Database' database object. The index
can be '1' or '2', and refers both to the order of the diff, and to the host, port, username and password arguments that have been
supplied.
o db1()
o db2()
Return the first and second databases registered via "register_db()".
o diff()
Performs the diff, returning a string containing the commands needed to change the schema of the first database into that of the
second.
COPYRIGHT AND LICENSE
Copyright (c) 2000-2011 Adam Spiers. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
same terms as Perl itself.
SEE ALSO
mysqldiff, MySQL::Diff::Database, MySQL::Diff::Table, MySQL::Diff::Utils
AUTHOR
Adam Spiers <mysqldiff@adamspiers.org>
perl v5.14.2 2012-04-06 MySQL::Diff(3pm)