CSV output file displays number field differently than app and body template data

[Daisy_Ramirez]

I have a workflow that generates a csv file with a preview of the data in the body of the email. The body template data displays correctly (8000) but the csv shows 8. Can’t remember having to do anything special on the csv for number data types. Any ideas? Thanks everyone

[GreenFlux · Accepted solution]

The comma in 8,000 is being split into a new column.

Look at Column F: There’s a zero between the 8 in Column E, and the $90.00 in G.

Is [vir_actual_miles] set as a text column?

[Daisy_Ramirez]

Oh wow, so I’d have to remove that thousands separated?

[Daisy_Ramirez]

Thank you! I removed the thousands separator and it worked. Will keep the text data type in my pocket for future scenarios as well.

Thanks again