DSXchange

Hello all

It looks i have a weird Problem. I am attaching a file name xxx.csv in the notification email stage. Job will send the notification along with attachment xxx.csv.
In the sequential file stage, my formatting is 'quote=double" "delimiter=comma".
When i open the xxx.csv on unix, i can see a field data as "8-10". But when i check the xxx.csv in attachement i see 10-Aug. Whats happeining is varchar is being converted to data in the attachment. how can i solve this. Please reply.

Excel.

chulett wrote:Excel.

Yes.

I am getting the attachment as excel and varchar like "8-12" is converted to 12-Aug.

Right, that's what it does and there isn't a good way to stop it. Open the attachment in something like Notepad to see the 'real' source data. Change the extension if you want to prevent the file from being automatically associated with Excel.

You can add a space(" 8-10") or add single quotes ('8-10'), if it is acceptable to avoid conversion

You can certainly do that, as long as you don't mind the extra characters in the data and you keep in mind the fact that the moment someone 'fixes' them it will revert back to the date it thinks it is.

Format Cells in Excel to govern the display characteristics. Dates are actually stored in a binary format.

Sure... after the fact.