Trying to use more than 1 delimiter in SOAP Object Queries/Report XML's

Summary

Hi, I am looking forward to see if there is a way to use more than 1 delimiter in a SOAP Object Queries/Report XML's request.

Content

I am using the below sample SOAP request to get Incident-related details.

Request:

 <ns7:QueryCSV xmlns:ns7="urn:messages.ws.rightnow.com/v1_4">
            <ns7:Query>SELECT id,Incident.ReferenceNumber FROM Incident where id=5</ns7:Query>
            <ns7:PageSize>10000</ns7:PageSize>
            <ns7:Delimiter>#</ns7:Delimiter>
</ns7:QueryCSV>

 

Response:

 <n0:CSVTable>
                  <n0:Name>Incident</n0:Name>
                  <n0:Columns>ID#ReferenceNumber</n0:Columns>
                  <n0:Rows>
                     <n0:Row>5#170601-000001</n0:Row>
                  </n0:Rows>
     </n0:CSVTable>

 

In few cases, the query will have free text fields like comments, etc, single delimiter is not enough to separate columns in this case. Hence, I am trying for other options like below: