shorten awk command pipes

Question

fairly new to using linux on shell. I want to reduce the amount of pipes I used to extract the following data. V 190917135635Z 1005 unknown /C=DE/ST=City/L=City/O=something/OU=Somewhat/CN=someserver.com/[email protected] My goal is to put the following values into a separate file 190917135635 someserver.com The command I use right now is fairly long, piped and looks like this grep -v '^R' $file | awk '{print $2, $6}' | awk -F'[=|/]' '{print $1, $3}' | awk '{print $1, $3}' | awk -F 'Z ' '{print $1, $2}' > sdata.txt (The file contains other lines starting with 'R' so I exclude those in my grep) Is this a legit way of doing it? Is there a way to get this in a shorter command? Thanks a lot! JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

Another awk. Using match to find CN entry and substr to extract it for print to print, if it exists. $ awk '!/^R/{ print $2, (match($0,/CN=[^/]+/)?substr($0,RSTART+3,RLENGTH-3):"") # 3==length("CN=") }' file Output: 190917135635Z someserver.com