title: Splunk query to extract string inside XML tag not working with spath command
body: <p>I am using the following query:</p>
  
  <pre><code>index=itx "PAD =" | dedup BOC | spath output=Channel path=AsRunMessage.Header.Channel  | table BOC, channel
  </code></pre>
  
  <p>which results in events with big xml content .. I need to extract the string "ITX1546" from inside the  tags.
  Also I need to create a table with distinct rows containing unique BOC values.
  The Channel field is not being populated.
  Here is the XML structure:</p>
  
  <p><a href="https://i.stack.imgur.com/uGzyi.gif" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uGzyi.gif" alt="enter image description here"></a></p>
  
  <p>Any ideas? Thank you</p>