Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I just opened the file and look at it.
This is what I see... It is an comma seperated excel file.
Open the file using a text file reader. Something other than Excel.
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.
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.