EXPORT SQl to Flat File with Text format (Urgent Requirement)

Hi All,

I'm using export sql to flat file smart service configurations are as below.

Delimiter:","

Extension:"txt"

sql statment and JNDI.

 

When i execute the smart service if the record contains comma in any of the row that row is wrapped with double quotes, the rows which does not contains comma in the data is exported fine.

row 1:
1,sachin,tendulkar,12345

row 2

"2,Dravid,rahul,12,443"  (exported with double quotes)

here in the example of dravid the number 12443 contains comma, for numbers i can remove commas in my view , but if its a  free text, comma should be present

  Discussion posts and replies are publicly visible