DSXchange

Hi,
I am having some of the fields Varchar and date fields are enclosed by double quotes in my terget csv files. I want to eliminate them. How can I do this?

Thanks
Kavuri

Kavuri,
Can you provide some more details about your job design?
Are you reading from a source, transforming and writing to a target file and seeing those quotes or....??
If your target is a sequential file stage, set the "Quote" property in the "Format" tab to "none".

Good luck,

Try this..

Trim(date column, """, "A")

Regards,
Solai

kavuri wrote:Hi,
I am having some of the fields Varchar and date fields are enclosed by double quotes in my terget csv files. I want to eliminate them. How can I do this?

Thanks
Kavuri

I am extracting from a db2 database. i haven't made any modifications but DataStage is giving double quotes around date fields in output csv files.

I need to eliminate them.

Thanks
Bhargava

Change the Quote Character property to None.

Thanks Ray