search

jlolling / talendcomp_tGoogleSheet

Talend components to read and write Google Sheets
Apache License 2.0
10 stars 0 forks source link

How to read the number with out comma 8,215,434 in number. #18

Closed gurusewack closed 1 year ago

gurusewack commented 1 year ago

I have read data from a Google Sheet with the datatype as String, but the numbers are in comma format. Please help me resolve this issue without commas.

Example: 8,215,434

This is the production issue of my project.

jlolling commented 1 year ago

This is the current default behaviour rendering numbers as String. You can better read the number as Long typed values and convert in a tMap into a String with String.valueOf(your_long_value). I am currently working the component to improve the error handling for authorization problems. I also change the number to String conversion and remove the grouping (thats what you are currently complaining).

jlolling commented 1 year ago

This problem is solved. Please download the new release (v6.0) in the Release section: https://github.com/jlolling/talendcomp_tGoogleSheet/releases

jlolling commented 1 year ago

Done

jlolling commented 1 year ago

Please download the release 6.1!

gurusewack commented 1 year ago

Thanks Jan I will download test it.

Sent from Outlook for Androidhttps://aka.ms/AAb9ysg

From: Jan Lolling @.> Sent: Wednesday, October 18, 2023 6:15:07 PM To: jlolling/talendcomp_tGoogleSheet @.> Cc: gurusewack @.>; Author @.> Subject: Re: [jlolling/talendcomp_tGoogleSheet] How to read the number with out comma 8,215,434 in number. (Issue #18)

Please download the release 6.1!

— Reply to this email directly, view it on GitHubhttps://github.com/jlolling/talendcomp_tGoogleSheet/issues/18#issuecomment-1768376115, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGBGYEPI3S2EMSLGFJQL43TX77FNHAVCNFSM6AAAAAA6EDFBAOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONRYGM3TMMJRGU. You are receiving this because you authored the thread.Message ID: @.***>