Hello, I'm new to Node-RED. Having some trouble with sending data to CSV. I need two separate columns with different names and different data below for example but I'm getting everything in one line. Please tell me how to solve this. Thank you [{"id":"2f90ce8fb2a257e8","type":"tab","label":"Flow 2…

You are adding a \n in csv node, and also appending one in file write node. Either add one in csv node, or file write node, but not both nodes.

We cannot use that code, please replace by pasting the code into a preformatted text blog.

Looking at your function code you are sending a single object into the csv node. If you require multiple lines then you would need to send an array of objects, an object for each line. e.g. [ { "Time": 10, "Sensor": 50 }, { "Time": 15, "Sensor": 20 } ]

Yes. I see a single object on a debug node - (time with value and sensor with value). I want to get - (1 column - Time with value below), (2 column - Sensor with value below).

That is what you get. it is the followed by a carriage return \r and a new line \n. This is a text csv format. As image shows [chrome_screenshot_28 Mar 2024 17_40_10 GMT] Attach the file that is created after you click inject several times, as i see no errors.

Here - https://file.io/mguUlmI1rhfL

As said all working correct [Screenshot_20240328-174235] Unless you want one header row and only one value row, if so set csv node to always send header and file write node to overwrite and not append.

Hmm, maybe is something wrong with my Excel or something else, have no idea. This is what I want to achieve - [test]

When I open test,csv in my spreadsheet I get [Screenshot_20240328-175515] Must be an issue on your device/spreadsheet program if it is not opening like above.

So I achieved what I wanted just not for myself yet :smiley: I'll try to check my software settings later, whats wrong with my MS Excel.

Not a windows user, so can not help you there, sorry.

Node-RED

Node-RED Forum

Separate CSV columns

General

Topic		Replies	Views
Help - CSV node issue General	25	1642	21 February 2020
Write a string into a csv file General	19	9634	8 December 2020
CSV node outputs multiple identical lines General	5	611	10 November 2020
Generate CSV files General	3	1039	22 April 2021
'save to file' node, set the first row General	14	7368	23 June 2018

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Separate CSV columns

Related topics