Export to txt file and replace double quotes with blank

[Anonymous]

I would like to export data to a text file, see below syntax. With that being said, there are double quotes in my data that I would like removed and replace with a blank before I export. Is this possible. See my syntax below, which my replace function is throwing an error.

STORE [Que_012739],[Que_012740],REPLACE([Que_012740],'"','''') AS TEST

FROM [FOLLOW UP] INTO $(v_Export)FOLLOW_UP_Report.txt(txt) ;

[avinashelite]

I don't think in the STORE command you will have the option to change the format , you need to add this as a new column in the main table and then you need to store the same

REPLACE([Que_012740],'"','''') AS TEST

add this in the main table as the new column

then

STORE [Que_012739],[Que_012740],TEST

FROM [FOLLOW UP] INTO $(v_Export)FOLLOW_UP_Report.txt(txt) ;

[miguelbraga]

Hey there,

Can you please share with us a sample of your data or your qvw? I'm affraid you have a sintax error in your function.

Best regards,

D.A. MB