UNIX for Dummies Questions & Answers

I have a file abc.txt as below :

<dbport oa_var="s_dbport" oa_type="EXT_PORT" base="1521" step="1" range="-1" label="Database Port">1616</dbport>
<rpc_port oa_var="s_rpcport" oa_type="PORT" base="1626" step="1" range="-1" label="RPC Port">1721</rpc_port>
<web_ssl_port oa_var="s_webssl_port" oa_type="PORT" base="4443" step="1" range="-1" label="Web SSL Port">4538</web_ssl_port>
<ons_localport oa_var="s_ons_localport" oa_type="PORT" base="6100" step="1" range="-1" label="ONS Local Port">6195</ons_localport>
<ons_remoteport oa_var="s_ons_remoteport" oa_type="PORT" base="6200" step="1" range="-1" label="ONS Remote Port">6295</ons_remoteport>
<ons_requestport oa_var="s_ons_requestport" oa_type="PORT" base="6500" step="1" range="-1" label="ONS Request Port">6595</ons_requestport>
<web_port oa_var="s_webport" oa_type="PORT" base="8000" step="1" range="-1" label="Web Listener Port">8095</web_port>
<activewebport oa_var="s_active_webport" oa_type="DUP_PORT" base="8000" step="1" range="-1" label="Active Web Port">8095</activewebport>
<forms_port oa_var="s_formsport" oa_type="PORT" base="9000" step="1" range="-1" label="Forms Port">9095</forms_port>
<met_data_port oa_var="s_metdataport" oa_type="PORT" base="9100" step="1" range="-1" label="Metrics Server Data Port">9195</met_data_port>
<met_req_port oa_var="s_metreqport" oa_type="PORT" base="9200" step="1" range="-1" label="Metrics Server Request Port">9295</met_req_port>

Output of cat abc.txt | grep s_dbport command is

<dbport oa_var="s_dbport" oa_type="EXT_PORT" base="1521" step="1" range="-1" label="Database Port">1616</dbport>

How can I extract base="1521" from above output. Any help would be greatly appreciated.

Try something like this:

Code:

awk -F"\"" '/s_dbport/{print $6}'

Regards

using Perl:

Code:

perl -nl -e 'if(/s_dbport/) { if(/base="(\d+)"/) { print $1; } }' abc.txt

Thanks for reply Franklin52 and Yogesh Sawant. I am not able to get whole command working since I am not able to pass value to suggested command through variable. Below command does not work.

$xmlparamdynamic=s_dbport
$base_value=`cat abc.txt | awk -F"\"" '/$xmlparamdynamic/{print $6}'`

Any helps is appreciated.

try this one
cat abc.txt | grep s_dbport | awk -F" " '{ print $4 }'

that's another case of useless use of cat. this would suffice:

Code:

grep s_dbport abc.txt | awk -F" " '{ print $4 }'

the awk solution provided by franklin52 even eliminates use of grep

With a variable the command should looks like:

Code:

$xmlparamdynamic=s_dbport
$base_value=`awk -F"\"" '/'$xmlparamdynamic'/{print $6}' abc.txt`

Regards