extract/split from string in bash

Question

I have a set of commands in a bash script, eg running a query in impala.

#! /bin/sh
RESULT=`impala-shell -q "select count(*) from testable"`

The result of the shell script is.

Starting Impala Shell without Kerberos authentication
Connected to mycomp.cool-cluster.com:21000
Server version: impalad version 2.0.0-cdh5 RELEASE (build 12323323)
Query: select count(*) from enriched_call
Fetched 1 row(s) in 0.62s
+----------+ | count(*) | +----------+ | 234343 | +----------+

I would want to get only the value from this output ie, 234343 and try to assert the count in a script using Regex, split etc.

If I try to eliminate non numeric vaules, numbers from the version also come in. I want to split by say '|' and get the value 234343

Gilles Quénot · Accepted Answer · 2014-11-27 21:04:05Z

2

Try doing this :

RESULT=$(
    impala-shell -q "select count(*) from testable" |
        awk -F'|' 'END{print $4}'
)

answered Nov 27, 2014 at 21:04

Gilles Quénot

188k43 gold badges232 silver badges229 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

glenn jackman · Accepted Answer · 2014-11-27 21:35:56Z

0

RESULT=$( impala-shell -q "..." | tail -n 1 | grep -o '[[:digit:]]\+' )

or

RESULT=$( impala-shell -q "..." | sed -n '$s/[^[:digit:]]//gp' )

answered Nov 27, 2014 at 21:35

glenn jackman

249k42 gold badges233 silver badges362 bronze badges

Collectives™ on Stack Overflow

extract/split from string in bash

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related