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

Parents
  • Hello Khartik

    I have seen this before

    Hello, We need to export all table and views from Database to CSV file through Appian process. The environment is setup in Appian cloud. The column data should be enclosed in double quotes and comma…
    By in Discussions > General
    7 replies

    Please tell me if it works or no.

    Best Regards

    Jose

Reply
  • Hello Khartik

    I have seen this before

    Hello, We need to export all table and views from Database to CSV file through Appian process. The environment is setup in Appian cloud. The column data should be enclosed in double quotes and comma…
    By in Discussions > General
    7 replies

    Please tell me if it works or no.

    Best Regards

    Jose

Children
No Data