Csv filter separator and some value in cloumn is same

[Nikhil_Pillai (Nikhil)]

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!!

[Badger]

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.