IPCC Script - Extract XML document data

[paulcian_2]

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>

[francis.labelle]

Look at Example 14-3 of the "CRS Step Editor Online Help" (the help of the CRS editor)

[francis.labelle]

Look at Example 14-3 of the "CRS Step Editor Online Help" (the help of the CRS editor)

[msmalley]

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.

[paulcian_2]

"/descendant::Locations/child::Branch[attribute::Seq='" + seq + "']/child::Distance"

Here is what I used. Thanks for all the POSTS