79500405

Date: 2025-03-11 10:30:10
Score: 1.5
Natty:
Report link

How can I change the CSV output such a way that it removes the trailing zeros and does not use exponential notation (without explicitly using Decimal(18,2) data type)?

Follow the below steps to get the expected output:

Step1: Please try using the following expression to achieve the expected results. replace(toString(toDecimal(Data)),'.00','') enter image description here

Step2: I have used the same sample data that you provided. enter image description here

Step3: Use the following expression in the derived column as required. replace(toString(toDecimal(Data)),'.00','') enter image description here

Step4: Output is as expected as per your requirement. enter image description here

Reasons:
  • Blacklisted phrase (0.5): How can I
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • Starts with a question (0.5): How can I
  • Low reputation (1):
Posted by: Jagadish S