# Write data from 2 directions in different columns of csv file

**URL:** <https://discourse.nodered.org/t/write-data-from-2-directions-in-different-columns-of-csv-file/65450>\
**Category:** General\
**Created:** [22 July 2022 00:10 UTC](https://discourse.nodered.org/t/write-data-from-2-directions-in-different-columns-of-csv-file/65450 "2022-07-22T00:10:26Z")\
**Posts on this page:** 14\
**Page:** 2

<div class="post-metadata">

**Author:** ![tsuratolya](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/tsuratolya/32/59853_2.png) [@tsuratolya](https://discourse.nodered.org/u/tsuratolya)\
**Post date:** [22 July 2022 04:52 UTC](https://discourse.nodered.org/t/write-data-from-2-directions-in-different-columns-of-csv-file/65450/21 "2022-07-22T04:52:01Z")

</div>

Thanks, that was the reason.

---

<div class="post-metadata">

**Author:** ![tsuratolya](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/tsuratolya/32/59853_2.png) [@tsuratolya](https://discourse.nodered.org/u/tsuratolya)\
**Post date:** [22 July 2022 04:53 UTC](https://discourse.nodered.org/t/write-data-from-2-directions-in-different-columns-of-csv-file/65450/22 "2022-07-22T04:53:13Z")

</div>

We have all come to a decision.

---

<div class="post-metadata">

**Author:** ![tsuratolya](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/tsuratolya/32/59853_2.png) [@tsuratolya](https://discourse.nodered.org/u/tsuratolya)\
**Post date:** [22 July 2022 05:35 UTC](https://discourse.nodered.org/t/write-data-from-2-directions-in-different-columns-of-csv-file/65450/23 "2022-07-22T05:35:20Z")

</div>

I will add more information. My Excel is separated by ";" and not separated by a comma "," , so it didn't work for me. So division through ";".  
function

```auto
msg.payload = msg.payload.node1 + ";" + msg.payload.node2;
return msg;

```

---

<div class="post-metadata">

**Author:** ![Trying\_to\_learn](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/trying_to_learn/32/28400_2.png) [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Post date:** [22 July 2022 05:54 UTC](https://discourse.nodered.org/t/write-data-from-2-directions-in-different-columns-of-csv-file/65450/24 "2022-07-22T05:54:45Z")

</div>

If you are writing to the excel file, I don't understand why the `;` is the separator.

You can use just about anything to separate the values. Commas are used only as a default.

So I don't understand why you stated that Excel is separated by `;` and not `,`.

---

<div class="post-metadata">

**Author:** ![craigcurtin](https://avatars.discourse-cdn.com/v4/letter/c/94ad74/32.png) [@craigcurtin](https://discourse.nodered.org/u/craigcurtin)\
**Post date:** [22 July 2022 06:49 UTC](https://discourse.nodered.org/t/write-data-from-2-directions-in-different-columns-of-csv-file/65450/25 "2022-07-22T06:49:47Z")

</div>

Yep not exactly a CSV file if it has Semi Colons !

Craig

---

<div class="post-metadata">

**Author:** ![Trying\_to\_learn](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/trying_to_learn/32/28400_2.png) [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Post date:** [22 July 2022 06:51 UTC](https://discourse.nodered.org/t/write-data-from-2-directions-in-different-columns-of-csv-file/65450/26 "2022-07-22T06:51:23Z")

</div>

Yes, but as the CSV node supports alternate separators, _does it really matter_?

---

<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:** [22 July 2022 06:52 UTC](https://discourse.nodered.org/t/write-data-from-2-directions-in-different-columns-of-csv-file/65450/27 "2022-07-22T06:52:52Z")

</div>

That would be a SCSV. 😁

---

<div class="post-metadata">

**Author:** ![Frida](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/frida/32/68250_2.png) [@Frida](https://discourse.nodered.org/u/Frida)\
**Post date:** [22 July 2022 07:09 UTC](https://discourse.nodered.org/t/write-data-from-2-directions-in-different-columns-of-csv-file/65450/28 "2022-07-22T07:09:26Z")

</div>

In Europe we use ; to separate numbers in spreadsheets.  
Because we use , in decimal numbers, where you use .  
I write DKK 3,5, and you write DKK 3.5.

---

<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:** [22 July 2022 07:47 UTC](https://discourse.nodered.org/t/write-data-from-2-directions-in-different-columns-of-csv-file/65450/29 "2022-07-22T07:47:34Z")

</div>

and we still use , for thousands separator... eg 1,000,000.00 but CSV will use " to wrap values. So "1,000" or "DKK 3,5" is fine in a CSV

---

<div class="post-metadata">

**Author:** ![tsuratolya](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/tsuratolya/32/59853_2.png) [@tsuratolya](https://discourse.nodered.org/u/tsuratolya)\
**Post date:** [22 July 2022 07:53 UTC](https://discourse.nodered.org/t/write-data-from-2-directions-in-different-columns-of-csv-file/65450/30 "2022-07-22T07:53:41Z")

</div>

in the settings it is by default in excell. The comma didn't work for me. A ; semicolon works (there is a separation by columns)

---

<div class="post-metadata">

**Author:** ![Trying\_to\_learn](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/trying_to_learn/32/28400_2.png) [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Post date:** [22 July 2022 07:55 UTC](https://discourse.nodered.org/t/write-data-from-2-directions-in-different-columns-of-csv-file/65450/31 "2022-07-22T07:55:23Z")

</div>

I guess you have to use what works.

---

<div class="post-metadata">

**Author:** ![tsuratolya](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/tsuratolya/32/59853_2.png) [@tsuratolya](https://discourse.nodered.org/u/tsuratolya)\
**Post date:** [22 July 2022 08:03 UTC](https://discourse.nodered.org/t/write-data-from-2-directions-in-different-columns-of-csv-file/65450/32 "2022-07-22T08:03:33Z")

</div>

I'll throw off the code, maybe someone will need it. If the division by columns does not work for you, then put a function in the node instead of ; --\>

```auto
[
    {
        "id": "d50d7dd210330e6a",
        "type": "join",
        "z": "9ee2cc1b247fc8f4",
        "name": "",
        "mode": "custom",
        "build": "object",
        "property": "payload",
        "propertyType": "msg",
        "key": "topic",
        "joiner": "\\n",
        "joinerType": "str",
        "accumulate": true,
        "timeout": "",
        "count": "2",
        "reduceRight": false,
        "reduceExp": "",
        "reduceInit": "",
        "reduceInitType": "num",
        "reduceFixup": "",
        "x": 530,
        "y": 1780,
        "wires": [
            [
                "60fcd8185cc3fdb3",
                "bf89ee0167ff3cb6"
            ]
        ]
    },
    {
        "id": "967d0cd40dcda175",
        "type": "inject",
        "z": "9ee2cc1b247fc8f4",
        "name": "Inject 456",
        "props": [
            {
                "p": "payload"
            },
            {
                "p": "topic",
                "vt": "str"
            }
        ],
        "repeat": "",
        "crontab": "",
        "once": false,
        "onceDelay": 0.1,
        "topic": "node2",
        "payload": "456",
        "payloadType": "num",
        "x": 280,
        "y": 1820,
        "wires": [
            [
                "d50d7dd210330e6a"
            ]
        ]
    },
    {
        "id": "c3c4f37a3d8af719",
        "type": "inject",
        "z": "9ee2cc1b247fc8f4",
        "name": "Inject 123",
        "props": [
            {
                "p": "payload"
            },
            {
                "p": "topic",
                "vt": "str"
            }
        ],
        "repeat": "",
        "crontab": "",
        "once": false,
        "onceDelay": 0.1,
        "topic": "node1",
        "payload": "123",
        "payloadType": "num",
        "x": 280,
        "y": 1740,
        "wires": [
            [
                "d50d7dd210330e6a"
            ]
        ]
    },
    {
        "id": "60fcd8185cc3fdb3",
        "type": "debug",
        "z": "9ee2cc1b247fc8f4",
        "name": "Should be joined number",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": true,
        "complete": "true",
        "targetType": "full",
        "statusVal": "payload",
        "statusType": "auto",
        "x": 790,
        "y": 1780,
        "wires": []
    },
    {
        "id": "bf89ee0167ff3cb6",
        "type": "function",
        "z": "9ee2cc1b247fc8f4",
        "name": "function 1",
        "func": "msg.payload = msg.payload.node1 + \";\" + msg.payload.node2;\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 700,
        "y": 1860,
        "wires": [
            [
                "9e2323ce686d5a96",
                "859511f099f1c91b"
            ]
        ]
    },
    {
        "id": "9e2323ce686d5a96",
        "type": "debug",
        "z": "9ee2cc1b247fc8f4",
        "name": "Shoudl be CSV",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": true,
        "complete": "payload",
        "targetType": "msg",
        "statusVal": "payload",
        "statusType": "auto",
        "x": 880,
        "y": 1920,
        "wires": []
    },
    {
        "id": "859511f099f1c91b",
        "type": "file",
        "z": "9ee2cc1b247fc8f4",
        "name": "test write",
        "filename": "/home/pi/test-csv",
        "appendNewline": true,
        "createDir": true,
        "overwriteFile": "false",
        "encoding": "none",
        "x": 680,
        "y": 1920,
        "wires": [
            []
        ]
    }
]

```

---

<div class="post-metadata">

**Author:** ![tsuratolya](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/tsuratolya/32/59853_2.png) [@tsuratolya](https://discourse.nodered.org/u/tsuratolya)\
**Post date:** [22 July 2022 08:16 UTC](https://discourse.nodered.org/t/write-data-from-2-directions-in-different-columns-of-csv-file/65450/33 "2022-07-22T08:16:24Z")

</div>

I launch the mechanism of import which is built in Excel. On the menu it «Data → Get External Data → From Text».

---

<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:** [20 September 2022 08:16 UTC](https://discourse.nodered.org/t/write-data-from-2-directions-in-different-columns-of-csv-file/65450/34 "2022-09-20T08:16:27Z")

</div>

Closed on 20 September 2022 08:16 UTC

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

[Previous page](https://discourse.nodered.org/t/write-data-from-2-directions-in-different-columns-of-csv-file/65450.md?page=1)
