Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Formatting File Decryption Output

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Formatting File Decryption Output
# 1  
Old 10-16-2014
Formatting File Decryption Output
Below is the out put of the decrypt command.

Decrypt Command:
/usr/bin/gpg --yes --batch --output file.xml --decrypt file.xml.gpg

Output:
Code:
gpg: encrypted with 2048-bit RSA key, ID 96301328, created 2014-04-29
      "XYZ <xyz@abc.com>"
gpg: encrypted with 2048-bit ELG-E key, ID ECB614CF, created 2002-02-06
      "PQR <pqr@abc.com>"
gpg: encrypted with 2048-bit ELG-E key, ID 1EB07C50, created 2014-02-20
      "MNP (mnp Data Warehouse file encryption key) <mnp@abc.com>"
gpg: WARNING: message was not integrity protected


My requirement is I need to verify if total 3 keys are present in the encrypted file, the only way i think i know is when i decrypt it and then count the email id's. So how could i get the below email ids from the output i pasted above either by redirecting the output or at the time of decryption itself. After i get this i wanted to go in loop or something to increment a variable to get the count of email id's.

Code:
xyz@abc.com
pqr@abc.com
mnp@abc.com

so far i came up with code but still not getting it correctly

HTML Code:
cat decrypt_output | grep @ decrypt_output | awk -F"<*" '{print $2}'
Code:
xyz@abc.com>"
pqr@abc.com>"
mnp@abc.com>"

appreciate your help.
# 2  
Old 10-16-2014
Code:
awk -F"[<>]" '/@/ { print $2 }' inputfile

This User Gave Thanks to Corona688 For This Post:
Ariean
# 3  
Old 10-17-2014
Quote:
Originally Posted by Corona688
Code:
awk -F"[<>]" '/@/ { print $2 }' inputfile

I extended your code further to print the count or line number. But is there a way to print only 3 instead of 7 as it has some additional blank lines in the output file.

awk -F"[<>]" '/@/ {print $2} END{print NR}'

Code:
xyz@abc.com
pqr@abc.com
mnp@abc.com
7

# 4  
Old 10-17-2014
To print a count, one must take a count.
Code:
awk -F"[<>]" '/@/ {L++ ; print $2} END{print L+0}'

This User Gave Thanks to Corona688 For This Post:
Ariean
# 5  
Old 10-18-2014
Hello Ariean,

One more approach for same.
Code:
awk '!/gpg/ {count++;match($0,/<.*>/);print substr($0,RSTART+1,RLENGTH-2)} END{print count}'  Input_file

Output will be as follows.
Code:
xyz@abc.com
pqr@abc.com
mnp@abc.com
3

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
Ariean
# 6  
Old 10-18-2014
Code:
perl -wlne 'if(m/([\w.%+-]+@[\p{Alnum}.-]+\.\p{Alpha}{2,6})/){print $1; $i++} print $i if eof' file

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help needed in formatting the Output file

Hi All, Need your help in resolving the below issue. I've a file called "data.txt" with the below lines: TT: <tell://me/sreenivas> <tell://me/100> TT: <tell://me/sudheer> <tell://me/300> TT: <tell://me/sreenivas> <tell://me/200> TT: <tell://me/sudheer> <tell://me/400> ... (3 Replies)
Discussion started by: raosr020
3 Replies

2. UNIX for Dummies Questions & Answers

decryption of .cpt file

Hi i have the path for encrytion file in unix and i want to decrypt the .cpt file in unix and change the password how can i do that . (3 Replies)
Discussion started by: lily
3 Replies

3. UNIX Desktop Questions & Answers

decryption of .cpt file in unix

can some one help me how to decrypt a .txt.cpt file in unix i Double post (0 Replies)
Discussion started by: lily
0 Replies

4. Shell Programming and Scripting

File output formatting

I have a file that list information about users and want to format the output into columns using Shell scripting. There are about 50 to 75 users. Example current file output fname lname address hiredate dept fname lname address hiredate dept Desired output fname ... (4 Replies)
Discussion started by: daveisme
4 Replies

5. Shell Programming and Scripting

Formatting Output from a file

Hi guys. I'm new to Bash Programming. I've a little problem here. I have a text file, lets say data.txt, with the data: John Tan:Male:20:Singapore Mary:Female:23:Malaysia Abdul Rahman Bin Ali:Male:30:India (: is the delimiter) I want to display it like this: Name Gender Age... (6 Replies)
Discussion started by: andylbh
6 Replies

6. Shell Programming and Scripting

formatting output

my script is as follows cnt=`ps -ef |grep pmon|grep -v grep|awk 'END {{print NR}}'` cnt2=`ps -ef |grep tns|grep -v grep|awk 'END {{print NR}}'` if then if then rman target/ catalog recdb/recdb@recdb cmdfile report_need_backup.sql > report_need_backup.txt ... (1 Reply)
Discussion started by: swkambli
1 Replies

7. UNIX for Dummies Questions & Answers

Identify a file for encryption or decryption

Dear Members, Can we find if a particular file is encrypted or decrypted. I need a command by which i should be able to identify if a file is encrypted or decrypted. How can we do this? (1 Reply)
Discussion started by: sandeep_1105
1 Replies

8. Shell Programming and Scripting

Need help with formatting an output file

Hi guys, I need help with formatting the output of a file. Below is the script I use to generate a file called output.xls. DAY=`TZ=MYT+16 date '+%b'` DAY1=`TZ=MYT+16 date '+%e'` ls -ltr /bscswork_bi2/WORK/UMOBILE/IR/IN/ALL/PROCESSED | grep "$DAY $DAY1" | awk '{print $9}' | sort | cut -c3-7... (4 Replies)
Discussion started by: kumaran21
4 Replies

9. Shell Programming and Scripting

Formatting Output file

Hi, I have a file.... File1: Num Name ID Place ADDR City Country 1024|Name1|ID1|Street1|ADDR1|Boston|UK 1025|Name2|ID3|Street2|ADDR2|London|USA The above file is varaiable length file. I have to insert 2 values in every record of the above file. Output: ... (3 Replies)
Discussion started by: manneni prakash
3 Replies

10. UNIX for Dummies Questions & Answers

File Encryption and Decryption in UNIX.

Hello guys ! I have used "crypt <first> second" command to encrypt "first" to "second" file. i have assign a key for that of course. Now when i try to look content of "seocnd" file through "cat second" command, the file is encrypted and cannot be read which is according to plan. But when... (3 Replies)
Discussion started by: abidmalik
3 Replies
Login or Register to Ask a Question