01-05-2006 05:32 AM - edited 03-13-2019 11:24 PM
Can anyone tell me how to write the expression to extract the Distance from the following XML output? We are using the Extract XML Document Data step from the scripting language but are unable to actually pull the data out.
<?xml version="1.0" ?>
- <Locations>
<Branch Name="Test">
<Distance>0 Miles</Distance>
<Phone />
<Open_Now>N/A</Open_Now>
<WAV>Location_000.WAV</WAV>
</Branch>
</Locations>
01-05-2006 07:52 AM
Look at Example 14-3 of the "CRS Step Editor Online Help" (the help of the CRS editor)
01-05-2006 08:00 AM
Look at Example 14-3 of the "CRS Step Editor Online Help" (the help of the CRS editor)
01-29-2006 12:22 PM
You would need to create an XPATH string variable and set it equal to:
/descendant::Locations/child::Distance
It should return the a string containing "0 Miles"
Hope this helps.
01-30-2006 06:48 AM
"/descendant::Locations/child::Branch[attribute::Seq='" + seq + "']/child::Distance"
Here is what I used. Thanks for all the POSTS
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: