Quote Missing in Output file

Roopanwita · Post by **Roopanwita** » Fri Feb 01, 2013 8:17 pm

Hi,

I am creating CSV files from table and in ,
Job desig is like Table --> transformer (used for datatype conversion as I changed all output to varchar).

From Source I have datatype like : Varchar, Decimal and Date .

I want output records with quote , like "A"."12","01/01/2013'."B". To achieve this in Sequential file

Input--> Fomat --> Field Default --> Quote --> double ( I have set this propery)

In output file (when I open in notepad/textpad) , I see quote for those fields onlt those are Varchar and date and Date.

Like "A".12,"01/01/2013'."B".
Whereever I have used DecimalToString conversion function ,quote is missing there.

Is there anyway I van get quote for all fields in output CSV file.

Thanks for reply

ray.wurlod · Post by **ray.wurlod** » Fri Feb 01, 2013 10:51 pm

That is correct under the CSV "standard" specified by Microsoft; numeric values are not quoted. To achieve it, simply change the data type to VarChar.

Roopanwita · Post by **Roopanwita** » Sat Feb 02, 2013 12:06 am

Thank you for response.

In source I have data type as float, in transformer I used decimaltoString function and converted to varchar.In target it is varchar only ,still it is not getting quote. Please let me know if there is any solution .

Thanks

ray.wurlod · Post by **ray.wurlod** » Sat Feb 02, 2013 12:30 am

All VarChar data types should be quoted by default. Can you open the extended properties of that particular column and see whether there is anything there that might change the default? You might also be able to see it in the record schema.

Roopanwita · Post by **Roopanwita** » Mon Feb 04, 2013 11:18 am

Thank you for response. It is working now by setting quote from extended property.

When I open extended property, for the column I used datatype conversion to float was missing. After I added quote over there it is working.

Thank you for solution.