XQL and new Document Type

I have a new document type and I need to query the information from a field but its not that simple. The DUNS number for both companies is in one field seperated by a “-”. For example


Is the value of the field. Everything before the - is our number and everything after is their number.

I can query the field itself but I want to query just what is before and just waht is after the -. Basically splitting the value using a query. Can someone help?

Thank you.

XQL to get the element value–e.g. the entire string.

Then use pub.string:tokenize to split the string into two on the ‘-’ character.

XQL can queries to element level, not to a subset of data within the element.

Thanks reamon. I didn’t realize that I could put a custom transformation on the data. Thanks.