Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Fetch Data from File using UNIX or Perl

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Fetch Data from File using UNIX or Perl
# 1  
Old 01-17-2013
Fetch Data from File using UNIX or Perl
Hello, How All are Doing today. I have a issue, I have a file which contains the data as follow
Code:
<ENVELOPE><ENVELOPE_ID>TEST</ENVELOPE_ID><ENVELOPE_EXTERNAL_ID></ENVELOPE_EXTERNAL_ID><ENVELOPE_VERSION>2</ENVELOPE_VERSION><SIResourceDefaultVersion>true</SIResourceDefaultVersion><TYPE>GS GE</TYPE><NAME>EHEN700_835_NET001169_GS_OB</NAME><STANDARD>X12</STANDARD><CONTROL_NUMBER>1</CONTROL_NUMBER><FUNCTION>0</FUNCTION><EXTENDS_ID>pisces:177b9b:101ce560141:-1680</EXTENDS_ID><EXTENDS_VERSION>2</EXTENDS_VERSION><SENDER_ID>xNotUsed</SENDER_ID><RECEIVER_ID>Notused</RECEIVER_ID><COMMENTS>Not used-Name not editable</COMMENTS><USERNAME>bemero</USERNAME><CREATE_DATE>2009-08-14 18:30:19.0</CREATE_DATE><USES_GLOBAL_CONTROL_NUMBER>0</USES_GLOBAL_CONTROL_NUMBER><ENVELOPE_PARMS><ENVELOPE_PARM><NAME>AcknowledgementOverdueTime</NAME><VALUE></VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>AcknowledgementOverdueTimeMinutes</NAME><VALUE></VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>ExpectAcknowledgement</NAME><VALUE>NO</VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>GenOpts1</NAME><VALUE></VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>GenCtrlNameOpts2</NAME><VALUE></VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>GenCtrlNameOpts3</NAME><VALUE></VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>GenCtrlNumNameFuncGrpID1</NAME><VALUE></VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>GenCtrlNumNameFuncGrpID2</NAME><VALUE></VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>GenCtrlNumNameFuncGrpID3</NAME><VALUE></VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>GenCtrlNumNameGrpVersion1</NAME><VALUE></VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>GenCtrlNumNameGrpVersion2</NAME><VALUE></VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>GenCtrlNumNameGrpVersion3</NAME><VALUE></VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>GenCtrlNum</NAME><VALUE></VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>GenCtrlNumTestIndicator2</NAME><VALUE></VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>GenCtrlNumTestIndicator3</NAME><VALUE></VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>global_control_no</NAME><VALUE>NO</VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>GroupFunctionalIDCode</NAME><VALUE>HP</VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>GroupResponsibleAgencyCode</NAME><VALUE>X</VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>GroupVersionReleaseIDCode</NAME><VALUE>004010X091A1</VALUE><INHERITED>true</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>NextEnvelope</NAME><VALUE>pisces:ab95e6:112f6d69926:6031</VALUE><INHERITED>false</INHERITED></ENVELOPE_PARM></ENVELOPE_PARMS></ENVELOPE><ENVELOPE><ENVELOPE_ID>DONE SERVER</ENVELOPE_ID><ENVELOPE_EXTERNAL_ID></ENVELOPE_EXTERNAL_ID><ENVELOPE_VERSION>3</ENVELOPE_VERSION><SIResourceDefaultVersion>true</SIResourceDefaultVersion><TYPE>GS GE</TYPE><NAME>0001_835 GS OB</NAME><STANDARD>X11</STANDARD><CONTROL_NUMBER>35</CONTROL_NUMBER><FUNCTION>0</FUNCTION><EXTENDS_ID></EXTENDS_ID><EXTENDS_VERSION>-1</EXTENDS_VERSION><SENDER_ID>HPHC0001B</SENDER_ID><RECEIVER_ID>HPHC</RECEIVER_ID><COMMENTS>.</COMMENTS><USERNAME>jkumar</USERNAME><CREATE_DATE>2005-04-06 13:26:16.0</CREATE_DATE><USES_GLOBAL_CONTROL_NUMBER>0</USES_GLOBAL_CONTROL_NUMBER><ENVELOPE_PARMS><ENVELOPE_PARM><NAME>AcknowledgementOverdueTime</NAME><VALUE></VALUE><INHERITED>false</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>ExpectAcknowledgement</NAME><VALUE>NO</VALUE><INHERITED>false</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>global_control_no</NAME><VALUE>NO</VALUE><INHERITED>false</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>GroupFunctionalIDCode</NAME><VALUE>HP</VALUE><INHERITED>false</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>GroupResponsibleAgencyCode</NAME><VALUE>X</VALUE><INHERITED>false</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>GroupVersionReleaseIDCode</NAME><VALUE>004TEST1</VALUE><INHERITED>false</INHERITED></ENVELOPE_PARM><ENVELOPE_PARM><NAME>NextEnvelope</NAME><VALUE>pisces:177b9b:101c746e489:2815</VALUE><INHERITED>false</INHERITED></ENVELOPE_PARM></ENVELOPE_PARMS></ENVELOPE>

