Data Exch import: get a substring of XML value

Maria-SMaria-S Member Posts: 90
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!
Sign In or Register to comment.