title: infopath cascaded dropdown displaying lookup field values in 1;#ABC format. Need to format the value as ABC without id
body: <p>I have a browser enabled infopath form with a dropdown box(cascaded), the data being retreived from an xml document. The data is in the following format-(as the value is retrieved from a lookup field.)</p>
  
  <p>item_number;#item_value</p>
  
  <p>how to show only the item_value in the dropdown box. Can I apply rules to the dropdown box or is there any way through code to achieve this?</p>
  
  <p>Thanks for the help!</p>
  
  <p>I found a similar post here <a href="http://www.infopathdev.com/forums/p/9964/35310.aspx" rel="nofollow noreferrer">cascaded dropdown look up field</a> but there are no proper solutions</p>
  
  <p>I found a solution but have trouble making it work,
  I am using a file query connection to get the data for the dropdown, i will be executing the connection and populating an xml document with the result. I am having trouble writing the content to xmldocument, see my question here-</p>
  
  <p><a href="https://stackoverflow.com/questions/5712295/infopath-filequeryconnection-executexpathnavigator-throws-system-net-webexcepti">Infopath FileQueryConnection.Execute(XpathNavigator) throws System.Net.WebException: Attempted to read or write protected memory</a></p>
  
  <p>I guess if this is solved, everything will be fine.</p>