Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

How to Unmask/Decrypt an XML file?

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers How to Unmask/Decrypt an XML file?
# 15  
Old 12-05-2013
-v sets a variable. RS="<" won't work without the -v in front of it.
# 16  
Old 12-13-2013
Quote:
Originally Posted by Corona688
-v sets a variable. RS="<" won't work without the -v in front of it.
Hello,

For some reason your awk statement doesn't work for the below data embedded in a FILE, it doesn't return any data. May i please know what could be the reason??

Code:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<Provider PROVIDER="6" SCHEMA_VERSION="2.5" xmlns="http://www.abc.gov" xsi:schemaLocation="http://www.abc.gov/ abc.xsd http://www.abc.gov http://www.abc.gov" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

Code:
tr -d '\000' < FILE | awk -v RS="<" -F'"' '/[pP][rR][oO][vV][iI][dD][eE][rR]/ {for(i=1;i++<=NF;)if($i~/[pP][rR][oO][vV][iI][dD][eE][rR]/) print $(i+1) }'

Thank you.
# 17  
Old 12-13-2013
It must be finding the wrong 'provider' label.
Code:
tr -d '\000' < inputfile.xml | awk -v RS="<" -F'"' '/[pP][rR][oO][vV][iI][dD][eE][rR]=/ {for(i=1;i++<=NF;)if($i~[pP][rR][oO][vV][iI][dD][eE][rR]) print $(i+1) }'

# 18  
Old 12-13-2013
no luck/output. initially i got some error and i fixed your statement. But it didn't worked either.

Code:
tr -d '\000' < inputfile.xml | awk -v RS="<" -F'"' '/[pP][rR][oO][vV][iI][dD][eE][rR]=/ {for(i=1;i++<=NF;)if($i~/[pP][rR][oO][vV][iI][dD][eE][rR]=/) print $(i+1) }'

But when i put RS="" i am getting the output, but again its impacting other input xml files printing extra lines.

Code:
http://www.abc.gov
7

# 19  
Old 12-13-2013
Of course it does... it considers the entire line one record...
# 20  
Old 12-13-2013
Try:
Code:
iconv -f utf-16 -t utf-8 test.xml > test_utf8.xml

This User Gave Thanks to radoulov For This Post:
Ariean
# 21  
Old 12-13-2013
How about this:

Code:
tr -d '\000' < inputfile.xml | awk -v RS="<" -F'"' '/[pP][rR][oO][vV][iI][dD][eE][rR]=/ {for(i=1;i<=NF; i++)if($i~/[pP][rR][oO][vV][iI][dD][eE][rR]=/) print $(i+1) }'

This User Gave Thanks to Corona688 For This Post:
Ariean
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Encrypt and Decrypt a File with Password

Hello, I have few files on unix which are payroll related and I need them to encrypt with password so others wouldn't see the data. I use ETL tool and would like to know the unix command that does encryption/decryption to use in the ETL. Thank you, Sri (3 Replies)
Discussion started by: eskay
3 Replies

2. Shell Programming and Scripting

How to Change group and Unmask it to 027 in Linux?

I want to propose a change to the run script environment. This would change the effective group of the wsadmin account to prodview with a umask of 027 before running our services. In linux this can be accomplished by the following #!/bin/ksh # # Original shell # newgrp prodview <<... (1 Reply)
Discussion started by: sindhu puja
1 Replies

3. UNIX for Advanced & Expert Users

How to decrypt a file in UNIX?

I have a file which contains encrypted data. Can anyone tell me how to decrypt the file? (14 Replies)
Discussion started by: saga20
14 Replies

4. UNIX for Dummies Questions & Answers

How to decrypt any file in UNIX?

How to decrypt a file in unix? I dont know the type of decryption nor the type of text data it contains. We extracted the file from sfdc & need to process it in unix. When extracted, we get encrypted data in the file. The file content is- ... (0 Replies)
Discussion started by: saga20
0 Replies

5. Shell Programming and Scripting

Need to decrypt a file in a directory (SHL script)

I need to decrypt a file in a directory, I need to write a shl scrip & cron job How I find the files in the directory: the file is like this: dailypayments_sfs_payment_201011151800.dat -d The decrypt command: gpg -o dailypayments_sfs_payment_201011151800.dat -d 20101115 (the date... (7 Replies)
Discussion started by: rechever
7 Replies

6. Shell Programming and Scripting

decrypt the file

Hello all I am getting a encrypted file (.pgp) and a key which i have to use to decrypt that file. I couldn't understand where to put the key on my unix box so that decryption happens. Please reply. (2 Replies)
Discussion started by: vasuarjula
2 Replies

7. UNIX for Advanced & Expert Users

Decrypt a GPG file through shell script

Hi, I'm trying to decrypt a gpg file thorugh a shell script. But i' could'nt. My script is , -sh-3.1$ cat test_gpg.sh #!/bin/ksh echo " Hello, iam testing GPG" gpg prabhu.txt.gpg <<EOF prompt prabhu EOF exit 0 The file i'm trying to decrypt is prabhu.txt.gpg and my passphrase is... (1 Reply)
Discussion started by: apsprabhu
1 Replies

8. UNIX for Dummies Questions & Answers

Unmask

Hi All, I'm a newbie to UNIX I'm learning AIX 5l Basics I'm unable to execute UNMASK command as mentioned. Could any one help me. (6 Replies)
Discussion started by: udayakumar
6 Replies

9. Shell Programming and Scripting

How to encrypt and decrypt a file

How to encrypt and decrypt a file using unix Command? Can any one help me? (2 Replies)
Discussion started by: laknar
2 Replies

10. Solaris

Decrypt Des file - then encrypt

Help.. I need to decrypt a file that was encrypted using DES 56 Bit. I have the encryption key and the block size used but no idea what utility to use.. I then need to encrypt the file using pgp and another key I have.. againt I dont know what utility to use. I am running solaris 9 .... ... (0 Replies)
Discussion started by: frustrated1
0 Replies
Login or Register to Ask a Question