Hello all, recently i have manage to split data from MQTT and saved as CSV ,thanks to forum member that really kind and helpfull. For now i want to do is add timestamp(if im not mistaken) which add date and time of data taken.the date and time is already stated in the MQTT and Node-red , how to ref…

the current view of node-red flow [image]

You should be able to add to the string in the change nodes. Try using $moment(), you can set the time zone if you wish to. JSONata expression "X-AXIS," & $$.payload.`X-AXIS` & $moment().tz("Asia/Tokyo").format(",DD/MM/YYYY,h:mm:ss a") https://momentjs.com/timezone/

thanks , i will try it and post the result here

[image] E1cid: "X-AXIS," & $.payload. X-AXIS & $moment().tz("Asia/Tokyo").format(",DD/MM/YYYY,h:mm:ss a") since i have 3 change node for 3 axis for y-axis "Y-AXIS," & $$.payload.Y-AXIS & $moment().tz("Asia/Tokyo").format(",DD/MM/YYYY,h:mm:ss a") for z-axis "Z-AXIS," & $$.payload.Z-AXIS & …

You have changed the payload coming in from the mqtt node. you no longer need the function node. I did mention this in the other thread.

yes, i did remove the function node but error occoured, i did send picture of the result to the other thread

Pictures are no good we need to see the expression you edited, we can not mind read the info.

ok noted, i will share the info

@dceejay @Colin can you merge the threads as they are about the same thing. [image] Help| how to split string from mqtt General i have send reading of accelerometer from MQTT to node-red in three axis (x -axis,y-axis and z-axis). however the message recieved is in the fo…

Node-RED

Node-RED Forum

Help| how to add timestamp into csv file

General

E1cid 27 July 2021 17:59 10

@dceejay @Colin can you merge the threads as they are about the same thing.

Topic		Replies	Views
Help\| how to split string from mqtt General	40	2713	10 March 2022
Event-trigger for join node General	18	327	6 January 2025
Add local date and time to a CSV-file General	6	1920	15 May 2021
How to insert a Timestamp in a CSV for each parsed tweet General	6	4195	22 December 2018
MQTT Messages to *.CSV? General	4	1442	18 June 2021

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.

Help| how to add timestamp into csv file

Related topics