# Bug? CSV node changing data

**URL:** https://discourse.nodered.org/t/bug-csv-node-changing-data/60058
**Category:** Dashboard
**Created:** [18 March 2022 21:20 UTC](https://discourse.nodered.org/t/bug-csv-node-changing-data/60058 "2022-03-18T21:20:26Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![dsplitz](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dsplitz/32/49940_2.png) [@dsplitz](https://discourse.nodered.org/u/dsplitz)
#### Post date: [18 March 2022 21:20 UTC](https://discourse.nodered.org/t/bug-csv-node-changing-data/60058/1 "2022-03-18T21:20:26Z")

</div>

The simple flow below shows what looks like the CSV node changing data values. The col3 result is not equal to the input. The input is 28429390120374275 but the output is 28429390120374276???  
Any thoughts on why???

```auto
[{"id":"4adb98c6.b11238","type":"tab","label":"Flow 1","disabled":false,"info":""},{"id":"2a244d6f.6c05da","type":"csv","z":"4adb98c6.b11238","name":"","sep":",","hdrin":"","hdrout":"none","multi":"mult","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":670,"y":460,"wires":[["13569c1f.edb324"]]},{"id":"1fed970b.fde539","type":"inject","z":"4adb98c6.b11238","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"2,normal,28429390120374275,1647637586609,1647637617744","payloadType":"str","x":380,"y":460,"wires":[["2a244d6f.6c05da","a30bb5ca.dad218"]]},{"id":"a30bb5ca.dad218","type":"debug","z":"4adb98c6.b11238","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":590,"y":360,"wires":[]},{"id":"13569c1f.edb324","type":"debug","z":"4adb98c6.b11238","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":880,"y":360,"wires":[]}]

```

Here is the debug node outputs.  
 ![Screenshot 2022-03-18 172153](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/3/e3ab49a788bcfe37ad778d414f59fd8fe204d105.png)

---

<div class="post-metadata">

### Author: ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [18 March 2022 21:38 UTC](https://discourse.nodered.org/t/bug-csv-node-changing-data/60058/2 "2022-03-18T21:38:39Z")

</div>

> [@dsplitz](#):
>
> 28429390120374275

If you try that in an inject node feeding a debug node you will find the same thing. The reason is that javascript holds numbers as double precision floating point numbers, and the maximum integer that can be held in that format without the possibility of rounding errors is 9,007,199,254,740,991. Your number has one more digit than that so cannot be held accurately. See [Number.MAX\_SAFE\_INTEGER - JavaScript | MDN](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Number/MAX_SAFE_INTEGER) for more details

---

<div class="post-metadata">

### Author: ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)
#### Post date: [18 March 2022 21:47 UTC](https://discourse.nodered.org/t/bug-csv-node-changing-data/60058/3 "2022-03-18T21:47:22Z")

</div>

(and if you turn off 'parse numeric value" then it will leave it as a string if you need to keep it and then maybe try to handle as a bigint later)

---

<div class="post-metadata">

### Author: ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [18 March 2022 21:49 UTC](https://discourse.nodered.org/t/bug-csv-node-changing-data/60058/4 "2022-03-18T21:49:40Z")

</div>

What does the number represent?

---

<div class="post-metadata">

### Author: ![dsplitz](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dsplitz/32/49940_2.png) [@dsplitz](https://discourse.nodered.org/u/dsplitz)
#### Post date: [19 March 2022 17:12 UTC](https://discourse.nodered.org/t/bug-csv-node-changing-data/60058/5 "2022-03-19T17:12:15Z")

</div>

Turning off "parse numeric value" is something I can make work.  
Thanks everyone.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)
#### Post date: [2 April 2022 17:12 UTC](https://discourse.nodered.org/t/bug-csv-node-changing-data/60058/6 "2022-04-02T17:12:52Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.