What I want to do is I want to fetch the data in between

starting with <NAME>
ending with this </NAME><STANDARD>X12</STANDARD>

**************************************************************

starting with <NAME>NEXTENVELOPE</NAME><VALUE>
ending with this </VALUE>

So the result should be
EHEN700_835_NET001169_GS_OB ---- pisces:ab95e6:112f6d69926:6031

Like this there are number of records.
# 2  
Old 01-17-2013
Code:
perl -ne '(/<NAME>(.+?)<\/NAME><STANDARD>X12<\/STANDARD>/) && print "$1 ---- "; (/<NAME>NextEnvelope<\/NAME><VALUE>(.+?)<\/VALUE>/) && print "$1\n"' file

or

Code:
perl -ne '(/<NAME>(.+?)<\/NAME><STANDARD>X12<\/STANDARD>.*?<NAME>NextEnvelope<\/NAME><VALUE>(.+?)<\/VALUE>/) && print "$1 ---- $2\n"' file

This User Gave Thanks to balajesuri For This Post:
adisky123
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Fetch data from file

Hi, I am new to scripting. I have a log file and need to fetch specific logs and copy to another file. A copy of the log is like this: =============================================================== = JOB : server123#jobs1.jobstream1 = USER : andyc = Tue 08/01/17... (3 Replies)
Discussion started by: Prngp
3 Replies

2. UNIX for Beginners Questions & Answers

How to fetch specific data from a file.?

Hi , I have a file which contains 2 days logs(here it is 24 and 25) I want to list data only for date 25 fron the file. please suggest me how should i get this. file content mentioned below 17-05-24 Name Succ Fail 00:00:29 ... (5 Replies)
Discussion started by: scriptor
5 Replies

3. UNIX for Dummies Questions & Answers

how to fetch data in unix

Hi All, I have a file with the below data as shown. A|2|20120430 B|EMP|NAME|DEPT C|12|SARC|01 C|23||ASDD|02 D|END OF FILE I want to fetch only the records that contains C|, what is unix command to fetch this data. Thanks (5 Replies)
Discussion started by: halpavan2
5 Replies

4. Shell Programming and Scripting

Fetch data between two dates from a file

Hi All, I m new to this forum & UNix too. currently i have a requirement which can fetch data from a logfile between two dates or timestamp. for example: 1. data from 2012 Jun to 2012 Jul 2. data from 2012 Jun to 2012 Jul 07 3. data from 2012 Jun 16 10:20 to 2012 Jul 03 10:10 Please... (7 Replies)
Discussion started by: KDMishra
7 Replies

5. Shell Programming and Scripting

Fetch the different data by searching with a same variable from a file in AIX server

Hi, I am trying to fetch the different values in an xml file by searching with the same variable in AIX Server. <name>SharedResources/Shared/JNDI/Username</name> <value>admin</value> <name>SharedResources/Shared/JNDI/Username</name> ... (1 Reply)
Discussion started by: tejastrikez
1 Replies

6. Shell Programming and Scripting

How to fetch data between two timestamps in a file using KSH

Hi, I got a requirement to fetch data between two time stamps in a big log file and grep for a word in that particular time interval of data. Here is my log looks like: 2012/04/08-14:35:56 Abcdefg 2012/04/08-14:35:56 Hijklmnophhoishfw 2012/04/08-14:35:56... (1 Reply)
Discussion started by: siri_886
1 Replies

7. Shell Programming and Scripting

How to fetch File from a URL to Unix Server?

Hello All, I wanted to get the software to be fetched from the Service Provide URL to my unix server. I tired using the mget, but resulted in error. Please take a look. $ wget -O V3-0-5-2.Solaris8-SPARC.tar.gz --http-user=hd87es3 --http-passwd=987dnja7 http://beyond.abinitio.com... (3 Replies)
Discussion started by: raghunsi
3 Replies

8. Shell Programming and Scripting

How to fetch data from oracle in unix shell script

Hi, How to fetch data from oracle database in unix shell scripting. list=`sqlplus -s ds_user/dsuser@EMI <<EOF set feedback off set serveroutput on set heading off set pagesize 0 set tab off select IP_ID from table / exit EOF` The output is not what i expected.I need output in... (4 Replies)
Discussion started by: Anusha_Reddy
4 Replies

9. Shell Programming and Scripting

How to sca a sequential file and fetch some substring data from it

Hi, I have a task where i need to scan second column of seuential file and fetch first 3 digits of that column For e.g. FOLLOWING IS THE SAMPLE FOR MY SEQUENTIAL FILE AU_ID ACCT_NUM CRNCY_CDE THHSBC001 30045678 THB THHSBC001 10154267 THB THHSBC001 ... (2 Replies)
Discussion started by: manmeet
2 Replies

10. Shell Programming and Scripting

How to fetch data from a text file in Unix

I want to fetch passwords from a common file xxxx.txt and use it in a script. Currently the password is hardcoded so this have to be changed so that password can be fetched from text file..... Please reply asap.. Thanks (4 Replies)
Discussion started by: shikhakaul
4 Replies
Login or Register to Ask a Question