Get rid of scientifc notation in exported CSV

Certified Lead Developer

Hello,

I'm using Export Data Entity to CSV smart service. This gives me CSV output and the CSV has a column named TransId, this column/field is a varchar in Appian.
It may contain text and/or sometimes just integer numbers more than 11 digits.

The problem here is when the value of this column is more than 11 digits then CSV by default shows value in a scientific format like 1.12233E+13 until the cell of the CSV is formatted to Integer.

Is there a way to get the value correctly by default?

(This smart service does not have input to take template unlike 'Export CDT to Excel' smart service).

  Discussion posts and replies are publicly visible