topic Re: tWriteJsonField BigDecimal value without scientific notation in Talend Studio

tWriteJsonField BigDecimal value without scientific notation

yome1 — Sat, 16 Nov 2024 01:57:31 GMT

Hello,

I have a job that write BigDecimal value into tWriteJsonField.

This value is 2168924589. Unfortunately i have this value in the output 2.168924589E9 of tWriteJsonField.

I would like to know if this is possible to keep the "plainText" value. I can use the toPlainText() but i will get a string not a number in the json and i want to keep this number format.

Thanks for your help!

Guillaume

Re: tWriteJsonField BigDecimal value without scientific notation

yome1 — Mon, 13 Jul 2020 14:00:42 GMT

I tried to use toPlainText() send this field as a string and add @type with number into the tree but this is not working.

Any ideas?

Re: tWriteJsonField BigDecimal value without scientific notation

yome1 — Mon, 13 Jul 2020 19:08:51 GMT

I set this field as String, populate the value using toPlainString() and then remove the "" using a replace... If someone has a better solution, please share 😉

Guillaume

Re: tWriteJsonField BigDecimal value without scientific notation

vikramk — Thu, 16 Jul 2020 14:59:33 GMT

Even if you replace " " your value will be in string type, if you are fine with the string data type you can go ahead. Please post your solution if you find a alternate way