Csv filter separator and some value in cloumn is same

Hi,

"ID","FP_TRANSACTION_ID","REQ_BITSTREAM","REP_BITSTREAM","FAULT_BITSTREAM","FWD_BITSTREAM"
23596191,23596274,<input Service=""YesCustomerManagerService"" Operation=""inquireCasaAccountBalance( SessionContext, String)""><SessionContext><SupervisorContext><PrimaryPassword/><UserId/></SupervisorContext><BankCode>532</BankCode><Channel>BRN</Channel><ExternalBatchNumber/><ExternalReferenceNo/><ExternalSystemAuditTrailNumber/><LocalDateTimeText/><OriginalReferenceNo/><OverridenWarnings/><PostingDateText/><ServiceCode/><SessionTicket/><TransactionBranch>402</TransactionBranch><UserId>MOBUSER</UserId><ValueDateText/></SessionContext><ExtUniqueRefId>12345</ExtUniqueRefId><AccountNumber>545454</AccountNumber></input>, <?xml version=""1.0""?> <Exception><ErrorCode>2778</ErrorCode><ErrorMessage>Account not found</ErrorMessage><Response>99</Response><Reason/></Exception>,"",<input Service=""YesExtMobileService"" Operation=""inquireCasaAccountBalance( SessionContext, String)""><SessionContext><SupervisorContext><PrimaryPassword/><UserId/></SupervisorContext><BankCode>532</BankCode><Channel>BRN</Channel><ExternalBatchNumber/><ExternalReferenceNo/><ExternalSystemAuditTrailNumber/><LocalDateTimeText/><OriginalReferenceNo/><OverridenWarnings/><PostingDateText/><ServiceCode/><SessionTicket/><TransactionBranch>402</TransactionBranch><UserId>MOBUSER</UserId><ValueDateText/></SessionContext><ExtUniqueRefId>12345</ExtUniqueRefId><AccountNumber>545454</AccountNumber></input>

As you can see in the REQ_BITSTREAM, REP_BITSTREAM there is value which has "," (comma) in it but it's not a separate event. How do I make sure that both the coulmn get the complete data and still csv filter consider "," (comma) as a separator.

Thanks!!

A csv filter cannot parse that. A field can contain a comma, but in that case the entire field has to be quoted. That is not true of your text.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.