Assign AWK result to variable [duplicate]

Question

This should be pretty straightfoward and I don't know why I am struggling with it.

I am running the following psql command from within a shell script in order to find out whether all indexes have been dropped before inserting data.

INDEXCOUNT=$(psql -p $dbPort -U enterprisedb -d main_db -c "select Count(*) from all_indexes where index_schema = 'enterprisedb';")

At this point, INDEXCOUNT is equal to “COUNT ------- 0”

Now if I echo the following line I get the result I want -

echo $INDEXCOUNT | awk '{print $3}'

How do I assign the value of $INDEXCOUNT | awk ‘{print $3}’ to a variable to check it in an “IF” statement?

For example:

RETURNCOUNT=$INDEXCOUNT | awk '{print $3}'

nimrodm · Accepted Answer · 2011-05-17 13:39:40Z

79

The following works correctly on bash:

 a=$(echo '111 222 33' | awk '{print $3;}' )
 echo $a # result is "33"

Another option would be to convert the string to an array:

 a="111 222 333"
 b=($a)

 echo ${b[2]}  # returns 333

answered May 17, 2011 at 13:39

nimrodm

24k7 gold badges62 silver badges62 bronze badges

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

1 Comment

user739866 Over a year ago

RETURNCOUNT=$(echo $INDEXCOUNT | awk '{print $3}')

brandizzi · Accepted Answer · 2016-07-05 19:02:09Z

1

You can try this:

RETURNCOUNT=`echo $INDEXCOUNT | awk '{print $3}'`

The idea is to include any shell command between backticks to get the result into a variable.

edited Jul 5, 2016 at 19:02

brandizzi

27.4k9 gold badges111 silver badges171 bronze badges

answered May 17, 2011 at 13:48

Mayank

5,8289 gold badges40 silver badges60 bronze badges

4 Comments

glenn jackman Over a year ago

"$INDEXCOUNT" is unlikely to be a command.

Mayank Over a year ago

@glenn: In that case do echo can be used... The idea is to include any shell command between backticks to get the result into a variable

Silviu Over a year ago

$() is preferred over backticks as it makes nesting commands easier

Toby Speight Over a year ago

Although this code may be help to solve the problem, providing additional context regarding why and/or how it answers the question would significantly improve its long-term value. Please edit your answer to add some explanation.

Dimitre Radoulov · Accepted Answer · 2011-05-17 20:56:57Z

0

Or you can directly use:

${INDEXCOUNT##* }

answered May 17, 2011 at 20:56

Dimitre Radoulov

28.1k4 gold badges42 silver badges50 bronze badges

Comments

fedorqui · Accepted Answer · 2016-07-04 10:45:32Z

0

This might be easier to use for testing with if statement/

INDEXCOUNT="111 222 333"
echo $INDEXCOUNT | awk '{if ($3 == 333) print $3}';

edited Jul 4, 2016 at 10:45

fedorqui

293k112 gold badges592 silver badges640 bronze badges

answered Jul 4, 2016 at 10:43

GoggiP

1

Collectives™ on Stack Overflow

Assign AWK result to variable [duplicate]

4 Answers 4

1 Comment

4 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

4 Comments

Comments

Comments

Linked

Related