How to tweak output by awk to make an array?

sysmicuser · 03-04-2019, 09:58 PM

Hey Guys,

I am using az vm list command to list all host which have been provisioned so far like below:

Code:

az vm list --output=table|grep NXT|awk '{ print $1}'
NXTPREPAOS-1
NXTPREPAOS-2
NXTPREPAOS-3
NXTPREPAOS-4
NXTPREPAOS-5
NXTPREPSQL-1
NXTPREPSQL-2

Instead, I want to have something like this
"NXTPREPAOS-1" "NXTPREPAOS-2" "NXTPREPAOS-3" etc

Possible to achieve it easily?
The reason being, I can use it as an array straight away and perform operations on the array, how to achieve it.

Kindly assist.

Thanks

syg00 · 03-04-2019, 10:36 PM

This should be in your other thread, not forked into another with no detail.

Attack the problem, not a symptom - fix the array assignment in your script.

sysmicuser · 03-04-2019, 10:38 PM

Ok, sometimes people prefer separate thread hence I created here, more than happy to get it married with other thread.

grail · 03-05-2019, 12:39 AM

As a note to anyone coming across this thread:

- the grep is not needed as awk can already do this

- assuming you are talking a bash array, it uses IFS variable when looking at items to assign to an array, so new lines are not a problem

Code:

array=($(az vm list --output=table | awk '/NXT/{print $1}'))

sysmicuser · 03-05-2019, 07:11 AM

@grail, that's awesome. Thank you so much matey