topic Re: Add leading zero's to .csv in Talend Studio

Add leading zero's to .csv

peacekas99 — Sat, 16 Nov 2024 02:30:39 GMT

Hi guys,
 
I have a job reading from database input and writing to .csv file. I'm loosing zeroes from my number using .csv.
For example: "0078 becomes 78" or "0587 becomes 587".
My datatype is strong.
How can I keep my leading zero's?
Thanks.

Re: Add leading zero's to .csv

manodwhb — Wed, 06 May 2020 04:26:01 GMT

I believe in so rec side is string data type and when writing it CSV using tfileoutputdelimitted also you should have string data type and you open file in notepad++ and you will see the leading zeros.

Re: Add leading zero's to .csv

peacekas99 — Wed, 06 May 2020 06:25:16 GMT

I tried string too. The client wants to receive in .csv so is there a way in Talend to fix this issue of missing leading 0’s?

Re: Add leading zero's to .csv

manodwhb — Wed, 06 May 2020 07:46:15 GMT

@peacekas99, when your oven in notepad++ are you able to see leading zeros from that csv when you populated as a string? from excel you could not able to find until you format that column

Re: Add leading zero's to .csv

peacekas99 — Wed, 06 May 2020 08:00:12 GMT

Yes when I open with notepad+ I see leading zeros. But how can I make that possible with Talend studio job when writing results to .csv file? Is that possible?

Thanks.

Re: Add leading zero's to .csv

manodwhb — Wed, 06 May 2020 10:07:55 GMT

@peacekas99 ,which means you have in your CSV file but when open in excel is will not show until you format it, it is the behavior of excel software. It is not Talend software issue.

Re: Add leading zero's to .csv

peacekas99 — Wed, 06 May 2020 18:04:45 GMT

Oh ok I thought you can use Talend to fix that issue. Thanks