Eliminating 0's when writing into the csv file

[alan.prakash]

Hello,

This is my sample excel file
Test.xlsx (14.2 KB)
When i covert this into csv format using write csv activity the 0’s are eliminating

Any idea about how to resolve this’
Thank you
Alan

[lrtetala (Lakshman Reddy)]

Hi @alan.prakash

Check on this thread

Leading 0s get eliminated while opening the CSV file in excel after writing to CSV

Hi All… Thanks … I found a way to resolve this and thought of sharing ,it may help others. If we add a TAB +convert(VARCHAR(10),Char(9)) at the end of the column value then it will not eliminate leading zeroes when csv is opened in excel and will not add qoutes as well when opened in notepad. I did this from the sql side. Thanks and Regards, Geetishree Rao

I hope it helps!!

[alan.prakash]

Where to add TAB +convert(VARCHAR(10),Char(9))**