Create columns using sed data (bash only)

Question

I am relatively new to bash text editing commands and am trying to improve my skills so please bear with me!

I'm looking to write a simple command sequence for locating all SSL certificates on my platform and my ideal output would be three columns for the path, the filename and the expiry.

OK so far I have something like this:

sudo find / -type f \( \( -name "*.pem" -o -name "*.crt" \) ! -path "/unwanted/search/location/*" \) -exec sh -c 'echo {}; true' \; -exec openssl x509 -enddate -noout -in {} \; | sed s/notAfter=// | sed -r 's:/([a-Z0-9._-]*)$:\r\n\1:' | sed 's/GMT/&\n/'

This produces a usable output (am took me some fiddling to get functional). Here is some example output:

/etc/pki/tls/certs
gogs.crt
Feb  8 23:59:59 2018 GMT

/etc/pki/tls/certs
sample.crt
Jan 18 23:59:59 2018 GMT

Finally its question time - what tools should i leverage to reformat that to the following:

/etc/pki/tls/certs  gogs.crt   Feb  8 23:59:59 2018 GMT
/etc/pki/tls/certs  sample.crt Jan 18 23:59:59 2018 GMT

Straight columns are ideal, but not my initial goal - for now I really just wanted to understand how to improve my stream processing skills, surely there must be a way of stating:

Use output from last command, collapse the line breaks, replace with "tab", add linefeed, move onto next.

Is anyone able to offer some advice? Attempts to date have caused some nightmarish output - i would add an example if that wasn't going to add to the confusion!

Thanks readers!

Answer 1

You can modify like below inside -exec sh -c ' .... '

-exec sh -c 'file="${0##*/}"; path="${0%/*}"; expiry=$(openssl x509 -enddate -noout -in "$0" | sed "s/notAfter=//");  echo "$path $file $expiry"' {} \;

• file="${0##*/}"; - Get filename

• path="${0%/*}"; - Get path

• expiry=$(openssl x509 -enddate -noout -in "$0" | sed "s/notAfter=//"); - Get expiry date

• echo "$path $file $expiry" - print all variable at the end

It will become :

sudo find / -type f \( \( -name "*.pem" -o -name "*.crt" \) ! -path "/unwanted/search/location/*" \) -exec sh -c 'file="${0##*/}"; path="${0%/*}"; expiry=$(openssl x509 -enddate -noout -in "$0" | sed "s/notAfter=//");  echo "$path $file $expiry"  ' {} \;

Answer 2

your command|awk 'NF{ORS=(NR%3?FS:RS);print}'|column -t

Answer 3

The following precisely does what you asked for (Use output from last command, collapse the line breaks, replace with "tab", add linefeed, move onto next.):

awk -v RS= -F'\n' -v OFS='\t' '{$1=$1}1'

but adding yet another command to your pipeline isn't a great approach vs just using one script to do it all. If you ask a new question and post the output of the part of your script before the seds pipeline (i.e. the input to sed s/notAfter=// | sed -r 's:/([a-Z0-9._-]*)$:\r\n\1:' | sed 's/GMT/&\n/) as sample input and the expected output you want after processing that input then I'm sure someone can help you with that.