Bash Parse Variable Values

Question

I have a command and it returns 108 set of week/enumeration:

Command:

impala-shell -B -f query.sql

Results:

20180203        1
20180127        2
20180120        3
...

I parsed the results and read the week and enumeration as two variables. However, I have to use a variable wk to store intermediate results first:

wk="$(impala-shell -B -f query.sql)"
echo "$wk" | while read -r a b; do echo $a--$b; done

I tried to avoid using additional variable wk:

"$(impala-shell -B -f query.sql)" | while read -r a b; do echo $a--$b; done

But it returned:

...
20160213        104
20160206        105
20160130        106
20160123        107
20160116        108: command not found

I understand you can use wk="$(impala-shell -B -f query.sql)" && echo "$wk" | while read -r a b; do echo $a--$b; done but that doesn't avoid using a variable in the middle. How to compose a one-liner without using the variable wk?

Do you mean impala-shell -B -f query.sql | while read -r a b ; do echo $a--$b; done? — choroba
– choroba, Commented Mar 2, 2018 at 16:17

karakfa · Accepted Answer · 2018-03-02 16:25:40Z

1

or awk to the rescue!

$ impala-shell -B -f query.sql | awk '{print $1"--"$2}'

answered Mar 2, 2018 at 16:25

karakfa

67.8k8 gold badges45 silver badges59 bronze badges

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

Comments

Jakob Galbavy · Accepted Answer · 2018-03-02 16:30:02Z

0

You can execute commands first (inline) when using special quotes ``

Try this (untested, as i neither have your shell, nor that script):

`impala-shell -B -f query.sql` | while read -r a b; do echo $a--$b; done

answered Mar 2, 2018 at 16:30

Jakob Galbavy

661 silver badge3 bronze badges

Comments

lovechillcool · Accepted Answer · 2018-03-02 16:34:12Z

0

Most elegant answer goes to choroba in the question comments! You just need to remove the quotes!

impala-shell -B -f query.sql | while read -r a b ; do echo $a--$b; done

answered Mar 2, 2018 at 16:34

lovechillcool

7822 gold badges13 silver badges33 bronze badges

Collectives™ on Stack Overflow

Bash Parse Variable Values

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related