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?