I have a grid where you input the XPath to retrieve the values from an XML file. Client wants the last four of the Credit Card. I have come up with the following XPath Substring statement, but my usual XPath statements start with // and in the code I use a SelectSingleNode or SelectNodes. Now I do not want a node, want the actual value. How do I take this XPath Substring and extract the last 4 of the Credit Card Number?
substring(//CREDIT_CARD/CARD_NBR, string-length(//CREDIT_CARD/CARD_NBR) - 3)