Hi Experts,
I have an XML file with very long descriptions in one of the node. I would like to take only first 10 characters from the node.
Is it possible to do somehow with XPath?
I tried /CustData/Line/Item/substring(ItemDescription,1,10) as a "Path" in Column Definition, but this fails with error "expression must evaluate to a node-set".
It gives me an impression that I cannot use any modification functions in the "Path", but maybe there is a way?
Thank you for you time!
0