string manipulation in unix

Linux and Unix-Like Linux
1

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 !

2

Maybe something like this:

echo ${CNTR_NM} | awk -v a="'" '{print a$1a, $2}'

Output:

3

try this

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'" | read container upages

echo "'${container}' ${upages}"
4

Thanks a lot Rubin . It solved the problem !