Leading zeros are removed when using tfileoutputdelimited

[HemaS1]

Hello,

I have data extracted from SQL server DB table and when it output to CSV file using tfileoutputdelimited the leading zeros are deleted. For example '02193' becomes '2193'.

I verified that the column has a datatype of string from DB to tfileoutdelimited.

Need help on how to fix this.

Thanks,

Hema

[HemaS1 · Accepted solution]

I just opened the file and look at it.

This is what I see... It is an comma seperated excel file.

[Anonymous]

Open the file using a text file reader. Something other than Excel.

[HemaS1]

Yes, Thank You!!

It is how you view the csv file. Instead of directly opening the excel CSV file I imported the data into a blank excel and viewed it and there it is. The values are populated correctly.

Appreciate your help on this.

[Anonymous]

No problem. It's always best to check the data sent to flat files in something like Notepad (for Windows) first. That will show you exactly what has been written to the file.