tWriteJsonField BigDecimal value without scientific notation

[yome1]

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

[yome1]

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?

[yome1]

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

[vikramk]

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