topic Re: How to extract string between tags from an XML file in Talend Studio

How to extract string between tags from an XML file

Anonymous — Wed, 25 Sep 2013 21:14:35 GMT

Hi all,
I am trying to extract text between two tags of an xml file, but with negative results.
This is the xml structure and I need to extract the contents of the body, for some post processing.

<soap:Envelope>
	<soap:Header>
	...
	</soap:Header>
	<soap:Body>
		<ns1:Response>
			<Object id="id:1234567890">
				....
			</Object>
		</ns1:Response>
	</soap:Body>
	</soap:Header>
</soap:Envelope>

I'm using the command tExtractXMLField, and these component properties:
- Property Type: Built-In
- Schema Type: Built-In
- XML field: Body
- Loop XPath query: "/Envelope/Body/*"
- Mapping: Column XPath query
Body "Body"
- Schema: Column Type ...
Body String ...
What's wrong? Probably wrong with the "Loop XPath query"?
Thanks in advance
Nic

Re: How to extract string between tags from an XML file

Anonymous — Thu, 26 Sep 2013 03:39:33 GMT

Hi
As a newbie, I would suggest you to use metadata manager to create a XML metadata follows the wizards, refer to Setting up an XML schema for an input file.
Here the Loop Xpath query should be:
"/soap:Envelope/soap:Body"
Shong

Re: How to extract string between tags from an XML file

Anonymous — Thu, 26 Sep 2013 18:01:54 GMT

Hi Shong,
first of all thanks for your response. The script xml I posted, is a soap response.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
   <soapenv:Header>
      <capabilities xmlns=........</capabilities>
   </soapenv:Header>
   <soapenv:Body>
		<ibisag:queryRegObjResponse xsi:schemaLocation=.........>
			<regObj id="id:obj:a1b2c3d4" objType="type:obj:abc0000">
				<rim:Slot name="Author" xmlns:rim=.......>
					<rim:ValueList>
						<rim:Value>MyName</rim:Value>
					</rim:ValueList>
				</rim:Slot>
				...
				...
				<rim:Slot name="email" xmlns:rim=".......>
					<rim:ValueList>
						<rim:Value>a@b.com</rim:Value>
					</rim:ValueList>
				</rim:Slot>
			</registryObject>
		</ibisag:queryRegistryRegObjResponse>
	</soapenv:Body>
</soapenv:Envelope>

My goal is to extract the contents of the tag email ... I did some testing with an xml file with "simple" tag (without namespace, etc.) and it works, unfortunately I can not with this structure .. would you help me please?
thank you so much
Nic

Re: How to extract string between tags from an XML file

Anonymous — Fri, 27 Sep 2013 04:30:05 GMT

Hi
You can extract the value of a element or an attribute, for example, you can extract the value
MyName
a@b.com
from the element rim:Value, rather than the whole content under the element <soapenv:Body>.
Can you please email me an exmaple of your soap response and let me know what data would you like to extract?
Shong

Re: How to extract string between tags from an XML file

Anonymous — Fri, 27 Sep 2013 13:52:47 GMT

Hi
You can extract the value of a element or an attribute, for example, you can extract the value
MyName
a@b.com
from the element rim:Value, rather than the whole content under the element <soapenv:Body>.
Can you please email me an exmaple of your soap response and let me know what data would you like to extract?
Shong

Email sent...
thanks

Re: How to extract string between tags from an XML file

Anonymous — Mon, 30 Sep 2013 09:39:18 GMT

Hi Shong,
did you get my email?

Re: How to extract string between tags from an XML file

Anonymous — Tue, 15 Oct 2013 11:34:09 GMT

Hi shong,
I want to remind you, when you can, to read my email.
Thanks for your interest.
Nic