Hello, How All are Doing today. I have a issue, I have a file which contains the data as follow
<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.