double quotes

[kavuri]

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

[VCInDSX]

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,

[solaik]

Try this..

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

Regards,
Solai

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]

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

[ray.wurlod]

Change the Quote Character property to None.

[kavuri]

Thanks Ray