split output of bash array into lines

Question

I'm writing a bash script that takes a user name from user input, and displays their AWS access keys and creation dates.

I use jq to parse the output of the command.

The output looks like this:

Enter a user name: 
ralph
User ralph keys:
AKIAJS7KPHZCQRQ5FJWA
2016-08-31T15:38:18Z
AKIAICDOHVTMEAB6RM5Q
2018-02-08T03:55:51Z

How can I split that output so that the access key is listed next to the date?

I want the output to look like this:

AKIAJS7KPHZCQRQ5FJWA : 2016-08-31T15:38:18Z
AKIAICDOHVTMEAB6RM5Q : 2018-02-08T03:55:51Z

This is my code so far:

echo "Enter a user name: "
   read -r user_name

   keys=( $(aws iam list-access-keys --profile=prod  | jq -r '.AccessKeyMetadata[] | (.AccessKeyId, .CreateDate)') )

   echo "User $user_name keys:"
   for key in "${keys[@]}"
     do
       echo "$key"
   done

keithpjolley · Accepted Answer · 2018-07-05 16:15:17Z

2

(note that I changed the aws iam command just a bit.)

$ aws iam list-access-keys  | jq -r '.AccessKeyMetadata[] | (.AccessKeyId, .CreateDate)' | awk 'NR%2{k=$0;next}{print k " : " $0}'
AKIAIXXXXXXXXX : 2014-10-07T14:56:12Z
AKIAIYYYYYYYYY : 2015-01-10T12:18:01Z

In other words, get rid of the loop:

echo "Enter a user name: "
read -r user_name
echo "User $user_name keys:"

aws iam list-access-keys --profile=kpmg-prod  \ 
| jq -r '.AccessKeyMetadata[] | (.AccessKeyId, .CreateDate)') \
| awk 'NR%2{k=$0;next}{print k " : " $0}'

If you are doing something else in that loop:

n=0
for i in $(aws iam list-access-keys  | jq -r '.AccessKeyMetadata[] | (.AccessKeyId, .CreateDate)')
do
  if [ $n -eq 0 ]; then
    id="$i"
    let n=1+$n
  else
    n=0
    date="$i"
    echo "$id : $date"
  fi
done

edited Jul 5, 2018 at 16:15

answered Jul 5, 2018 at 16:03

keithpjolley

2,2931 gold badge20 silver badges23 bronze badges

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

1 Comment

keithpjolley Over a year ago

Shell arrays always confuse me so I try to avoid.

romaric crailox · Accepted Answer · 2018-07-05 15:59:45Z

1

You can try to use tr '\n' ':' that I guess will replace newline caracter by ':' within keys variable

answered Jul 5, 2018 at 15:59

romaric crailox

5841 gold badge3 silver badges16 bronze badges

1 Comment

bluethundr Over a year ago

Thanks, that got me part of the way there. That replaces the newline with the :, but the output is all on one line.

Collectives™ on Stack Overflow

split output of bash array into lines

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related