Talend community forum / tFileOutputDelimited and number format in csv

l_tamas · 2012-02-14 18:53:00

Dear All!

I have been struggling with the above component. In case of large numbers they are automatically converted to scientific notation like 6.43E8.

Is there any way to change this behavious?

regards
tamas

pedro · 2012-02-15 04:21:44

Hi Tamas

This is due to CSV itself.
If the cell isn't long enough to show the entire number, it will be changed to scientific notation automatically.
Change(Drag) length of the cell. Then it will show you normal number.

Regards,
Pedro

l_tamas · 2012-02-15 09:43:07

Hi Pedro!

this happens even if you look at the csv itself in a texteditor. So this is not just a parsing issue.

pedro · 2012-02-15 09:46:53

Hi

Uh...Maybe you don't understand what i mean.

Here are two images.
The A1 cell in the first image is shorter than the A1 cell in the second image.

Regards,
Pedro

Uploaded Images

janhess · 2012-02-15 09:59:08

Pedro,
He means that the value is in the output file NOT the spreadsheet.

l_tamas · 2012-02-15 11:14:11

Try opening the file in notepad.

janhess · 2012-02-15 11:17:53

What have you defined the field as in the output file?

l_tamas · 2012-02-15 12:11:53

thanks for trying to help. the output format is double and this is how it looks in the raw file:
"6.43E8","6.43E8","6.434E8","6.434E8","4.95E8"

janhess · 2012-02-15 12:58:17

have you tried BigDecimal?

l_tamas · 2012-02-16 10:45:52

BigDecimal works differently but still not nice to read by humans. it looks like: 560000000.000000000

Announcement

Unanswered posts

#1 2012-02-14 18:53:00

tFileOutputDelimited and number format in csv

#2 2012-02-15 04:21:44

Re: tFileOutputDelimited and number format in csv

#3 2012-02-15 09:43:07

Re: tFileOutputDelimited and number format in csv

#4 2012-02-15 09:46:53

Re: tFileOutputDelimited and number format in csv

#5 2012-02-15 09:59:08

Re: tFileOutputDelimited and number format in csv

#6 2012-02-15 11:14:11

Re: tFileOutputDelimited and number format in csv

#7 2012-02-15 11:17:53

Re: tFileOutputDelimited and number format in csv

#8 2012-02-15 12:11:53

Re: tFileOutputDelimited and number format in csv

#9 2012-02-15 12:58:17

Re: tFileOutputDelimited and number format in csv

#10 2012-02-16 10:45:52

Re: tFileOutputDelimited and number format in csv

Board footer