Converting data from CSV file

General
1

Hello

I am importing data from a CSV file using the csv parser and that all work great.

My problem is that I want to convert the timestamp of the data into something I can use in influxdb.
This is how it looks from the file.
201105104117 converted it's YYMMDDHHmmSS

How should I go about doing this?

2

The change node has the $moment function built in so you can use it to help parse like this

image
image1010×222 7.23 KB

[{"id":"54c46ebe.3b623","type":"change","z":"ab9333b5.f44f6","name":"Change node","rules":[{"t":"set","p":"payload","pt":"msg","to":"$moment(payload,\"YYMMDDHHmmSS\")","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":300,"y":2120,"wires":[["2c896b1f.98a694"]]}]
3

Thanks a lot for the help.

4

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